This forum is in READ-ONLY mode.
You can look around, but if you want to ask a new question, please use the new forum.
Home » support » symfony 1.3 and 1.4 » Problem with doctrine:insert-sql/doctrine:build-model
Problem with doctrine:insert-sql/doctrine:build-model [message #103042] Sun, 25 July 2010 00:27 Go to next message
TimB  is currently offline TimB
Messages: 14
Registered: June 2010
Location: Düsseldorf, Germany
Junior Member
Hey guys,

i've got a little problem with doctrine:insert-sql. It seems as there are old indices left in the database (MySQL InnoDB) and the following error message comes up:

Quote:


SQLSTATE[HY000]: General error: 1005 Can't create table 'csmtools.#sql-2a0_7e' (errno: 121). Failing Query: "ALTER TAB
LE group_permission ADD CONSTRAINT group_permission_category_id_group_permission_category_id FOREIGN KEY (category_id) R
EFERENCES group_permission_category(id) ON DELETE RESTRICT". Failing Query: ALTER TABLE group_permission ADD CONSTRAINT
group_permission_category_id_group_permission_category_id FOREIGN KEY (category_id) REFERENCES group_permission_category
(id) ON DELETE RESTRICT



How could I solve this problem?

---

When I call the doctrine:build-model task, it gives out some file_get_contents(...): failed to open stream errors, after I moved my model files to a package (using the package: blabla in the yml file and regenerating the model), but doctrine is somehow still searching for the old model files. How can I tell him not to do that?

Thanks in advance,
Tim
Re: Problem with doctrine:insert-sql/doctrine:build-model [message #103071 is a reply to message #103042 ] Mon, 26 July 2010 08:39 Go to previous message
TimB  is currently offline TimB
Messages: 14
Registered: June 2010
Location: Düsseldorf, Germany
Junior Member
Problem solved by deleting the physical InnoDB files from HDD. Not a very convenient way, but after that it worked.
Previous Topic:How to disable session in the framework?
Next Topic:[SOLVED] Problem with propel and modified columns
Goto Forum:
  

powered by FUDforum - copyright ©2001-2004 FUD Forum Bulletin Board Software