Solved Forgotten server error

walrosZ · May 15, 2011

When i turn on my forgotten server it loads fine for about 6 secs then this happens:

d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 16 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 17 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 18 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 19 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 20 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 21 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 22 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 23 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 24 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 25 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 26 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 27 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 28 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 29 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 30 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 31 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 32 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 33 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 34 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 35 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 36 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 37 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 38 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 39 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 40 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 41 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 42 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 43 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 44 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 45 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 46 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 47 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 48 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 49 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 50 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 51 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 52 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 53 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 54 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 55 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 56 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 57 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 58 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 59 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 60 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 61 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 62 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 63 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 64 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 65 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 66 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 67 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 68 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 69 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 70 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 71 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 72 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 73 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 74 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 75 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 76 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 77 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 78 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 79 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 80 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 81 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 82 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 83 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 84 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 85 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 86 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 87 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 88 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 89 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 90 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 91 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 92 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 93 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 94 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 95 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 96 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 97 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 98 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 99 AND `world_i
d` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (1146
)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 100 AND `world_
id` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (114
6)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 101 AND `world_
id` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (114
6)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 102 AND `world_
id` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (114
6)
mysql_real_query(): DELETE FROM `house_lists` WHERE `house_id` = 103 AND `world_
id` = 0 - MYSQL ERROR: Table 'theforgottendamson.house_lists' doesn't exist (114
6)
mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0 - MYSQL ERROR:
Table 'theforgottendamson.tile_items' doesn't exist (1146)
mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0 - MYSQL ERROR:
Table 'theforgottendamson.tile_items' doesn't exist (1146)
mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0 - MYSQL ERROR:
Table 'theforgottendamson.tile_items' doesn't exist (1146)
> SAVE: Complete in 0.469 seconds using relational house storage.
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'theforgottendamson.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetod
ay+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERRO
R: Unknown column 'onlinetimetoday' in 'field list' (1054)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'theforgottendamson.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'theforgottendamson.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetod
ay+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERRO
R: Unknown column 'onlinetimetoday' in 'field list' (1054)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'theforgottendamson.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'theforgottendamson.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetod
ay+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERRO
R: Unknown column 'onlinetimetoday' in 'field list' (1054)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'theforgottendamson.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'theforgottendamson.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetod
ay+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERRO
R: Unknown column 'onlinetimetoday' in 'field list' (1054)

server seems fine its just that player position is not saved ;P any1 got fix? very thankful for help

this is tutorial i used http://otland.net/f479/how-setup-mysql-otservers-80269/

Cykotitan · May 15, 2011

what file did you import into phpmyadmin?

walrosZ · May 15, 2011

\cryingdamson6pl1-console\schemas\mysql

walrosZ · May 15, 2011

just keeps spamming smoething like this:

mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0 - MYSQL ERROR:
Table 'theforgottendamson.tile_items' doesn't exist (1146)
mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0 - MYSQL ERROR:
Table 'theforgottendamson.tile_items' doesn't exist (1146)
mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0 - MYSQL ERROR:
Table 'theforgottendamson.tile_items' doesn't exist (1146)
> SAVE: Complete in 0.25 seconds using relational house storage.
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'theforgottendamson.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetod
ay+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERRO
R: Unknown column 'onlinetimetoday' in 'field list' (1054)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'theforgottendamson.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'theforgottendamson.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetod
ay+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERRO
R: Unknown column 'onlinetimetoday' in 'field list' (1054)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'theforgottendamson.z_ots_comunication' doesn't exist (1146)
Heikdo has logged out.
mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 2 - MYSQ
L ERROR: Table 'theforgottendamson.player_depotitems' doesn't exist (1146)
mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 2 - MYSQ
L ERROR: Table 'theforgottendamson.player_depotitems' doesn't exist (1146)
mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 2 - MYSQ
L ERROR: Table 'theforgottendamson.player_depotitems' doesn't exist (1146)
Error while saving player: Heikdo.
mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `
type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'theforgottendamson.bans' doesn'
t exist (1146)
mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 2 AND `type` = 3 AND `a
ctive` = 1 AND (`expires` > 1305469529 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR:
Table 'theforgottendamson.bans' doesn't exist (1146)
mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 268449241 AND `param` =
3 AND `type` = 2 AND `active` = 1 AND (`expires` > 1305469529 OR `expires` <= 0
) LIMIT 1 - MYSQL ERROR: Table 'theforgottendamson.bans' doesn't exist (1146)
mysql_real_query(): SELECT `id` FROM `bans` WHERE `type` = 2 AND `value` = 2 AND
`param` = 2 AND `active` = 1 LIMIT 1 - MYSQL ERROR: Table 'theforgottendamson.b
ans' doesn't exist (1146)
mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes` FROM
`player_depotitems` WHERE `player_id` = 2 ORDER BY `sid` DESC - MYSQL ERROR: Tab
le 'theforgottendamson.player_depotitems' doesn't exist (1146)
Heikdo has logged in.
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'theforgottendamson.z_ots_comunication' doesn't exist (1146)
mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetod
ay+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERRO
R: Unknown column 'onlinetimetoday' in 'field list' (1054)
mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - M
YSQL ERROR: Table 'theforgottendamson.z_ots_comunication' doesn't exist (1146)

walrosZ · May 15, 2011

come on! no responses?

Cykotitan · May 15, 2011

check if these tables exist in phpmyadmin, and if you're using the correct database

walrosZ · May 15, 2011

