Problem with Mangos

[Mario123]

Ok first i wanna say that i don't understand mangos and i need some help
ok when i start mangosd.exe and realmd.exe i get many errors in Mangosd.exe
Here they are:

World Database: 127.0.0.1;3306;root;MyPass;MySql
Connected to MySQL database at 127.0.0.1

Login Database: 127.0.0.1;3306;root;MyPass;MysQl
Connected to MySQL database at 127.0.0.1

Realm running as realm ID 1
SQL: UPDATE `character` SET `online` = 0;
SQL ERROR: Table 'mysql.character' doesn't exist
SQL: UPDATE `account`,`realmcharacters` SET `account`.`online` = 0 WHERE `account`.`online` > 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmcharacters`.`realmid` = 1;
Using DataDir D:\pragemanv01alfa\pragemanv01alfa\Mangos/ ...
SQL: UPDATE `realmlist` SET `icon` = 1 WHERE `id` = 1;
SQL: DELETE FROM `game_corpse` WHERE `bones_flag` = '1';
SQL ERROR: Table 'mysql.game_corpse' doesn't exist
Initialize data stores...

>> Loaded 15 data stores

Loading Quests...
SQL: SELECT MAX(`entry`) FROM `quest_template`;

query ERROR: Table 'mysql.quest_template' doesn't exist
>> Loaded 0 quests definitions

Loading NPC Texts...
SQL: SELECT * FROM `npc_text`;

query ERROR: Table 'mysql.npc_text' doesn't exist
Loading Quest Area Triggers...
SQL: SELECT * FROM `areatrigger_involvedrelation`;

query ERROR: Table 'mysql.areatrigger_involvedrelation' doesn't exist
Loading Items...
SQL: SELECT MAX(`entry`) FROM `item_template`;

query ERROR: Table 'mysql.item_template' doesn't exist
>> Loaded 0 item prototypes

SQL: SELECT * FROM `auctionhouse`;

query ERROR: Table 'mysql.auctionhouse' doesn't exist
SQL: SELECT * FROM `auctionhouse_item`;

query ERROR: Table 'mysql.auctionhouse_item' doesn't exist
SQL: SELECT * FROM `mail_item`;

query ERROR: Table 'mysql.mail_item' doesn't exist
Loading Creature templates...
SQL: SELECT MAX(`entry`) FROM `creature_template`;

query ERROR: Table 'mysql.creature_template' doesn't exist
>> Loaded 0 creature definitions

Loading Guilds...
SQL: SELECT `guildid` FROM `guild`;

query ERROR: Table 'mysql.guild' doesn't exist

>> Loaded 0 guild definitions
Loading Teleport Coords...
SQL: SELECT * FROM `areatrigger_template`;

query ERROR: Table 'mysql.areatrigger_template' doesn't exist
SQL: SELECT MAX(`guid`) FROM `character`;

query ERROR: Table 'mysql.character' doesn't exist
SQL: SELECT MAX(`guid`) FROM `creature`;

query ERROR: Table 'mysql.creature' doesn't exist
SQL: SELECT MAX(`guid`) FROM `item_instance`;

query ERROR: Table 'mysql.item_instance' doesn't exist
SQL: SELECT MAX(`guid`) FROM `gameobject`;

query ERROR: Table 'mysql.gameobject' doesn't exist
SQL: SELECT MAX(`id`) FROM `auctionhouse`;

query ERROR: Table 'mysql.auctionhouse' doesn't exist
SQL: SELECT MAX(`id`) FROM `mail`;

query ERROR: Table 'mysql.mail' doesn't exist
SQL: SELECT MAX(`guid`) FROM `game_corpse`;

query ERROR: Table 'mysql.game_corpse' doesn't exist
Loading Loot Tables...
SQL: SELECT `entry`, `item`, `chance`, `questchance` FROM `loot_template`;

query ERROR: Table 'mysql.loot_template' doesn't exist

>> Loaded 0 loot definitions. DB table `loot_template` have incompatible structure or empty.
Loading Game Object Templates...
SQL: SELECT MAX(`entry`) FROM `gameobject_template`;

query ERROR: Table 'mysql.gameobject_template' doesn't exist
>> Loaded 0 game object templates
Initializing Scripts...
WORLD: Starting BattleGround System
Creating battleground Warsong Gulch, 1-60
BattleGroundMgr: Created new battleground: 1 Warsong Gulch (Map 489, 10 players per team, Levels 1-60)
Created initial battlegrounds.
Grid compression apply on creature(s) ...
SQL: TRUNCATE `creature_grid`;
SQL ERROR: Table 'mysql.creature_grid' doesn't exist
SQL: DROP INDEX `idx_search` ON `creature_grid`
SQL ERROR: Table 'mysql.creature_grid' doesn't exist
SQL: INSERT INTO `creature_grid` (`guid`,`map`,`position_x`,`position_y`,`cell_position_x`,`cell_position_y` ) SELECT `guid`,`map`,((`position_x`-266.666665)/533.333330) + 32,((`position_y`-266.666665)/533.333330) + 32,((`position_x`-66.666666)/133.333333) + 128,((`position_y`-66.666666)/133.333333) + 128 FROM `creature`;
SQL ERROR: Table 'mysql.creature_grid' doesn't exist
SQL: UPDATE `creature_grid` SET `grid`=(`position_x`*64) + `position_y`,`cell`=((`cell_position_y` * 256) + `cell_position_x`);
SQL ERROR: Table 'mysql.creature_grid' doesn't exist
SQL: CREATE INDEX `idx_search` ON `creature_grid` (`grid`,`cell`,`map`)
SQL ERROR: Table 'mysql.creature_grid' doesn't exist
Grid compression apply on gameobject(s) ...
SQL: TRUNCATE `gameobject_grid`;
SQL ERROR: Table 'mysql.gameobject_grid' doesn't exist
SQL: DROP INDEX `idx_search` ON `gameobject_grid`
SQL ERROR: Table 'mysql.gameobject_grid' doesn't exist
SQL: INSERT INTO `gameobject_grid` (`guid`,`map`,`position_x`,`position_y`,`cell_position_x`,`cell_position_y` ) SELECT `guid`,`map`,((`position_x`-266.666665)/533.333330) + 32,((`position_y`-266.666665)/533.333330) + 32,((`position_x`-66.666666)/133.333333) + 128,((`position_y`-66.666666)/133.333333) + 128 FROM `gameobject`;
SQL ERROR: Table 'mysql.gameobject_grid' doesn't exist
SQL: UPDATE `gameobject_grid` SET `grid`=(`position_x`*64) + `position_y`,`cell`=((`cell_position_y` * 256) + `cell_position_x`);
SQL ERROR: Table 'mysql.gameobject_grid' doesn't exist
SQL: CREATE INDEX `idx_search` ON `gameobject_grid` (`grid`,`cell`,`map`)
SQL ERROR: Table 'mysql.gameobject_grid' doesn't exist
SQL: SELECT `id` FROM `creature_movement`;

query ERROR: Table 'mysql.creature_movement' doesn't exist
WORLD: SetInitialWorldSettings done
WORLD: Starting Event System
WORLD: Starting Addon System, AddonDefault:1 (Enabled all addons not registared in DB)
SQL: SELECT * FROM `game_addons`;

query ERROR: Table 'mysql.game_addons' doesn't exist
WORLD: Starting Corpse Handler

WORLD: Saving Addons
Size of Addon:0
SQL: UPDATE `account`,`realmcharacters` SET `account`.`online` = 0 WHERE `account`.`online` > 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmcharacters`.`realmid` = 1;
Halting process...
SQL: TRUNCATE table `creature_grid`;
SQL ERROR: Table 'mysql.creature_grid' doesn't exist
SQL: TRUNCATE table `gameobject_grid`;
SQL ERROR: Table 'mysql.gameobject_grid' doesn't exist

 

