I'm sorry I've just posted a similar question.. However i have the same problem, only on one database but I think it's a problem of alter table or foreign keys, and it doesn't work if I execute doctrine:insert-sql.. so you can delete my post if you want, and we'll continue on this.
I use mysql Server version 5.1.37 under macosx, if it could be usefull.. Thank you and sorry again On 17 Ott, 12:00, Bertrand Zuchuat <[email protected]> wrote: > Hi Jon, > > I have a problem with doctrine command line on symfony 1.3. For my > project, i use 2 databases with some cross join db. > > if i start the doctrine:build-all, i have this error: > SQLSTATE[HY000]: General error: 1005 Can't create table './db1/ > #sql-64_2d.frm' (errno: 150). Failing Query: ALTER TABLE > db1.review_list ADD CONSTRAINT reviewlist_ils_login_fk FOREIGN KEY > (ils_login_id) REFERENCES db2.ils_login(id) ON DELETE RESTRICT > > But if i use separate command > ./symfony doctrine:drop-db > ./symfony doctrine:build-db > ./symfony doctrine:build-model > ./symfony doctrine:build-sql > ./symfony doctrine:insert-sql > > This is ok. > > Why ? I don't understand. > > Thank you for your help. > > Bertrand (Garfield-fr) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
