hello guys, I'm having problems with my server after I passed him to use tfs 0.4, the error is as follows, I use MySQL, and every time she goes in time to start the server to stay online, the following error when a player will get.
and start.lua my GlobalEvents, its well.
and the error that occurs in start.lua is this.
how can I fix this error?
Code:
[19/7/2014 14:27:41] mysql_real_query(): SELECT `pk`.`player_id`, `pd`.`date` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` WHERE `pd`.`player_id` = 2 AND `k`.`unjustified` = 1 AND `pd`.`date` >= 1405186061 AND `k`.`war` = 0 - MYSQL ERROR: Unknown column 'k.war' in 'where clause' (1054)
and start.lua my GlobalEvents, its well.
Code:
function onStartup()
db.executeQuery("UPDATE `players` SET `online` = 0 WHERE `world_id` = " .. getConfigValue('worldId') .. ";")
return true
end
and the error that occurs in start.lua is this.
Code:
[19/7/2014 14:24:46] [Error - GlobalEvent Interface]
[19/7/2014 14:24:46] data/globalevents/scripts/start.lua:onStartup
[19/7/2014 14:24:46] Description:
[19/7/2014 14:24:46] data/globalevents/scripts/start.lua:2: attempt to call field 'executeQuery' (a nil value)
[19/7/2014 14:24:46] stack traceback:
[19/7/2014 14:24:46] data/globalevents/scripts/start.lua:2: in function <data/globalevents/scripts/start.lua:1>
[19/7/2014 14:24:46] mysql_real_query(): SELECT `id`, `guild_id`, `enemy_id` FROM `guild_wars` WHERE `status` IN (1,4) AND `end` > 0 AND `end` < 1405790686 - MYSQL ERROR: Table 'real ot.guild_wars' doesn't exist (1146)
how can I fix this error?