Hi all!

I have the following schema.yml file for my database definition:

Section:
  actAs:
    I18n:
      fields: [name]
  columns:
    name:
      type: string(30)
      notnull: true
    color: string
    urlShortDesc: string

Page:
  actAs:
    I18n:
      fields: [name,html,urlShortDesc]
  columns:
    name: string
    gender:
      type: enum
      values: [html, photoGallery]
      default: html
    html: string
    urlShortDesc: string
    section_id:
      type: integer
      notnull: true
  relations:
    Section:
      foreignAlias: Pages
    SubPage:
      class: Page
      local: subpage
      foreign: id
      type: one


I'm trying to implement a self-relationship in class Page but when I
run the command buil-all-reload, I get the following error message:
"SQLSTATE[42000]: Syntax error or access violation: 1072 Key column
'subpage' doesn't exist in table"

Can anyone give me some help?

Thanks in advance,
Best regards!

--

You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en.


Reply via email to