[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