You should really go into WinMySqlAdmin.exe and go to the databases tab. Right click on your eq database and then drop it. Then shutdown BOTH winmysqladmin AND the actual sql server by right clicking anywhere in the winmysqladmin window.
Then copy over the db.sql file from the .1.9.zip emu file to the /bin/ directory of mysql.
Run winmysqladmin.exe again to restart your server. Go back to the databases tab and create the 'eq' database again.
Exit from winmysqladmin (but don't shut down the server). Start up mysql.exe in the mysql/bin/ directory. Type:
use eq
then type
source db.sql
let it insert everything. This should all sound familiar. This really is the only way to be sure that you'll have no "bad" tables in your database. If you're simply upgrading your eq database...you can run into problems like you mention above.
At this point, you've done a fresh db install and should be good to go...worked for me :p
__________________
Better to light a candle than to curse the darkness.
|