[Fearlest]

you didnt upload the SQL's right in the DB or you didnt give acces to it? (I had this prob lol)

 

[Mario123]

Ok i fixed this problem but now i have other i can't import Mangos.sql with SQLlog it gives me this error

Query:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

Error occured at:2006-09-30 07:46:09
Line no.:8
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

Now what to do?

 

[stunter]

I have this problem with sql log everytime ive tried. So I determined that sqLlog sucks. Use navicat. It will work.

 

[G1ta0]

mangos svn seems down, can anyone share latest sources?

 

[jmunson]

mangos 2804 platinum problem, getting this error.

Okay, here is the issue that I am having. I tried a fresh install, droped all existing databases and recreated new ones. I installed mangos platinum 2804.exe and updated my databases from that. Everything looks like it is loading ok, but it closes at the end. The serverlog file states:
2007-01-14 14:45:02 >> Loaded 112 loot definitions
2007-01-14 14:45:02 Initializing Scripts...
2007-01-14 14:45:02 WORLD: Starting BattleGround System
2007-01-14 14:45:02 ERROR:SQL: DROP INDEX `idx_search` ON `creature_grid`
2007-01-14 14:45:02 ERROR:SQL ERROR: Can't DROP 'idx_search'; check that column/key exists

I updated databases from "full backup" folder. Thanks for any advise beforehand!

 

[linklink88]

Try a different SQL file?

 

[DJRavine]

good idea.. get the correct SQL database for the mangos version...
btw.. i prefer normal mangos ova platnium..
less support + harder to find the files you need..