What this says is that the program is trying to select
guid, account, data, name, race, class, position_x, position_y, position_z, map, orientation, taximask, cinematic, totaltime, leveltime, rest_bonus,
logout_time, is_logout_resting, resettalents_cost, resettalents_time, trans_x,
trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone,
online, death_expire_time, taxi_path, dungeon_difficulty, arena_pending_points
from the characters table and i'm guessing account 2. But it hits an error when it gets to the column 'extra_flags'. Either that column doesn't exist anymore or it has been renamed to something else. Since I can't see exactly what your'e databases look like it would be easier for you to fix the error. But its pretty easy. Since you know where the error is now.
Make backups of any databases you're editing that have data in them.
Open up navicat and create a new database called "new_characters" or whatever so you can tell it apart. Right click on it and execute batch file....then choose the characters.sql file that is in Oatman's Trinity Rev 1 repack. Once you're done with that, you should see all the tables in the window on the right hand side. Right click on the table 'characters' and choose design view. Then, switch back to the main navicat window and go to your current characters database. Open it so you see the tables in the right hand window then right click on 'characters' and choose design view. Now you have both tables open with tabs at the top.
Look between them for the changes. You should see somewhere that there is a row missing or that has a different name. You can rename it so that it has the same name as the new_characters database. You also want to make sure that the other options in the row are right. For example if its bigint, 40, 0, and allow null or whatever. Pretty easy to figure that out. If you have to add a coulmn (row) it will add at the bottom of the other rows. Use the buttons to move it in the right place. You can actually click on the tiny arrow at the left of row to select a whole row and then copy it and paste it back to your other characters table. When you're done save the table. Since you have two similar tables open, make sure you're editing the correct one before you make the changes.
It looks like the other errors you have are in 'character_instance', 'character_spell', and 'character_tutorial'.
There may be others too. Once you complete one, restart teh server and see if it lists any more errors.
I don't have internet right now so I'm not online alot. But I'll be online again tomorrow from 2:00 - 3:30 (EST, GMT -5)
Add me on msn and I'll walk you through it if you haven't fixed it yet.
jimgrubb@gmail.net
Posted 1 year ago » Permalink
