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).
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?
