CiviCRM Community Forums (archive)

Hi. I've been having foreign key issues attempting to upgrade from 1.9.13019 to 2.0.3 and now 2.0.4. We're using MySQL 5.0.45 and PHP   5.2 (5.2.3-1ubuntu6.3). Despite numerous attempts to move forward with this (normalizing the schema/rebuilding database as instructed in documentation, filling and/or removing FK data, removing/modding existing table structures) --- I constantly get this error message:

"Sorry. A non-recoverable error has occurred.

Database consistency check failed for step 1. FK constraint names not in the required format. Please rebuild your 1.9 database to ensure schema integrity.

Return to home page."

I've searched hard for answers (ex. followed this thread and references - http://forum.civicrm.org/index.php/topic,3180.0.html) to no avail. Wasn't able to get any relevant info from insert debugging code in the DAO.php file either. Like similar posts, is there any way to narrow this down to specific tables or get a more detail error message? Is there anyway that my database can be looked at?

I feel like I'm losing my grip on reality at this point and could really use some outside eyes/hands here.  Thanks in advance  .

Thanks for the quick reply. I've checked my databases (both production and dev) for the noted keys and see that they all exist with those exact names. Should they all be changed to a particular type or assigned a standard value? Are those the only FK keys that should be present in a 1.9 database?

This is my third CiviCRM upgrade and I'm pretty solid with SQL & PHP, so I don't think that I exactly need professional services like that. I just need to get some clarification on what needs to done to my database's structure to get to the next step of this upgrade (ultra frustrating at this point). For as much as I've seen in the Forums here regarding upgrade problems, I'm kinda surprised that it's so hard to find detailed feedback about this particular or particular type of problem (not a knock on another or anything, just a general point).

Thanks again for any response in advance!!!