[symfony-users] Re: Doctrine schema for a widget system ?

2010-02-21 Thread ju1ius
This is my first attempt: config/doctrine/schema.yml: --- User: actAs: Sluggable: unique: true fields: [first_name, last_name] columns: first_name: string(25) last_name:string(25) UserNewsWidget: columns:

Re: [symfony-users] Re: Doctrine schema for a widget system ?

2010-02-21 Thread Jonathan Wage
I think user is a reserved word :) Try changing the table name. - Jon On Sun, Feb 21, 2010 at 6:48 PM, ju1ius jules.berna...@gmail.com wrote: This is my first attempt: config/doctrine/schema.yml: --- User: actAs: Sluggable: unique: true

[symfony-users] Re: Doctrine schema for a widget system ?

2010-02-21 Thread ju1ius
Thanks for your quick answer, but I changed all occurences of 'user' by 'testuser' and I still have the same error. Which is pretty weird since it since unrelated with the inheritance stuff... Anyway, any advice on the design question ? On 22 fév, 00:50, Jonathan Wage jonw...@gmail.com wrote: I

Re: [symfony-users] Re: Doctrine schema for a widget system ?

2010-02-21 Thread Jonathan Wage
Ah, the issue is that foreign keys and primary keys must be exact same type, length, etc. in mysql and other dbms. Your foreign key is length 4 but the default primary key is not 4. Try explicitly defining your primary key and making sure it is the same as your foreign keys. As for the design, I