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

Spawn Problem [OTBR12.51]

naroxx

New Member
Joined
Sep 10, 2013
Messages
22
Reaction score
2
Hallo!

I write a post here because i have some problem with my new OTS.
Im using datapack OtServ Brasil 12,51
Problem is my engine do not wont load spawns :/ i got that mess:
Code:
[Error - mysql_real_query] Query: SELECT `boostname`, `date` FROM `boosted_creature`
> Map loading time: 12.874 seconds
[Error - mysql_real_query] Query: SELECT `boostname` FROM `boosted_creature`
Message: Table 'ots.boosted_creature' doesn't exist
[Error - mysql_store_result] Query: SELECT `boostname` FROM `boosted_creature`
Message: Table 'ots.boosted_creature' doesn't exist
[Warning - Boosted creature] Failed to detect boosted creature database.
[Warning - Map::loadMap] Failed to load spawn data.

secound error in engine is :
Code:
>> Using LuaJIT 2.0.4
[Error - mysql_real_query] Query: SELECT `boostname`, `date` FROM `boosted_creature`
Message: Table 'ots.boosted_creature' doesn't exist
[Error - mysql_store_result] Query: SELECT `boostname`, `date` FROM `boosted_creature`
Message: Table 'ots.boosted_creature' doesn't exist
[Error - mysql_real_query] Query: UPDATE `boosted_creature` SET `boostname` = 'Dark Monk', `date` = '14', `raceid` = '225'
Message: Table 'ots.boosted_creature' doesn't exist

Maybe someone know how to fix this. I want to say the name of map ist that same like -spawn and -house.
NPC works only monsters dont want to load :/
Code:
>> Loading map attributes
> Loaded 955 npcs and spawned 0 monsters
> Loaded 23 towns with 985 houses in total
> Loaded 9 signs in the map
> Loaded 60 books in the map
> Loaded 2 documents in the map
> Loaded all actions in the map
> Loaded all uniques in the map

I will be very happy if someone try to help my with this XD
 
Solution
Insert this in your database
SQL:
CREATE TABLE IF NOT EXISTS `boosted_creature` (
   `boostname` TEXT,  
   `date` varchar(250)  NOT NULL default '',
   `raceid` varchar(250)  NOT NULL default '',
   PRIMARY KEY  (`date`)
   ) AS SELECT 42 AS date, "name" AS boostname, 69 AS raceid
I did a quick search on otservbr and found it in these locations.
data/lib/others/boosted_creature.lua
data\migrations\4.lua
 
Insert this in your database
SQL:
CREATE TABLE IF NOT EXISTS `boosted_creature` (
   `boostname` TEXT,  
   `date` varchar(250)  NOT NULL default '',
   `raceid` varchar(250)  NOT NULL default '',
   PRIMARY KEY  (`date`)
   ) AS SELECT 42 AS date, "name" AS boostname, 69 AS raceid
 
Solution
I try to add this in my DB and i got information

Code:
The defined key is too long. The maximum key length is 767
 
Looks like you need to update your MySQL version, I just inserted it without any issues.
 
Fix MySQL Error:
Lua:
SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for boosted_creature
-- ----------------------------
DROP TABLE IF EXISTS `boosted_creature`;
CREATE TABLE `boosted_creature` (
  `date` varchar(250) NOT NULL DEFAULT '',
  `boostname` text,
  `raceid` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of boosted_creature
-- ----------------------------
INSERT INTO `boosted_creature` VALUES ('13', 'Icecold Book', '1664', '238', '0', '0', '0', '0', '0', '0');

For another error or bug, create issue in github:
 
Back
Top