rebuke
-
Posts
2 -
Joined
-
Last visited
Posts posted by rebuke
-
-
Having trouble updating my world DB to the point where the worldserver executable will stop giving me unknown entry errors.
I've ran the update batch file (for windows), and I've got 5 world_update sql files in my updates directory, along with the update_1,2, etc folders.
world_updates ( the one that is modified with the batch file I believe) executes fine in sqlyog, but when I go to execute world_updates1 I run into many errors.
Query:CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ciError occured at:2013-02-14 21:06:29Line no.:3Error Code: 1007 - Can't create database 'world'; database existsQuery:CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ciError occured at:2013-02-14 21:06:50Line no.:3Error Code: 1007 - Can't create database 'world'; database existsQuery:DROP TABLE IF EXISTS `access_requirement`Error occured at:2013-02-17 17:26:08Line no.:22Error Code: 1046 - No database selectedQuery:UPDATE `version` SET `db_version`='TDB 335.49', `cache_id`=49 LIMIT 1Error occured at:2013-02-17 17:27:09Line no.:2Error Code: 1146 - Table 'world.version' doesn't exista portion of the sqlyog error file after the execution of world_updates1 aborts.Ideas?
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted
Hrmm.. If you're referring to the "cant create database" parts, yes they are in plain site I'd have to say, however it is definitely errors plural. My first reaction when troubleshooting was to delete world. Which I did. Script wouldn't execute until I executed TDB FULL 434. So I did that. Then I tried to run updates again. Same problem(s). Back to square one. I took my best shot last night before I posted this.
I also find it odd that world_updates4 and world_updates all execute perfectly. but updates1,2,and 3 all give errors similar to the above.