problem fully-loading mangosd.exe - PLEASE help, been trying for a day now

Results 1 to 3 of 3
  1. #1
    Newbie armastat is offline
    MemberRank
    Dec 2006 Join Date
    3Posts

    problem fully-loading mangosd.exe - PLEASE help, been trying for a day now

    First I couldnt get the proper dbc, fixed it. Couldn't get the right maps, fixed it. Now this comes up - not sure what it means or what I need to do. Any tips or solutions would be helpful:

    2007-01-09 18:11:58 Realm running as realm ID 1
    2007-01-09 18:11:58 Using DataDir ./ ...
    2007-01-09 18:11:58 Initialize data stores...
    2007-01-09 18:11:59
    2007-01-09 18:11:59 >> Loaded 28 data stores
    2007-01-09 18:11:59
    2007-01-09 18:11:59 Loading Game Object Templates...
    2007-01-09 18:12:00 ERROR:Error in `gameobject_template` table, probably sql file format was updated (there should be 19 fields in sql).
    Last edited by armastat; 10-01-07 at 02:06 AM.


  2. #2
    Newbie armastat is offline
    MemberRank
    Dec 2006 Join Date
    3Posts

    Found something but i still cant find anything

    Managed to do something to fix the previous problem, but i got another now. Now it says:

    2007-01-09 20:02:47 Returning old mails...
    2007-01-09 20:02:47 Loading item_pages...
    2007-01-09 20:02:47 ERROR:Error opening item_page table.


    Kept looking since no one will answer me , found this:
    ---
    Figured it out.

    After reading the mangos.sql, I found this:

    Code:
    -- Table structure for table `item_page`
    --

    DROP TABLE IF EXISTS `item_page`;
    CREATE TABLE `item_page` (
    `id` int(11) NOT NULL default '0',
    `text` longtext,
    `next_page` bigint(20) unsigned NOT NULL default '0',
    PRIMARY KEY (`id`),
    KEY `item_pages_index` (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
    And please note these 2 lines:

    Code:
    `id` int(11) NOT NULL default '0',
    `next_page` bigint(20) unsigned NOT NULL default '0',
    Go to item_page table, and change the values of "id" and "next_page" to 0 instead of NULL.

    This should do the trick ;)
    ---
    Not a surprise, i tried this and SQLyog wouldnt load the edited manogs.sql file. I changed it from "NOT NULL" to "NOT 0", seems I'm not doing this correctly. can anyone tell me what this fix means, and how I do it?
    Last edited by armastat; 10-01-07 at 01:50 AM.

  3. #3
    Newbie Gotnoname is offline
    MemberRank
    Jan 2007 Join Date
    1Posts
    Could you be so kind and explain how you fixed the "Error in `gameobject_template` table" problem? I cant seem to get around this problem.

    Tried to reinstall mysql, and the DB (mangos db and realmd db).



Advertisement