Problem with psdatabase.cpp

[Psybur]

When I try to log on:
guest/guest is using version 17 and is not a new user.
Check Login for: \'Guest\'
Guild info: Player is Peon (4) in guild Whicever (10).
User \'Guest\' (2) added to active client list
Requested World!
CreateActor: Could not CreateActor because sector specified was NULL.
Error while creating Entity for Player \'Guest\'
Remove player \'Guest\' (2)
***Warning: Error while creating player in world!
In file src/server/pscelserver.cpp function void psCelServer::HandlePersistMessage(MsgEntry*) line 895

GRR. I also get stuff when I type spawn:

CreateActor: Could not CreateActor because sect
or specified was NULL.
Error while creating Entity for NPC 32
CreateActor: Could not CreateActor because sect
or specified was NULL.
Error while creating Entity for NPC 33
CreateActor: Could not CreateActor because sect
or specified was NULL.
Error while creating Entity for NPC 38
CEL is searching for meshfact \'/this/art/things/chest\'...Not Found, so loading /
this/art/things/chest.spr
CreateItem: Could not create Item because could
 not find the specified sector for Object #5
CEL is searching for meshfact \'/this/art/things/chest\'...Not Found, so loading /
this/art/things/chest.spr
CreateItem: Could not create Item because could
 not find the specified sector for Object #7
CEL is searching for meshfact \'/this/art/things/weapons/cleaver\'...Not Found, so
 loading /this/art/things/weapons/cleaver.spr
CreateItem: Could not create Item because could
 not find the specified sector for Object #8
CEL is searching for meshfact \'/this/art/things/weapons/long02c\'...Not Found, so
 loading /this/art/things/weapons/long02c.spr
CreateItem: Could not create Item because could
 not find the specified sector for Object #9

[Karosh_Steinkatz]

You have to edit the database and load the correct maps into the server. For further details look here.

[Psybur]

mysql> source dbpatch.sql
ERROR 1062: Duplicate entry \'0\' for key 1
ERROR 1062: Duplicate entry \'1\' for key 1
ERROR 1062: Duplicate entry \'2\' for key 1
ERROR 1062: Duplicate entry \'3\' for key 1
ERROR 1062: Duplicate entry \'4\' for key 1
ERROR 1062: Duplicate entry \'5\' for key 1
ERROR 1062: Duplicate entry \'6\' for key 1
ERROR 1062: Duplicate entry \'7\' for key 1
ERROR 1062: Duplicate entry \'8\' for key 1
ERROR 1062: Duplicate entry \'9\' for key 1
ERROR 1062: Duplicate entry \'10\' for key 1
ERROR 1062: Duplicate entry \'11\' for key 1
ERROR 1062: Duplicate entry \'12\' for key 1
ERROR 1062: Duplicate entry \'13\' for key 1
ERROR 1062: Duplicate entry \'14\' for key 1
ERROR 1062: Duplicate entry \'15\' for key 1
ERROR 1062: Duplicate entry \'16\' for key 1
ERROR 1062: Duplicate entry \'17\' for key 1
ERROR 1062: Duplicate entry \'18\' for key 1
ERROR 1062: Duplicate entry \'19\' for key 1
ERROR 1062: Duplicate entry \'20\' for key 1
ERROR 1062: Duplicate entry \'21\' for key 1
ERROR 1062: Duplicate entry \'22\' for key 1
ERROR 1062: Duplicate entry \'23\' for key 1

[dfryer]

Ah, I was just surprised that there was so many problems getting the server to work, that\'s all-  if that\'s normal then ignore me

[Karosh_Steinkatz]

Yeah, it is not easy

Hmm, ok, then try this one Psybur:

DROP TABLE IF EXISTS `races`;
CREATE TABLE `races` (
  `race_id` int(10) NOT NULL default \'0\',
  `name` varchar(35) NOT NULL default \'\',
  `mesh` varchar(35) NOT NULL default \'0\',
  `min_armor_size` tinyint(1) unsigned default \'0\',
  `max_armor_size` tinyint(1) unsigned default \'0\',
  `base_texture` varchar(30) default \'0\',
  `sex` char(1) NOT NULL default \'M\',
  `start_x` float(10,2) default \'0.00\',
  `start_y` float(10,2) default \'0.00\',
  `start_z` float(10,2) default \'0.00\',
  `start_sector` varchar(50) default NULL,
  PRIMARY KEY  (`race_id`)
) TYPE=MyISAM;


