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

Hyagosrs

Member
Joined
Mar 10, 2018
Messages
92
Solutions
1
Reaction score
9
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,601
Solutions
323
Reaction score
1,391
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