-
Map Error Plz Help
OK Im not going to reply other thread so im going to put it here this doesnt have nothing to do with the map. It has something to do with some error with the SDB here is my log of the server and hope some1 will tell me whats wrong, b/c i cant even get in game mean i can get to creation char screen but when i hit create nothing happen there is no char so here is my log
2006-12-16 02:33:25 Using configuration file mangosd.conf.
2006-12-16 02:33:25 MaNGOS daemon /0.6-SVN (Win32)
2006-12-16 02:33:25 <Ctrl-C> to stop.
MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM mangosproject.org - Static Site
MMMMMM
2006-12-16 02:33:25 World Database: 127.0.0.1;3306;root;*****;mangos
2006-12-16 02:33:25 Login Database: 127.0.0.1;3306;root;*****;realmd
2006-12-16 02:33:25 Realm running as realm ID 1
2006-12-16 02:33:25 Using DataDir ./ ...
2006-12-16 02:33:25 Initialize data stores...
2006-12-16 02:33:26
2006-12-16 02:33:26 >> Loaded 25 data stores
2006-12-16 02:33:26
2006-12-16 02:33:26 Loading Game Object Templates...
2006-12-16 02:33:26
2006-12-16 02:33:26 >> Loaded 4068 game object templates
2006-12-16 02:33:26 Loading player create info & level stats...
2006-12-16 02:33:26
2006-12-16 02:33:26 >> Loaded 40 player create definitions
2006-12-16 02:33:26
2006-12-16 02:33:26 >> Loaded 294 player create items
2006-12-16 02:33:26
2006-12-16 02:33:26 >> Loaded 841 player create spells
2006-12-16 02:33:27
2006-12-16 02:33:27 >> Loaded 497 player create skills
2006-12-16 02:33:27
2006-12-16 02:33:27 >> Loaded 188 player create actions
2006-12-16 02:33:27
2006-12-16 02:33:27 >> Loaded 2400 level stats definitions
2006-12-16 02:33:27 Loading Quests...
2006-12-16 02:33:28
2006-12-16 02:33:28 >> Loaded 3900 quests definitions
2006-12-16 02:33:28 Loading Scripts...
2006-12-16 02:33:28
2006-12-16 02:33:28 >> Loaded 5 script definitions
2006-12-16 02:33:28 Loading NPC Texts...
2006-12-16 02:33:29
2006-12-16 02:33:29 >> Loaded 2496 npc texts
2006-12-16 02:33:29 Loading Quest Area Triggers...
2006-12-16 02:33:29
2006-12-16 02:33:29 >> Loaded 15 quest trigger points
2006-12-16 02:33:29 Loading Items...
2006-12-16 02:33:40
2006-12-16 02:33:40 >> Loaded 14329 item prototypes
2006-12-16 02:33:40
2006-12-16 02:33:40 Returning old mails...
2006-12-16 02:33:40 Loading item_pages...
2006-12-16 02:33:40
2006-12-16 02:33:40 >> Loaded 1109 item pages
2006-12-16 02:33:40 Loading Creature templates...
2006-12-16 02:33:42
2006-12-16 02:33:42 >> Loaded 8443 creature definitions
2006-12-16 02:33:42 Loading Guilds...
2006-12-16 02:33:42
2006-12-16 02:33:42 >> Loaded 0 guild definitions
2006-12-16 02:33:42 Loading Teleport Coords...
2006-12-16 02:33:42
2006-12-16 02:33:42 >> Loaded 386 teleport definitions
2006-12-16 02:33:42 Loading Loot Tables...
2006-12-16 02:33:42 creature_loot_template :
2006-12-16 02:33:42 ERROR:SQL: SELECT `entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `maxcount`, `quest_freeforall` FROM `creature_loot_template`
2006-12-16 02:33:42 ERROR:query ERROR: Unknown column 'ChanceOrRef' in 'field list'
2006-12-16 02:33:42
2006-12-16 02:33:42 ERROR:>> Loaded 0 loot definitions. DB table `creature_loot_template` is empty.
2006-12-16 02:33:42 fishing_loot_template :
2006-12-16 02:33:42 ERROR:SQL: SELECT `entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `maxcount`, `quest_freeforall` FROM `fishing_loot_template`
2006-12-16 02:33:42 ERROR:query ERROR: Unknown column 'ChanceOrRef' in 'field list'
2006-12-16 02:33:42
2006-12-16 02:33:42 ERROR:>> Loaded 0 loot definitions. DB table `fishing_loot_template` is empty.
2006-12-16 02:33:42 gameobject_loot_template :
2006-12-16 02:33:42 ERROR:SQL: SELECT `entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `maxcount`, `quest_freeforall` FROM `gameobject_loot_template`
2006-12-16 02:33:42 ERROR:query ERROR: Unknown column 'ChanceOrRef' in 'field list'
2006-12-16 02:33:42
2006-12-16 02:33:42 ERROR:>> Loaded 0 loot definitions. DB table `gameobject_loot_template` is empty.
2006-12-16 02:33:42 item_loot_template :
2006-12-16 02:33:42 ERROR:SQL: SELECT `entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `maxcount`, `quest_freeforall` FROM `item_loot_template`
2006-12-16 02:33:42 ERROR:query ERROR: Unknown column 'ChanceOrRef' in 'field list'
2006-12-16 02:33:42
2006-12-16 02:33:42 ERROR:>> Loaded 0 loot definitions. DB table `item_loot_template` is empty.
2006-12-16 02:33:42 pickpocketing_loot_template :
2006-12-16 02:33:42 ERROR:SQL: SELECT `entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `maxcount`, `quest_freeforall` FROM `pickpocketing_loot_template`
2006-12-16 02:33:42 ERROR:query ERROR: Unknown column 'ChanceOrRef' in 'field list'
2006-12-16 02:33:42
2006-12-16 02:33:42 ERROR:>> Loaded 0 loot definitions. DB table `pickpocketing_loot_template` is empty.
2006-12-16 02:33:42 skinning_loot_template :
2006-12-16 02:33:42 ERROR:SQL: SELECT `entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `maxcount`, `quest_freeforall` FROM `skinning_loot_template`
2006-12-16 02:33:42 ERROR:query ERROR: Unknown column 'ChanceOrRef' in 'field list'
2006-12-16 02:33:42
2006-12-16 02:33:42 ERROR:>> Loaded 0 loot definitions. DB table `skinning_loot_template` is empty.
2006-12-16 02:33:42 Initializing Scripts...
2006-12-16 02:33:42 WORLD: Starting BattleGround System
2006-12-16 02:33:45 WORLD: SetInitialWorldSettings done
2006-12-16 02:33:45 Loading Transports...
2006-12-16 02:33:45 ERROR:SQL: SELECT `entry`, `name`, `period` FROM transports
2006-12-16 02:33:45 ERROR:query ERROR: Table 'mangos.transports' doesn't exist
2006-12-16 02:33:45
2006-12-16 02:33:45 >> Loaded 0 transports
2006-12-16 02:33:45 WORLD: Starting Event System
2006-12-16 02:33:45 WORLD: Starting Corpse Handler
2006-12-16 02:33:45
2006-12-16 02:33:45 mangosd process priority class set to HIGH
2006-12-16 02:33:45
2006-12-16 02:34:22 Account: 'MR.LEE' Login.
2006-12-16 02:34:25 Account: 'MR.LEE' Login.
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character` (`guid`,`realm`,`account`,`name`,`race`,`class`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`data`,`taximask`,`online`,`highest_rank`,`standing`,`rating`,`cinematic`,`totaltime`,`leveltime`,`rest_bonus`,`logout_time`,`is_logout_resting`,`resettalents_cost`,`resettalents_time`,`trans_x`, `trans_y`, `trans_z`, `trans_o`, `transguid`) VALUES (2, 1, 7, 'Haris', 4, 1, 1, 10311.3, 832.463, 1326.41, 0, '2 0 25 0 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50 0 0 0 0 0 1112014848 0 1148846080 0 0 0 1 4 16777476 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1157234688 1157234688 1157234688 1053240066 1069547520 55 55 0 1079823564 1079823564 1079134500 1079134500 285273600 0 0 0 0 16 0 0 0 0 0 0 1101004800 1103626240 1101529088 1101004800 1101004800 1112014848 0 0 0 0 0 0 0 0 4008635904 23 0 0 31 0 0 1083029211 1083029211 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 67174407 33615363 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6120 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6121 0 0 0 0 0 0 0 0 0 0 0 6122 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 0 0 0 0 0 0 0 0 2362 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 37 1073741936 0 0 0 0 38 1073741936 39 1073741936 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40 1073741936 41 1073741936 0 0 0 0 0 0 0 0 0 0 0 0 42 1073741936 43 1073741936 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 400 98 19661100 0 113 19661100 0 162 327681 0 126 65537 0 415 65537 0 414 65537 0 413 65537 0 433 65537 0 95 327681 0 26 65537 0 256 65537 0 257 65537 0 54 327681 0 43 327681 0 173 327681 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1083892040 1074790400 1084227584 1084227584 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1065353216 0 0 0 0 0 0 4007657472 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4294967295 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ', '100663296 0 0 0 0 0 0 0 ', 0, 0, 0, 0, 0, 0, 0, 0, 1166254514, 0, 0, 0, 0, 0, 0, 0, 0 )
2006-12-16 02:35:14 ERROR:SQL ERROR: Unknown column 'trans_x' in 'field list'
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '671', '2','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-671' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '20583', '8','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-20583' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '78', '17','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-78' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '198', '18','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-198' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '6478', '23','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-6478' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '9078', '11','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-9078' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '20582', '7','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-20582' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '81', '4','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-81' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '201', '19','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-201' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '2457', '16','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-2457' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '3365', '10','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-3365' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '8737', '13','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-8737' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '9077', '12','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-9077' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '9125', '22','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-9125' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '20585', '9','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-20585' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '668', '1','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-668' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '1180', '20','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-1180' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '9116', '14','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-9116' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '20580', '6','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-20580' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '107', '15','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-107' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '203', '3','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-203' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '6603', '5','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-6603' for key 1
2006-12-16 02:35:14 ERROR:SQL: INSERT INTO `character_spell` (`guid`,`spell`,`slot`,`active`) VALUES ('2', '7266', '21','1')
2006-12-16 02:35:14 ERROR:SQL ERROR: Duplicate entry '2-7266' for key 1
2006-12-16 02:35:14 ERROR:SQL: DELETE FROM `character_spell_cooldown` WHERE `guid` = '2'
2006-12-16 02:35:14 ERROR:SQL ERROR: Table 'mangos.character_spell_cooldown' doesn't exist
2006-12-16 02:36:02 Halting process...