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 17, 6:36 pm, cosmy <[email protected]> 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). Failing Query: ALTER TABLE skill ADD > CONSTRAINT skill_idcategory_category_id FOREIGN KEY (idcategory) > REFERENCES category(id) ON DELETE SET NULL > > However it creates the tables (the first part of the generated SQL) > and gets this error without going forward. > Do you have an idea about this problem? > Should this error be connected to another error i receive if i try to > make a leftJoin between Interview and Category in my model? > > Thank you in advance > > P.S.: This is my schema: > #schema modello > > Category: > actAs: { Timestampable: ~ } > columns: > name: { type: string(255), notnull: true, unique: true } > > Skill: > actAs: { Timestampable: ~ } > columns: > idCategory: { type: integer, notnull: true } > tipo: { type: string(255) } > question: { type: string(255), notnull: true } > name: { type: string(255) } > relations: > Category: { onDelete: SET NULL, local: idCategory, foreign: id, > foreignAlias: Skills } > > Attitude: > actAs: { Timestampable: ~ } > columns: > tipo: { type: string(255) } > question: { type: string(255), notnull: true } > name: { type: string(255) } > > PersonalInformation: > actAs: { Timestampable: ~ } > columns: > tipo: { type: string(255) } > question: { type: string(255), notnull: true } > name: { type: string(255) } > > Answer: > actAs: { Timestampable: ~ } > columns: > idSkill: { type: integer } > idAttitude: { type: integer } > idPersonal: { type: integer } > idInterview: { type: integer, notnull: true } > val: { type: string(255) } > relations: > Skill: { onDelete: SET NULL, local: idSkill, > foreign: id } > PersonalInformation: { onDelete: SET NULL, local: idPersonal, > foreign: id } > Attitude: { onDelete: SET NULL, local: idAttitude, > foreign: id } > Interview: { onDelete: SET NULL, local: idInterview, > foreign: id } > > Interview: > actAs: { Timestampable: ~ } > columns: > idCategory: { type: integer, notnull: true } > author: { type: string(255), notnull: true } > customer: { type: string(255), notnull: true } > agency: { type: string(255) } > candidate: { type: string(255), notnull: true } > relations: > Category: { onDelete: SET NULL, local: idCategory, foreign: > id, foreignAlias: Interviews } --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
