[Guide] MaNGoS - Getting rid of the item_page table error.
I've noticed that a lot of people are having trouble with an error that shows up saying that there's a problem while loading item_page table.
I've also googled the problem, and looked on the official MaNGoS forum, and this one, but there was no answer, so here's what you have to do:
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 ;)
