[symfony-users] Re: Error creating database on ALTER TABLE..

2009-10-20 Thread cosmy
Maybe.. i've done what you sai, setting "setnull: true" o these fields, but the error persist. It seems to be fault on the "onDelete: SET NULL" property on doctrine schemas foreign keys. If i remove these it works!!! But i don't want to remove the foreign field.. On 18 Ott, 11:04, Yahel wrote: >

[symfony-users] Re: Error creating database on ALTER TABLE..

2009-10-20 Thread Yahel
Hi. I think its because you're trying to set idCategory as null (in the forien key) while the field defined as 'notnull: true' . you should change the forien key (under relation) or idCategory definition. --~--~-~--~~~---~--~~ You received this message because yo

[symfony-users] Re: Error creating database on ALTER TABLE..

2009-10-19 Thread Hong Kil Dong
The problem might be in autogenerated "id" field on "Category" - if Doctrine generates its type different from "idCategory" field that you've set explicitly. (integer might be mapped to TINYINT, SMALLINT, MEDIUMINT, ... ) Try to set both explicitly the same type ( for instance integer(4) ) On Oct

[symfony-users] Re: Error creating database on ALTER TABLE..

2009-10-18 Thread cosmy
No, on doctrine it's SET NULL separated. On 17 Ott, 18:06, Gábor Fási wrote: > Never used doctrine, but in propel it is "setnull", so without the space. > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "symfony us

[symfony-users] Re: Error creating database on ALTER TABLE..

2009-10-17 Thread Gábor Fási
Never used doctrine, but in propel it is "setnull", so without the space. On Sat, Oct 17, 2009 at 17:36, cosmy wrote: > > Hi all. > I'm receving this error while i do doctrine:build-all or insert-sql: > SQLSTATE[HY000]: General error: 1005 Can't create table > 'ssm.#sql-9cc_12' (errno: 150). Fai