[Mediawiki-l] Breadcrumb feature
Gordon Adel
Adel.Gordon at northampton.Ac.Uk
Thu Sep 7 10:41:10 UTC 2006
Thanks for the advice, I've created the table, but how do you then tell
the wiki to display the breadcrumbs?
Kind Regards,
Adel
> 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
Adel Gordon
IT Services
University of Northampton
Boughton Green Road
Northampton
NN2 7AL
Tel: 01604 892821
email: adel.gordon at northampton.ac.uk
web: http://www.northampton.ac.uk
This e-mail is private and may be confidential and is for the intended recipient only. If you are not the intended recipient you are strictly prohibited from using, printing, copying, distributing or disseminating this e-mail or any information contained in it.
We virus scan all E-mails leaving The University of Northampton but no warranty is given that this E-mail and any attachments are virus free. You should undertake your own virus checking. The right to monitor E-mail communications through our networks is reserved by us.
More information about the MediaWiki-l
mailing list