INSERT INTO `races` VALUES (0, \'Stonebreaker\', \'maledwarf\', 0, 0, \'1.png\', \'M\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (1, \'Enkidukai\', \'maleenk\', 0, 1, \'1.png\', \'M\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (2, \'Ynnwn\', \'maleynnwn\', 0, 1, \'1.png\', \'M\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (3, \'Ylian\', \'maleylian\', 0, 1, \'1.png\', \'M\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (4, \'Xacha\', \'malexacha\', 0, 1, \'1.png\', \'M\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (5, \'Nolthrir\', \'malenolthrir\', 0, 1, \'1.png\', \'M\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (6, \'Dermorian\', \'maledermorian\', 0, 1, \'1.png\', \'M\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (7, \'Hammerwielder\', \'maledwarfh\', 0, 0, \'1.png\', \'M\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (8, \'Diaboli\', \'malediaboli\', 0, 1, \'1.png\', \'M\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (9, \'Kran\', \'kran\', 0, 1, \'1.png\', \'N\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (10, \'Lemur\', \'malelemur\', 0, 1, \'1.png\', \'M\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (11, \'Klyros\', \'maleklyros\', 0, 1, \'1.png\', \'M\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (12, \'Enkidukai\', \'femenk\', 0, 1, \'1.png\', \'F\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (13, \'Stonebreaker\', \'femdwarf\', 0, 0, \'1.png\', \'F\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (14, \'Ynnwn\', \'femynnwn\', 0, 1, \'1.png\', \'F\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (15, \'Ylian\', \'femylian\', 0, 1, \'1.png\', \'F\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (16, \'Xacha\', \'femxacha\', 0, 1, \'1.png\', \'F\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (17, \'Nolthrir\', \'femnolthrir\', 0, 1, \'1.png\', \'F\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (18, \'Dermorian\', \'femdermorian\', 0, 1, \'1.png\', \'F\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (19, \'Hammerwielder\', \'femdwarfh\', 0, 0, \'1.png\', \'F\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (20, \'Diaboli\', \'femdiaboli\', 0, 1, \'1.png\', \'F\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (21, \'Lemur\', \'femlemur\', 0, 1, \'1.png\', \'F\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (22, \'Klyros\', \'femklyros\', 0, 1, \'1.png\', \'F\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');
INSERT INTO `races` VALUES (23, \'Rogue\', \'malerogue01\', 0, 1, \'malerogue_skin_01.png\', \'M\', \'19.18\', \'-4.05\', \'-115.22\', \'hydlaa_plaza\');


DROP TABLE IF EXISTS `sector_info`;
CREATE TABLE `sector_info` (
  `name` varchar(30) NOT NULL default \'\',
  `rain_min_gap` int(10) unsigned NOT NULL default \'0\',
  `rain_max_gap` int(10) unsigned NOT NULL default \'0\',
  `rain_min_duration` int(10) unsigned NOT NULL default \'0\',
  `rain_max_duration` int(10) unsigned NOT NULL default \'0\',
  `rain_min_drops` int(10) unsigned NOT NULL default \'0\',
  `rain_max_drops` int(10) unsigned NOT NULL default \'0\',
  `lightning_min_gap` int(10) unsigned NOT NULL default \'0\',
  `lightning_max_gap` int(10) unsigned NOT NULL default \'0\',
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;


INSERT INTO `sector_info` VALUES (\'room\', 25, 50, 25, 50, 500, 3000, 5, 10);
INSERT INTO `sector_info` VALUES (\'temple\', 100, 200, 100, 200, 100, 500, 10, 20);
INSERT INTO `sector_info` VALUES (\'podium\', 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `sector_info` VALUES (\'tavern\', 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `sector_info` VALUES (\'library\', 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `sector_info` VALUES (\'large\', 25, 50, 25, 50, 500, 3000, 5, 10);

Same procedure as before, but this will definately work

[Psybur]

Karosh... this isnt working...
The source dbpatch.sql; works, but I still get the error when I try to spawn >:O

[Karosh_Steinkatz]

Hmmmm, it should work if you have loaded all maps (hydlaa, dungeon, temple, tower) into the server. I will look further into this when I come home.