SQL
Revision as of 10:17, 7 December 2012 by Hjmf (talk | contribs) (Created page with "== Category == There are several options: * SQL Wiki Category statements for solving the Category Redirect bug. == SearchIndex == The sea...")
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;