[Mediawiki-l] Breadcrumb feature

MHart wiki at matthart.com
Tue Aug 15 15:40:19 UTC 2006


> Using MediaWiki version 1.7.1 I'm trying to enable the breadcrumb
> feature... using the documentation on the MediaWiki site

The problem is that the bread crumb is looking for the CUR table, and it 
isn't used/doesn't exist in later MW versions.

Rather than modify the BC extension, I just create the CUR table for wikis I 
host using a script and some SQL text. Works great.

mysql -uuser -ppass dbname < createcur.sql

Here's the createcur.sql text:

CREATE TABLE `cur` (
  `cur_id` int(8) unsigned NOT NULL auto_increment,
  `cur_namespace` tinyint(2) unsigned NOT NULL default '0',
  `cur_title` varchar(255) character set latin1 collate latin1_bin NOT NULL 
default '',
  `cur_text` mediumtext NOT NULL,
  `cur_comment` tinyblob NOT NULL,
  `cur_user` int(5) unsigned NOT NULL default '0',
  `cur_user_text` varchar(255) character set latin1 collate latin1_bin NOT 
NULL default '',
  `cur_timestamp` varchar(14) character set latin1 collate latin1_bin NOT 
NULL default '',
  `cur_restrictions` tinyblob NOT NULL,
  `cur_counter` bigint(20) unsigned NOT NULL default '0',
  `cur_is_redirect` tinyint(1) unsigned NOT NULL default '0',
  `cur_minor_edit` tinyint(1) unsigned NOT NULL default '0',
  `cur_is_new` tinyint(1) unsigned NOT NULL default '0',
  `cur_random` double unsigned NOT NULL default '0',
  `cur_touched` varchar(14) character set latin1 collate latin1_bin NOT NULL 
default '',
  `inverse_timestamp` varchar(14) character set latin1 collate latin1_bin 
NOT NULL default '',
  UNIQUE KEY `cur_id` (`cur_id`),
  KEY `cur_namespace` (`cur_namespace`),
  KEY `cur_title` (`cur_title`(20)),
  KEY `cur_timestamp` (`cur_timestamp`),
  KEY `cur_random` (`cur_random`),
  KEY `name_title_timestamp` 
(`cur_namespace`,`cur_title`,`inverse_timestamp`),
  KEY `user_timestamp` (`cur_user`,`inverse_timestamp`),
  KEY `usertext_timestamp` (`cur_user_text`,`inverse_timestamp`),
  KEY `namespace_redirect_timestamp` 
(`cur_namespace`,`cur_is_redirect`,`cur_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;


- MHart




More information about the MediaWiki-l mailing list