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

[Hyagosrs]

When i'm trying to log in my server, its says in bios:

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

 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

[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.

 

[Addams]

You have prey system in your server? If so just insert this query.

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;

 

[naroxx]

I will try to reinstal all on my vpn server and i let you know maybe i download a old version of db

 

[3zequi3l]

i need this DB complete (canary 12.86) COMPLETE DB please!!!!!!