i use this data pack: http://otland.net/f464/8-54-edited-evolutions-many-features-119579/

and which tables?

thanks for help är väldigt tacksam

Cykotitan · May 15, 2011

login into phpmyadmin and check if database "theforgottendamson" has all the required tables (the ones you're getting errors for)

walrosZ · May 15, 2011

* Structure accounts
* Structure account_viplist
* Structure environment_killers
* Structure global_storage
* Structure guilds
* Structure guild_invites
* Structure guild_ranks
* Structure houses
* Structure house_auctions
* Structure house_data
* Structure killers
* Structure players
* Structure player_deaths
* Structure player_items
* Structure player_killers
* Structure player_namelocks
* Structure player_skills
* Structure player_spells
* Structure player_storage
* Structure player_viplist
* Structure server_config
* Structure server_motd
* Structure server_record
* Structure server_reports

thease are the tables i have

Cykotitan · May 15, 2011

looks like you're missing a few. execute this query:

SQL:

CREATE TABLE `player_depotitems`
(
	`player_id` INT NOT NULL,
	`sid` INT NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots',
	`pid` INT NOT NULL DEFAULT 0,
	`itemtype` INT NOT NULL,
	`count` INT NOT NULL DEFAULT 0,
	`attributes` BLOB NOT NULL,
	KEY (`player_id`), UNIQUE (`player_id`, `sid`),
	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `house_lists`
(
	`house_id` INT UNSIGNED NOT NULL,
	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
	`listid` INT NOT NULL,
	`list` TEXT NOT NULL,
	UNIQUE (`house_id`, `world_id`, `listid`),
	FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `tiles`
(
	`id` INT UNSIGNED NOT NULL,
	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
	`house_id` INT UNSIGNED NOT NULL,
	`x` INT(5) UNSIGNED NOT NULL,
	`y` INT(5) UNSIGNED NOT NULL,
	`z` TINYINT(2) UNSIGNED NOT NULL,
	UNIQUE (`id`, `world_id`),
	KEY (`x`, `y`, `z`),
	FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `tile_items`
(
	`tile_id` INT UNSIGNED NOT NULL,
	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
	`sid` INT NOT NULL,
	`pid` INT NOT NULL DEFAULT 0,
	`itemtype` INT NOT NULL,
	`count` INT NOT NULL DEFAULT 0,
	`attributes` BLOB NOT NULL,
	UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),
	FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `bans`
(
	`id` INT UNSIGNED NOT NULL auto_increment,
	`type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
	`value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',
	`param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',
	`active` TINYINT(1) NOT NULL DEFAULT TRUE,
	`expires` INT NOT NULL,
	`added` INT UNSIGNED NOT NULL,
	`admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
	`comment` TEXT NOT NULL,
	`reason` INT UNSIGNED NOT NULL DEFAULT 0,
	`action` INT UNSIGNED NOT NULL DEFAULT 0,
	`statement` VARCHAR(255) NOT NULL DEFAULT '',
	PRIMARY KEY (`id`),
	KEY `type` (`type`, `value`),
	KEY `active` (`active`)
) ENGINE = InnoDB;

now, if you're going to use powergamers and online time stats, check this thread
otherwise remove the event from globalevents.xml

walrosZ · May 15, 2011

how do i create those? sorry for my hassle ^^

Cykotitan · May 15, 2011

click on the SQL button, copypaste the queries inside the box and Go

walrosZ · May 15, 2011

okey ;D one at a time? and there are no powergamers and online time stats listed in my global events

walrosZ · May 15, 2011

which one of thease should i remove?

<globalevent name="shop" interval="30" script="shop.lua"/>
<globalevent name="save" interval="900" event="script" value="save.lua"/>
<globalevent name="clean" interval="7200" event="script" value="clean.lua"/>
<globalevent name="rain" interval="3600" event="script" value="rain.lua"/>
<globalevent name="raid" interval="1800" event="script" value="raids.lua"/>
<globalevent name="effects" interval="1" event="script" value="effects.lua"/>
<globalevent name="information" interval="1800" event="script" value="autobroadcast.lua"/>
<globalevent name="checkvip" interval="86400000" script="removevipdays.lua"/>
<globalevent name="removevip" interval="36000000" script="removevip.lua"/>
<globalevent name="serverstart" type="start" event="script" value="start.lua"/>
<globalevent name="playersrecord" type="record" event="script" value="record.lua"/>
<globalevent name="history" interval="60" event="script" value="history.lua"/>
<globalevent name="serverstart" type="start" event="script" value="dead.lua"/>

Cykotitan · May 15, 2011

history.

if you want to use website shop, install it properly or remove it too

walrosZ · May 15, 2011

no i dont want ^^ so i delete history and shop?

nazi13 · Oct 28, 2013

Thank you Cykotitan, i was having similar issues.

Shadow Dan · Jan 5, 2015

Thank you Cykotitan, thread is old but still helped me.

Solved Forgotten server error

walrosZ

New Member

Cykotitan

Experienced G'

walrosZ

New Member

walrosZ

New Member

walrosZ

New Member

Cykotitan

Experienced G'

walrosZ

New Member

Cykotitan

Experienced G'

walrosZ

New Member

Cykotitan

Experienced G'

walrosZ

New Member

Cykotitan

Experienced G'

walrosZ

New Member

walrosZ

New Member

Cykotitan

Experienced G'

walrosZ

New Member

nazi13

Active Member

Shadow Dan

Sh4dowDan