[Guide] MaNGoS - Getting rid of the item_page table error.

[lilwiccaseba]

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:

-- 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:

  `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 ;)

[MentaL]

[ezGcps]

Thx, I had that problem.
Changed null to 0 and error fixed.

wkr
ezG.