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?
Issues with the new FK update
Moderator: Team Members
Forum rules
Make sure your questions are detailed, intelligent, and relating to the default EQ2Emulator Database Schema.
Questions about how to build your own custom server content will not be addressed here.
Make sure your questions are detailed, intelligent, and relating to the default EQ2Emulator Database Schema.
Questions about how to build your own custom server content will not be addressed here.
- ZexisStryfe
- Posts: 1026
- Joined: Thu Jul 26, 2007 6:39 am
- EQ2Emu Server: Sytherian Legends
- Location: Connecticut
- Contact:
Issues with the new FK update
You do not have the required permissions to view the files attached to this post.
- John Adams
- Retired
- Posts: 9684
- Joined: Thu Jul 26, 2007 6:27 am
- EQ2Emu Server: EQ2Emulator Test Center
- Characters: John
- Location: Arizona
- Contact:
Re: Issues with the new FK update
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.
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.
- ZexisStryfe
- Posts: 1026
- Joined: Thu Jul 26, 2007 6:39 am
- EQ2Emu Server: Sytherian Legends
- Location: Connecticut
- Contact:
Re: Issues with the new FK update
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).
- ZexisStryfe
- Posts: 1026
- Joined: Thu Jul 26, 2007 6:39 am
- EQ2Emu Server: Sytherian Legends
- Location: Connecticut
- Contact:
Re: Issues with the new FK update
Aha! After turning on verbose I discovered the error... my table versions table was borked up.
- John Adams
- Retired
- Posts: 9684
- Joined: Thu Jul 26, 2007 6:27 am
- EQ2Emu Server: EQ2Emulator Test Center
- Characters: John
- Location: Arizona
- Contact:
Re: Issues with the new FK update
Weird. I read something about that somewhere 
Who is online
Users browsing this forum: No registered users and 0 guests


