Meu TFS está dando os seguintes alertas os primeiros são durante a execução o segundo é quando tento logar.

Quando tento logar:

[Error - mysql_real_query] Query: SELECT `reason`, `expires_at`, (SELECT `name` FROM `players` WHERE `id` = `banned_by`) AS `name` FROM `ip_bans` WHERE `ip` = 16777343
Message: Table 'franalin.ip_bans' doesn't exist
[Error - mysql_store_result] Query: SELECT `reason`, `expires_at`, (SELECT `name` FROM `players` WHERE `id` = `banned_by`) AS `name` FROM `ip_bans` WHERE `ip` = 16777343
Message: Table 'franalin.ip_bans' doesn't exist
[Error - mysql_real_query] Query: SELECT `reason`, `expires_at`, (SELECT `name`
FROM `players` WHERE `id` = `banned_by`) AS `name` FROM `ip_bans` WHERE `ip` = 1
6777343
Message: Table 'franalin.ip_bans' doesn't exist
[Error - mysql_store_result] Query: SELECT `reason`, `expires_at`, (SELECT `name
` FROM `players` WHERE `id` = `banned_by`) AS `name` FROM `ip_bans` WHERE `ip` =
 16777343
Message: Table 'franalin.ip_bans' doesn't exist
[Error - mysql_real_query] Query: SELECT `id`, `name`, `password`, `type`, `premdays`, `lastday` FROM `accounts` WHERE `name` = '1334029'
Message: Unknown column 'type' in 'field list'
[Error - mysql_store_result] Query: SELECT `id`, `name`, `password`, `type`, `premdays`, `lastday` FROM `accounts` WHERE `name` = '1334029'
Message: Unknown column 'type' in 'field list'

Quando executo a TFS:

[Error - mysql_real_query] Query: SELECT `data` FROM `tile_store`
Message: Table 'franalin.tile_store' doesn't exist
[Error - mysql_store_result] Query: SELECT `data` FROM `tile_store`
Message: Table 'franalin.tile_store' doesn't exist
>> Initializing gamestate
[Error - mysql_real_query] Query: TRUNCATE TABLE `players_online`
Message: Table 'franalin.players_online' doesn't exist
[Error - mysql_real_query] Query: DELETE FROM `players` WHERE `deletion` != 0 AND `deletion` < 1401406844
Message: Unknown column 'deletion' in 'where clause'
[Error - mysql_real_query] Query: DELETE FROM `ip_bans` WHERE `expires_at` != 0 AND `expires_at` <= 1401406844
Message: Table 'franalin.ip_bans' doesn't exist
[Error - mysql_real_query] Query: DELETE FROM `market_history` WHERE `inserted`<= 1398814844
Message: Table 'franalin.market_history' doesn't exist
[Error - mysql_real_query] Query: SELECT * FROM `account_bans` WHERE `expires_at` != 0 AND `expires_at` <= 1401406844
Message: Table 'franalin.account_bans' doesn't exist
[Error - mysql_store_result] Query: SELECT * FROM `account_bans` WHERE `expires_at` != 0 AND `expires_at` <= 1401406844
Message: Table 'franalin.account_bans' doesn't exist
[Error - mysql_real_query] Query: SELECT `id`, `highest_bidder`, `last_bid`, (SELECT `balance` FROM `players` WHERE `players`.`id` = `highest_bidder`) AS `balance` FROM `houses` WHERE `owner` = 0 AND `bid_end` != 0 AND `bid_end` < 1401406844
Message: Unknown column 'highest_bidder' in 'field list'
[Error - mysql_store_result] Query: SELECT `id`, `highest_bidder`, `last_bid`, (SELECT `balance` FROM `players` WHERE `players`.`id` = `highest_bidder`) AS `balance` FROM `houses` WHERE `owner` = 0 AND `bid_end` != 0 AND `bid_end` < 1401406844
Message: Unknown column 'highest_bidder' in 'field list'
[Error - mysql_real_query] Query: SELECT `id`, `amount`, `price`, `itemtype`, `player_id` FROM `market_offers` WHERE `sale` = 0 AND `created` <= 1398814844
Message: Table 'franalin.market_offers' doesn't exist
[Error - mysql_store_result] Query: SELECT `id`, `amount`, `price`, `itemtype`, `player_id` FROM `market_offers` WHERE `sale` = 0 AND `created` <= 1398814844
Message: Table 'franalin.market_offers' doesn't exist
[Error - mysql_real_query] Query: SELECT `id`, `amount`, `price`, `itemtype`, `player_id` FROM `market_offers` WHERE `sale` = 1 AND `created` <= 1398814844
Message: Table 'franalin.market_offers' doesn't exist
[Error - mysql_store_result] Query: SELECT `id`, `amount`, `price`, `itemtype`, `player_id` FROM `market_offers` WHERE `sale` = 1 AND `created` <= 1398814844
Message: Table 'franalin.market_offers' doesn't exist
[Error - mysql_real_query] Query: SELECT `sale` AS `sale`, `itemtype` AS `itemtype`, COUNT(`price`) AS `num`, MIN(`price`) AS `min`, MAX(`price`) AS `max`, SUM(`price`) AS `sum` FROM `market_history` WHERE `state` = 3 GROUP BY `itemtype`, `sale`
Message: Table 'franalin.market_history' doesn't exist
[Error - mysql_store_result] Query: SELECT `sale` AS `sale`, `itemtype` AS `item type`, COUNT(`price`) AS `num`, MIN(`price`) AS `min`, MAX(`price`) AS `max`, SUM(`price`) AS `sum` FROM `market_history` WHERE `state` = 3 GROUP BY `itemtype`, `sale`
Message: Table 'franalin.market_history' doesn't exist

Me manda sua data base que eu tento resolver tds esse problemas aqui. Vai ser mais rápido do que digitar tudo o que vc tem que fazer.

Cara a DB é Mysql então eu queria que tu postasse as querys pra mim por que toda vez que eu for movimentar o meu otserv e trocar DB vou ter que te mandar pra arrumar pra mim ? fica ruim daí D:

Tem todas (ou por hora a maioria) no meu tópico: http://www.tibiaking.com/forum/topic/33611-tutorial-resolvendo-qualquer-erro-na-data-base/#entry189040