Page 1 of 1

Issues with the new FK update

Posted: Sun Jan 17, 2010 8:32 pm
by ZexisStryfe
So John, you say you haven't had any issues? Check this out...

I manually updated all my tables to InnoDB and manually ran the FK updates. Then, when I upgrade to SVN 375 I get all the errors shown in the attachment. I figure something isn't kosher with my DB so I create a new one and let everything download from the Updater. Everything seems good. Then I import my data (just data, no structs) and all the errors come back! Any ideas?

Re: Issues with the new FK update

Posted: Mon Jan 18, 2010 8:12 am
by John Adams
Did you apply the table_versions update I posted in that thread? ;)

Once you update your tables manually, you have to tell your world to match the current known versions of those tables, or it will attempt to update them still.

If that is not the problem, you should turn on Verbose Updates so we can see the exact error.

Re: Issues with the new FK update

Posted: Mon Jan 18, 2010 11:19 am
by ZexisStryfe
No John, I didn't. I don't compile the source, I used the latest SVN. The thing is, the second DB I tried updated from the server, not from my manual doings, yet I still got the errors after importing my data (I did not import the structure of the original DB, only the data).

Re: Issues with the new FK update

Posted: Mon Jan 18, 2010 11:26 am
by ZexisStryfe
Aha! After turning on verbose I discovered the error... my table versions table was borked up.

Re: Issues with the new FK update

Posted: Mon Jan 18, 2010 12:19 pm
by John Adams
Weird. I read something about that somewhere :P