[FLOW3-general] mysql error (errno: 150) when executing doctrine:update

indira indira at seethroughweb.com
Wed Oct 31 21:16:32 CET 2012


Hi everyone:

I changed the server for my app, I am still using flow3 and everything was 
fine before. But now everytime I execute ./flow3 doctrine:update I get this 
error:

Uncaught Exception
  SQLSTATE[HY000]: General error: 1005 Can't create table
  'zadmin_flow3.#sql-49a3_162' (errno: 150)

This error is related to foreign keys.
When I check the log files in Data/Logs/Exceptions I get errors like this 
one:

PDO::query("ALTER TABLE stw_fitnessone_domain_model_exercise ADD CONSTRAINT 
FK_D4FDFDF2BC91F416 FOREIGN KEY (resource) REFERENCES 
typo3_flow3_resource_resource (flow3_persistence_identifier)")

I deleted all my tables and emptied the resource table. Then I execute the 
doctrine:update again, but still get the same mysql 150 error.

Why is this happening?
Thanks in advance for your help,

Indira.




More information about the FLOW3-general mailing list