• 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!

Linux problem with ots mysql

Skibka

New Member
Joined
Jul 3, 2016
Messages
50
Solutions
1
Reaction score
1
link http://wklej.to/fwiF0

and logs

[7:11:43.767] mysql_real_query(): SELECT `price` FROM `houses` WHERE `id` = 1 AN D `world_id` = 0 LIMIT 1 - MYSQL ERROR: Unknown column 'price' in 'field list' ( 1054)
[7:11:43.767] mysql_real_query(): INSERT INTO `houses` (`id`, `world_id`, `owner `, `name`, `town`, `size`, `price`, `rent`, `doors`, `beds`, `tiles`, `guild`) V ALUES (1, 0, 0, 'Rhyves Flats 14', 2, 14, 17000, 0, 0, 2, 17, 0) - MYSQL ERROR: Unknown column 'world_id' in 'field list' (1054)
[7:11:43.767] mysql_real_query(): SELECT `house_id`, `player_id`, `bid` FROM `ho use_auctions` WHERE `endtime` < 1468494703 - MYSQL ERROR: Table 'ots.house_aucti ons' doesn't exist (1146)
[7:11:43.767] > Houses synchronization time: 0.001 seconds.
[7:11:43.767] mysql_real_query(): SELECT * FROM `houses` WHERE `world_id` = 0 - MYSQL ERROR: Unknown column 'world_id' in 'where clause' (1054)
[7:11:43.767] mysql_real_query(): SELECT `house_id`, `data` FROM `house_data` WH ERE `world_id` = 0 - MYSQL ERROR: Table 'ots.house_data' doesn't exist (1146)
[7:11:43.767] > Content unserialization time: 0 seconds.
[7:11:43.767] >> Checking world type... Open PvP
[7:11:43.767] >> Initializing game state and binding services...
[7:11:43.771] mysql_real_query(): SELECT `key`, `value` FROM `global_storage` WH ERE `world_id` = 0; - MYSQL ERROR: Table 'ots.global_storage' doesn't exist (114 6)
[7:11:43.771] mysql_real_query(): SELECT `id`, `text` FROM `server_motd` WHERE ` world_id` = 0 ORDER BY `id` DESC LIMIT 1 - MYSQL ERROR: Table 'ots.server_motd' doesn't exist (1146)
[7:11:43.771] > ERROR: Failed to load motd!
[7:11:43.771] mysql_real_query(): SELECT `record` FROM `server_record` WHERE `wo rld_id` = 0 ORDER BY `timestamp` DESC LIMIT 1 - MYSQL ERROR: Table 'ots.server_r ecord' doesn't exist (1146)
[7:11:43.771] > ERROR: Failed to load players record!
[7:11:43.772] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`nam e` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=0 AND `player_ skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `playe r_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'ots.player_skills' doesn't exist (1146)
[7:11:43.772] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`nam e` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=1 AND `player_ skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `playe r_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'ots.player_skills' doesn't exist (1146)
[7:11:43.772] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`nam e` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=2 AND `player_ skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `playe r_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'ots.player_skills' doesn't exist (1146)
[7:11:43.772] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`nam e` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=3 AND `player_ skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `playe r_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'ots.player_skills' doesn't exist (1146)
[7:11:43.772] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`nam e` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=4 AND `player_ skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `playe r_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'ots.player_skills' doesn't exist (1146)
[7:11:43.772] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`nam e` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=5 AND `player_ skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `playe r_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'ots.player_skills' doesn't exist (1146)
[7:11:43.782] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`nam e` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=6 AND `player_ skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `playe r_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'ots.player_skills' doesn't exist (1146)
[7:11:43.782] mysql_real_query(): SELECT `id`, `ownerid`, `creationdata`, `check data` FROM `guilds` WHERE `world_id` = 0; - MYSQL ERROR: Unknown column 'world_i d' in 'where clause' (1054)
[7:11:43.782] mysql_real_query(): UPDATE `players` SET `online` = 0 WHERE `world _id` = 0 AND `online` > 0; - MYSQL ERROR: Unknown column 'world_id' in 'where cl ause' (1054)
[7:11:43.782] mysql_real_query(): UPDATE `bans` SET `active` = 0 WHERE `expires` <= 1468494703 AND `expires` >= 0 AND `active` = 1 LIMIT 1; - MYSQL ERROR: Table 'ots.bans' doesn't exist (1146)
[7:11:43.784] mysql_real_query(): SELECT `name`, `password`, `premdays`, `lastda
 
Back
Top