MySQL Forums
Forum List  »  Newbie

Re: PLS HELP: ERROR 1452 (23000) Foreign Key Constraint
Posted by: Roland Chan
Date: April 06, 2011 02:15PM

I think I may have solved it! Maybe this will help someone else.

1. I was using mixed-case table names
2. I was using MySQL on OS/X, and I just discovered lower_case_table_names are set to 2 by default.
3. InnoDB databases should have this value set to 1 regardless of platform.
4. A quick change to lowercased table names resolved the issue.

Next step will be to change the default server value to 1 per the docs: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.