Issues with the new FK update

This forum is for problems that arise with the Database Schema as it is developed, or questions you have regarding how to utilize the database.

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.
Post Reply
User avatar
ZexisStryfe
Posts: 1026
Joined: Thu Jul 26, 2007 6:39 am
EQ2Emu Server: Sytherian Legends
Location: Connecticut
Contact:

Issues with the new FK update

Post by ZexisStryfe » Sun Jan 17, 2010 8:32 pm

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?
You do not have the required permissions to view the files attached to this post.
~ EQ2 Emulator Project Manager

Image
Image
Image
"Zexis, from this day forth, you shall be known as... '3 of 6'" - John Adams

User avatar
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

Post by John Adams » Mon Jan 18, 2010 8:12 am

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.

User avatar
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

Post by ZexisStryfe » Mon Jan 18, 2010 11:19 am

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).
~ EQ2 Emulator Project Manager

Image
Image
Image
"Zexis, from this day forth, you shall be known as... '3 of 6'" - John Adams

User avatar
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

Post by ZexisStryfe » Mon Jan 18, 2010 11:26 am

Aha! After turning on verbose I discovered the error... my table versions table was borked up.
~ EQ2 Emulator Project Manager

Image
Image
Image
"Zexis, from this day forth, you shall be known as... '3 of 6'" - John Adams

User avatar
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

Post by John Adams » Mon Jan 18, 2010 12:19 pm

Weird. I read something about that somewhere :P

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests