wrsson
New Member
- Joined
- Jan 31, 2009
- Messages
- 28
- Reaction score
- 0
I thought i would give it a go updating my server to 8.54 so i dled it etc and when its updates my database now the old 8.5 wont work with it im getting a few errors
[01/03/2010 00:16:36] Saving server...
[01/03/2010 00:16:36] > MySQL ERROR mysql_real_query: UPDATE `players` SET `level` = 79, `group_id` = 1, `vocation` = 4, `health` = 1355, `healthmax` = 1355, `experience` = 7615400, `lookbody` = 44, `lookfeet` = 44, `lookhead` = 44, `looklegs` = 44, `looktype` = 136, `lookaddons` = 0, `maglevel` = 0, `mana` = 425, `manamax` = 425, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 777, `posy` = 694, `posz` = 4, `cap` = 2370, `sex` = 0, `lastlogin` = 1267387479, `lastip` = 16777343, `conditions` = '', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1267387475, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 24 LIMIT 1; Unknown column 'redskulltime' in 'field list'
[01/03/2010 00:16:36] > MySQL ERROR mysql_real_query: UPDATE `players` SET `level` = 1337, `group_id` = 3, `vocation` = 23, `health` = 37313, `healthmax` = 30585, `experience` = 39654617600, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 266, `lookaddons` = 0, `maglevel` = 12, `mana` = 12660, `manamax` = 12660, `manaspent` = 35803188, `soul` = 114, `town_id` = 1, `posx` = 781, `posy` = 693, `posz` = 4, `cap` = 10000, `sex` = 0, `lastlogin` = 1267393075, `lastip` = 16777343, `conditions` = '', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1267387512, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 2 LIMIT 1; Unknown column 'redskulltime' in 'field list'
Just wondered if there anyway to "unupdate" and revert my database so its all fine with 8.5
I know i should have backed up but i didnt
any thanks appreciated
wrsson
[01/03/2010 00:16:36] Saving server...
[01/03/2010 00:16:36] > MySQL ERROR mysql_real_query: UPDATE `players` SET `level` = 79, `group_id` = 1, `vocation` = 4, `health` = 1355, `healthmax` = 1355, `experience` = 7615400, `lookbody` = 44, `lookfeet` = 44, `lookhead` = 44, `looklegs` = 44, `looktype` = 136, `lookaddons` = 0, `maglevel` = 0, `mana` = 425, `manamax` = 425, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 777, `posy` = 694, `posz` = 4, `cap` = 2370, `sex` = 0, `lastlogin` = 1267387479, `lastip` = 16777343, `conditions` = '', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1267387475, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 24 LIMIT 1; Unknown column 'redskulltime' in 'field list'
[01/03/2010 00:16:36] > MySQL ERROR mysql_real_query: UPDATE `players` SET `level` = 1337, `group_id` = 3, `vocation` = 23, `health` = 37313, `healthmax` = 30585, `experience` = 39654617600, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 266, `lookaddons` = 0, `maglevel` = 12, `mana` = 12660, `manamax` = 12660, `manaspent` = 35803188, `soul` = 114, `town_id` = 1, `posx` = 781, `posy` = 693, `posz` = 4, `cap` = 10000, `sex` = 0, `lastlogin` = 1267393075, `lastip` = 16777343, `conditions` = '', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1267387512, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 2 LIMIT 1; Unknown column 'redskulltime' in 'field list'
Just wondered if there anyway to "unupdate" and revert my database so its all fine with 8.5
I know i should have backed up but i didnt
any thanks appreciated
wrsson