readthefuckingmanual.net

[SOLVED] mysql error 1005

Error added: 2009-07-27T11:39:02Z

0 people waiting for the answer...

1 answers found.

Answer 1046 (0.0% helpful)

multiple problems. First if you are using innodb engine, check your table logical constistency :
- indexes name must be unique
- fk must NOT have the same name as the the table field
- fk field type MUST be the same on each part of the association
- you must not copy the mysql table file manualy this may put you in this case, if so try an export and re-import the table an a fresh install.

This error is pretty tricky and has many sources.

I Hope this helps,

Nicolas Verriest
nicolas.verriest@--nospam--@gmail-dot-com
Permalink

Add an answer/solution

If you know the answer, please add your own solution below.
If you don't know, but find out later, please come back and share your answer - there will be other people struggling with this too.


Please enter 61948 here

If you want to be notified via email when this is solved, enter your email address here: