Ok, I have searched and have not run across any forums so if I missed an answer to this, I apologize. Here is what is going on.
I have a fully functional 1.12.x mangos server running shivva amber. Everything works fine, no problems. I have been testing a 2.0.1 server. I finially got 2.0.1 running with sdb 0.5.4 changeset. No problems there either (that I have seen, everything loads and what not).
I am currently using the Mangos DB handler program from bluesailor.net, it works great. I have done a character export on my 1.12 and tried to import it on the 2.0.1 test server...It looks as though everything is starting to load fine, but gets the fatal exception error [IMG]file:///C:/DOCUME%7E1/jmunson/LOCALS%7E1/Temp/moz-screenshot.jpg[/IMG] (as you can see from the attachment). The accounts roll over, but that is all after the error.
Does anyone know how to fix this error or another method of what to do to transfer accounts. I have a feeling since I am running mangos revision 3011, that I should upgrade to the latest and try again, but havent tested the changes as well.
Any advise would be appreciated greatly.
Thanks to all in advance!
There's a lot of people that have the same problem. It's due to the fact that the table properties are different in the newer SDBs. The only way to fix this is by manually exporting all the tables relating to characters from your 1.12.x DB, compare the table structure to the new 2.0.1 ones, then edit the 1.12.x dumps accordingly.
Ill check into this asap and let you know. Quick question though, How do I find all tables related to the characters? What are the common tables that I should look at?
Thanks~!
I found the table it kept crashing on and fixed it. It now imports without errors and the mangos database handler shows all characters from accounts, and all looks in order. Problem is, when you go to login, no characters are there....
Any advise?
are you importing all the realm tables too? If not, you need to, simply because the table "realmcharacters" is what actually tells the server how many characters each account has.
I believe the answer to this question will fix a lot of issues, I am planning a walk through on importing properly once I get this part fixed. Attached is the login error from mangos:
ERROR: Player #6 have broken data in 'data' field. Cannot be loaded.
Does anyone know which table I need to modify for this? I have searched table after table but to no avail. Everything else in the database handler is perfect...I think this is the last part that needs to be addressed.
Thanks in advance.
Reply With Quote
