• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

problem server after passed tfs 0.4

Tegardee

The Boss
Joined
Jun 18, 2014
Messages
106
Reaction score
0
Location
Brazil
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.

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?
 
so man the error start.lua was fixed, but still have an error when login and when the server is getting online.

Code:
[19/7/2014 15:16:12] mysql_real_query(): SELECT `id`, `guild_id`, `enemy_id` FROM `guild_wars` WHERE (`guild_id` = 4 OR `enemy_id` = 4) AND `status` IN (1,4) - MYSQL ERROR: Table 'real ot.guild_wars' doesn't exist (1146)
[19/7/2014 15:16:12] 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` >= 1405188972 AND `k`.`war` = 0 - MYSQL ERROR: Unknown column 'k.war' in 'where clause' (1054)
[19/7/2014 15:16:12] Chapola has logged in.

edit: forget guys, I managed to fix the mistakes already, thank you very much and sorry for the inconvenience
 
Last edited:
Back
Top