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

Error MySql

WikiArk21

New Member
Joined
Oct 24, 2023
Messages
11
Reaction score
1
Hello everybody! How can I resolve these errors?

Lua:
[18:52:54.889] mysql_real_query(): SELECT `house_id`, `player_id`, `bid` FROM `house_auctions` WHERE `endtime` < 1698184374 - MYSQL ERROR: Table 'murim.house_auctions' doesn't exist (1146)
[18:52:54.898] > Houses synchronization time: 0.009 seconds.
[18:52:54.902] mysql_real_query(): SELECT * FROM `houses` WHERE `world_id` = 0 - MYSQL ERROR: Unknown column 'world_id' in 'where clause' (1054)
[18:52:54.910] mysql_real_query(): SELECT `house_id`, `data` FROM `house_data` WHERE `world_id` = 0 - MYSQL ERROR: Table 'murim.house_data' doesn't exist (1146)
[18:52:54.919] > Content unserialization time: 0.018 seconds.
[18:52:54.922] >> Checking world type... Open PvP
[18:52:54.925] >> Initializing game state and binding services...
[18:52:54.932] mysql_real_query(): SELECT `key`, `value` FROM `global_storage` WHERE `world_id` = 0; - MYSQL ERROR: Unknown column 'world_id' in 'where clause' (1054)
[18:52:54.942] mysql_real_query(): SELECT `id`, `text` FROM `server_motd` WHERE `world_id` = 0 ORDER BY `id` DESC LIMIT 1 - MYSQL ERROR: Table 'murim.server_motd' doesn't exist (1146)
[18:52:54.951] > ERROR: Failed to load motd!
[18:52:54.955] mysql_real_query(): SELECT `record` FROM `server_record` WHERE `world_id` = 0 ORDER BY `timestamp` DESC LIMIT 1 - MYSQL ERROR: Table 'murim.server_record' doesn't exist (1146)
[18:52:54.964] > ERROR: Failed to load players record!
[18:52:54.968] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=0 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'murim.player_skills' doesn't exist (1146)
[18:52:54.986] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=1 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'murim.player_skills' doesn't exist (1146)
[18:52:55.003] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=2 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'murim.player_skills' doesn't exist (1146)
[18:52:55.021] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=3 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'murim.player_skills' doesn't exist (1146)
[18:52:55.039] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=4 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'murim.player_skills' doesn't exist (1146)
[18:52:55.055] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=5 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'murim.player_skills' doesn't exist (1146)
[18:52:55.074] mysql_real_query(): SELECT `player_skills`.`value`, `players`.`name` FROM `player_skills`,`players` WHERE `player_skills`.`skillid`=6 AND `player_skills`.`player_id`=`players`.`id` ORDER BY `player_skills`.`value` DESC, `player_skills`.`count` DESC LIMIT 15 - MYSQL ERROR: Table 'murim.player_skills' doesn't exist (1146)
[18:52:55.092] mysql_real_query(): SELECT `id`, `ownerid`, `creationdata`, `checkdata` FROM `guilds` WHERE `world_id` = 0; - MYSQL ERROR: Unknown column 'checkdata' in 'field list' (1054)
[18:52:55.102] mysql_real_query(): UPDATE `players` SET `online` = 0 WHERE `world_id` = 0 AND `online` > 0; - MYSQL ERROR: Unknown column 'world_id' in 'where clause' (1054)
[18:52:55.111] mysql_real_query(): SELECT `name`, `password`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 1 LIMIT 1 - MYSQL ERROR: Unknown column 'warnings' in 'field list' (1054)
[18:52:55.121] mysql_real_query(): SELECT `name`, `password`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 2 LIMIT 1 - MYSQL ERROR: Unknown column 'warnings' in 'field list' (1054)
 
Back
Top