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

[PHPMYADMIN] Table 'otserv.prey_slots' doesn't exist

Hyagosrs

Member
Joined
Mar 10, 2018
Messages
85
Solutions
1
Reaction score
7
When i'm trying to log in my server, its says in bios:
Lua:
Message: Table 'otserv.player_autoloot' doesn't exist
2020-08-09 19:37:00 -  [Error - mysql_store_result] Query: SELECT `autoloot_list` FROM `player_autoloot` WHERE `player_id` = 6

Code:
 Message: Table 'otserv.prey_slots' doesn't exist
2020-08-09 19:37:00 -  [Error - mysql_store_result] Query: SELECT `num`, `state`, `unlocked`, `current`, `monster_list`, `free_reroll_in`, `time_left`, `next_use`, `bonus_type`, `bonus_value`, `bonus_grade` FROM `prey_slots` WHERE `player_id` = 6

Code:
[Error - mysql_real_query] Query: INSERT INTO `prey_slots` (`player_id`, `num`, `state`, `unlocked`, `current`, `monster_list`, `free_reroll_in`, `time_left`, `next_use`, `bonus_type`, `bonus_value`, `bonus_grade`) VALUES (6,0,3,1,'','',0,0,0,0,0,0),(6,1,3,1,'','',0,0,0,0,0,0),(6,2,3,1,'',

i need help to solve this.
 
Solution
You have prey system in your server? If so just insert this query.
SQL:
CREATE TABLE `prey_slots` (
  `player_id` int(11) NOT NULL,
  `num` smallint(2) NOT NULL,
  `state` smallint(2) NOT NULL DEFAULT '1',
  `unlocked` tinyint(1) NOT NULL DEFAULT '0',
  `current` varchar(40) NOT NULL DEFAULT '',
  `monster_list` varchar(360) NOT NULL,
  `free_reroll_in` int(11) NOT NULL DEFAULT '0',
  `time_left` smallint(5) NOT NULL DEFAULT '0',
  `next_use` int(11) NOT NULL DEFAULT '0',
  `bonus_type` smallint(3) NOT NULL,
  `bonus_value` smallint(3) NOT NULL DEFAULT '0',
  `bonus_grade` smallint(3) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

M0ustafa

1337
Senator
Joined
Mar 4, 2017
Messages
2,554
Solutions
314
Reaction score
1,123
Location
Egypt
You have prey system in your server? If so just insert this query.
SQL:
CREATE TABLE `prey_slots` (
  `player_id` int(11) NOT NULL,
  `num` smallint(2) NOT NULL,
  `state` smallint(2) NOT NULL DEFAULT '1',
  `unlocked` tinyint(1) NOT NULL DEFAULT '0',
  `current` varchar(40) NOT NULL DEFAULT '',
  `monster_list` varchar(360) NOT NULL,
  `free_reroll_in` int(11) NOT NULL DEFAULT '0',
  `time_left` smallint(5) NOT NULL DEFAULT '0',
  `next_use` int(11) NOT NULL DEFAULT '0',
  `bonus_type` smallint(3) NOT NULL,
  `bonus_value` smallint(3) NOT NULL DEFAULT '0',
  `bonus_grade` smallint(3) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
Solution
Top