SQL

Category

There are several options:

• SQL Wiki Category statements for solving the Category Redirect bug.

SearchIndex

The searchindex file can be truncated. To solve this problem do:

• Drop the table searchindex
• create a new searchindex by:

CREATE TABLE /*$wgDBprefix*/searchindex (
-- Key to page_id
si_page int unsigned NOT NULL,
-- Munged version of title
si_title varchar(255) NOT NULL default '',
-- Munged version of body text
si_text mediumtext NOT NULL,
UNIQUE KEY (si_page),
FULLTEXT si_title (si_title),
FULLTEXT si_text (si_text)
) TYPE=MyISAM;