MediaWiki-l March 2006

mediawiki-l@lists.wikimedia.org

159 participants
219 discussions

[MediaWiki-l ] database error when rebuildrecentchanges.php
by Jasmin Hannemann 23 Mar '06

23 Mar '06

Hi, i install a new wiki version on my pc. Then I import the backup dump from the old version. This works fine. Then I rebuild the links for the recentchanges, too. For the first time, there were no problem. When I run this method twice, I get these error message: ** Rebuilding recentchanges table: Loading from page and revision tables... A database error has occurred Query: INSERT rev_timestamp 5000 INTO `recentchanges` (rc_timestamp,rc_cur_time,rc_user,rc_user_text,rc_namespace,rc_title,rc_comment,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type) SELECT rev_timestamp,rev_timestamp,rev_user,rev_user_text,page_namespace,page_title,rev_comment,rev_minor_edit,0,page_is_new,page_id,rev_id,0, IF(page_is_new != 0, 1, 0) FROM `page`,`revision` WHERE (rev_timestamp > 20060316132810) AND (rev_page=page_id) Function: rebuildRecentChangesTablePass1 Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5000 INTO `recentchanges` (rc_timestamp,rc_cur_time,rc_user,rc_user_text,rc_name' at line 1 (localhost) Backtrace: GlobalFunctions.php line 450 calls wfbacktrace() Database.php line 397 calls wfdebugdiebacktrace() Database.php line 347 calls databasemysql::reportqueryerror() Database.php line 1268 calls databasemysql::query() rebuildrecentchanges.inc line 43 calls databasemysql::insertselect() rebuildall.php line 26 calls rebuildrecentchangestablepass1() I do not change anything at the functions, so that I cannot understand, what these error produce. Cheers

2 1

Cutting back on SQL queries, mainly 'objectcache' ...
by Joe 23 Mar '06

23 Mar '06

I just recived a friendly little Email from my host saying they have: "suspended [my account] for excessive system resource usage due to large quantities of MySQL and PHP traffic coming from the domain and creating high server loads" Its a personal site im running, not a "traditional wiki", so i would like to turn off some Dbase queries, if possable. Is it possable for me to turn off the following. LinkCache::addLinkObj MediaWikiBagOStuff:_doquery I would like to omit any SQL to the 'objectcache' table for now. Possable ? and more importantly will it help for my situation? I really like using MediaWiki and do not want to move to somthing else. Thanks for any help... The email my host sent me is below with examples of the activity which brought me to this... ===================================================================== Dear Customer, One of your domains, anotherwebcom.com, has been suspended for excessive system resource usage due to large quantities of MySQL and PHP traffic coming from the domain and creating high server loads. This sort of activity cannot be tolerated in a shared hosting environment. Examples of these queries are listed below. 16 Connect name@localhost on 16 Init DB Dabse_Name 16 Query /* Database::begin */ BEGIN 16 Query SHOW PROCESSLIST 16 Query SHOW STATUS 16 Query /* LinkCache::addLinkObj */ SELECT page_id FROM `page` WHERE page_namespace = '0' AND page_title = 'Main_Page' LIMIT 1 060322 16:43:07 16 Query /* Article::pageData */ SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len FROM `page` WHERE page_id = '1' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:pcache:idhash:1-0!1!0!0!!en!2' 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages' 16 Query UPDATE `page` SET page_counter = page_counter + 1 WHERE page_id = 1 16 Query /* SiteStatsUpdate::doUpdate */ SELECT * FROM `site_stats` LIMIT 1 16 Query /* SiteStatsUpdate::doUpdate */ UPDATE `site_stats` SET ss_total_views=ss_total_views+1 LIMIT 1 16 Query /* Database::immediateCommit */ COMMIT 16 Query /* Database::begin */ BEGIN 16 Query /* LinkCache::addLinkObj */ SELECT page_id FROM `page` WHERE page_namespace = '2' AND page_title = '68.142.250.163' LIMIT 1 16 Query /* User::getNewtalk */ SELECT wl_user FROM `watchlist` WHERE wl_title = '68.142.250.163' AND wl_namespace = '3' AND wl_user = '0' AND (wl_notificationtimestamp != 0) 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (page_id=rev_page) AND rev_page = '1' AND page_id = '1' AND (rev_id=page_latest) LIMIT 1 16 Query /* LinkCache::addLinkObj */ SELECT page_id FROM `page` WHERE page_namespace = '1' AND page_title = 'Main_Page' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Http://forums.anotherwebcom.com/vb/ ' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Http://forums.anotherwebcom.com/vb/_' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Http://forums.anotherwebcom.com/vb/_' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Forums' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Forums' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Forums' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Special:AWCdownloads' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Special:AWCdownloads' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Special:AWCdownloads' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Downloads' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Downloads' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Downloads' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Site_Map' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Site_Map' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Site_Map' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Site Map' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Site_Map' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Site_Map' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Programs' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Programs' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Programs' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Programs' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Programs' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Programs' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Invision Power Board (Scripts)' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Invision_Power_Board_(Scripts)' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Invision_Power_Board_(Scripts)' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:IPB Scripts' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'IPB_Scripts' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'IPB_Scripts' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:MediaWiki (Hacks Scripts Extensions)' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:MediaWiki_(Hacks_Scripts_Extensions)' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:MediaWiki_(Hacks_Scripts_Extensions)' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:MediaWiki Scripts' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'MediaWiki_Scripts' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'MediaWiki_Scripts' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:FireFox_Add-ons_and_Extensions' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:FireFox_Add-ons_and_Extensions' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:FireFox_Add-ons_and_Extensions' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:FireFox Stuff' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'FireFox_Stuff' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'FireFox_Stuff' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Site_Map' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Site_Map' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Site_Map' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Site Map' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Site_Map' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Site_Map' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Help_Using_The_Site' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Help_Using_The_Site' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Help_Using_The_Site' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Special:Recentchanges' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Special:Recentchanges' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Special:Recentchanges' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Recent Changes' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Recent_Changes' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Recent_Changes' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:What AWC Offers' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'What_AWC_Offers' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'What_AWC_Offers' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Useful Site Links' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Useful_Site_Links' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Useful_Site_Links' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:What AWC Offers' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'What_AWC_Offers' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'What_AWC_Offers' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Useful Site Links' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Useful_Site_Links' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Useful_Site_Links' LIMIT 1 16 Query /* Database::immediateCommit */ COMMIT Regards, [Hosts Name (removed by me)]

2 2

phpbb login integration
by Bryce Roney 23 Mar '06

23 Mar '06

hi. is there a way I can integrate a phpBB login db with mediawiki?

2 1

e: Subpages in main namespace?
by Jan Steinman 23 Mar '06

23 Mar '06

> From: Joshua Yeidel <yeidel(a)wsu.edu> > > In non-encyclopedia contexts, you may have information > architectures that > are best expressed using main-space subpages. If so, it isn't hard > to set > up. Is there a guide somewhere? I didn't see it on Meta. :::: MacOS X -- when you need today what Bill Gates has promised you tomorrow. :::: :::: Jan Steinman http://www.VeggieVanGogh.com ::::

2 1

Re: [Mediawiki-l] Subpages in main namespace?
by Jan Steinman 23 Mar '06

23 Mar '06

> From: "Rick DeNatale" <rick.denatale(a)gmail.com> > > On 3/22/06, Joshua Yeidel <yeidel(a)wsu.edu> wrote: >> >> In non-encyclopedia contexts, you may have information >> architectures that >> are best expressed using main-space subpages. If so, it isn't >> hard to set >> up. > > Hierarchies are appealing on the surface because they seem to > correspond to the natural world, unfortunately too often they > correspond to particular points of view of the world and fall apart > when you try to use them to reconcile the views of multiple people*. Exactly, but it is important to note that hierarchies are very good at modeling... hierarchies! People get hung up on the semantics of namespaces/subpages. But in reality, there are situations that already have a hierarchical organization -- what better way to represent them, than with subpages? For example: http://www.EcoReality.org/wiki/Coop_rules is a legal document of incorporation. It consists of numerous sections. Different people need to work on the different sections independently and concurrently. While it might be nice to be able to refer to a particular section by name somewhere else, that section is essentially useless without the enclosing context. > for a site using > mediawiki with a controlled context and/or user set, they might be > useful in more general usage... Exactly! Human knowledge is rife with hierarchies -- not because they are "natural," but because humans invented the model. A company org chart, the Dewey Decimal System, federal/state/county/city government... the examples go on and on. I agree that, in the most general case, hierarchies are poor choices for modeling the real world. But the "unreal world" of human knowledge has created tons of hierarchies; let's not be so quick to call them all evil and impose some inappropriate structure on top of them. When all you have is a hammer, all the world resembles a nail. If you have a dogmatic aversion to hierarchies, you're going to have to go through a lot of unnecessary work when you encounter a screw instead of a nail! :::: Freedom of the commons brings ruin to all. -- Garrett Hardin :::: :::: Jan Steinman (a fossil-fuel free zone!) <http:// www.VeggieVanGogh.com> ::::

3 2

Re: [Mediawiki-l] Subpages in main namespace?
by Rick DeNatale 22 Mar '06

22 Mar '06

On 3/22/06, Rich Morin <rdm(a)cfcl.com> wrote: > At 3:18 PM -0800 3/22/06, Jan Steinman wrote: > > Human knowledge is rife with hierarchies -- not because > > they are "natural," but because humans invented the model. > > I agree somewhat with this, but there are many situations in > which the universe enforces hierarchical organization. For > example, if you start trying to organize physical items, you > soon run into the problem that an item can only be in one > category (ie, container) at a time. However, that container > (eg, a drawer) can be contained in another (eg, a cabinet). Be careful not to confuse containment with categorization. Hierarchies do tend to be suited for containment modeling. They don't do so well with categorization. > I believe that much of humans' use of hierarchies stems from > this interaction between a desire to organize and the limits > of the physical universe. I believe that one of Lakov's observations was that people tend to agree more on carving the world up into leaf level categories; that's a tree and that's a bird; but that differences tend to crop up when making hierarchies of those basic categories, making abstractions. What seems to one person to be a perfectly natural hierarchical structure to the universe, handed down on stone tablets by the diety, may turn out to be completely unintuitive to another particularly one raised in a different culture or with a different native language. Getting to Jan's allusion to Maslov, I don't think that either hierarchies or screws are evil. Although a nail can serve in some of the same roles as a screw and vice versa, it's not always completely obvious when such a usage has crossed the line. It's certainly best to know when to use one vs the other, and when to switch. -- Rick DeNatale Visit the Project Mercury Wiki Site http://www.mercuryspacecraft.com/

1 0

"sessionfailure" message when delete/update files
by Michael Lee 22 Mar '06

22 Mar '06

I configured Mediawiki 1.5.7 to use the REMOTE USER authentication method described here: http://meta.wikimedia.org/wiki/Auto_Login_via_REMOTE_USER If a user logs on under Windows with Internet Explorer and attempts to delete or update a file, it works without problems. This Windows/IE user is logged onto the corporate domain controller, so he is not prompted for username/password upon entering the Wikimedia site. However, if a user logs on using Mozilla Firefox, the same action reports the following error message: "Internal error There seems to be a problem with your login session; this action has been canceled as a precaution against session hijacking. Please hit "back" and reload the page you came from, then try again." Going back and refreshing still has the same problem. I've also noticed that IE users who did not initially log on to the Windows domain (so they're prompted for username/password upon entering the Wikimedia site) experience the same problem. I enabled debug logging, and this is what it reports after pressing "Confirm" to deletion: Start request POST /mediawiki/index.php? title=Image:blah.gif&action=delete Host: blah-machine User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20060130 Red Hat/1.0.7-1.4.3 Firefox/1.0.7 Accept: text/xml,application/xml,application/xhtml +xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5 Accept-Language: en-us,en;q=0.5 Accept-Encoding: gzip,deflate Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Keep-Alive: 300 Connection: keep-alive Referer: https://blah-machine/mediawiki/index.php? title=Image:Snl_tbird_logo_trans.gif&action=delete Cookie: tz_offset=-28800; mediawiki_dbUserName=BlahUser Authorization: Basic Content-Type: application/x-www-form-urlencoded Content-Length: 73 Main cache: fakememcachedclient Message cache: mediawikibagostuff Parser cache: mediawikibagostuff Using reader #0: localhost... Block::load: '192.168.3.2', '34', 1 ** no caching ** WARNING: Abrupt exit in /data/www/html/mediawiki-1.5.7/includes/GlobalFunctions.php at line 437 WARNING: Abrupt exit in /data/www/html/mediawiki-1.5.7/includes/OutputPage.php at line 726 WARNING: Abrupt exit in /data/www/html/mediawiki-1.5.7/includes/ImagePage.php at line 402 WARNING: Abrupt exit in /data/www/html/mediawiki-1.5.7/index.php at line 179 Does anyone have any suggestions? Thanks.

2 1

Subpages in main namespace?
by Birger 22 Mar '06

22 Mar '06

Why is the option to make subpages in the main namespaces not enabled by default? Is there something wrong with making subpages into the main namespace?

6 8

Missing images after code consolidation
by Sam Rowe 22 Mar '06

22 Mar '06

Hi, I run several wikis for different departments at my work.. I recently used the 'lndir' method for making them all run off the same codebase and I forgot about uploaded files. I've put the uploaded files (and dirs) back, but they no longer display inline... only if you drill down to the actual URL fo the image. Permissions are fine. What am I missing? Thanks, Sam

2 6

Making language links like [[fr:Ceci est un test]] work
by Hugh Prior 22 Mar '06

22 Mar '06

I've tried to find out how to start the multi-lingual thing with "en.mysite.com" and "fr.mysite.com" etc. but though there is a lot on translation of messages and stuff I cannot find where it talks about this prefixing of the site domain name. I would like to have my wiki work multi-lingually like www.wikipedia.org in that a user can put on the English page "This is a test" a link to the French version of the page, "Ceci est un test". By inspecting wikipedia I see that the user text would look like [[fr:Ceci est un test]], but when I try this sort of thing on my local wiki all I get displayed is "fr:Ceci est un test" e.g. if I put [[fr:Arts]] on the following page http://localhost/mediawiki-1.5.6/index.php/Arts it just becomes a standard wiki-link in the middle of the page to: http://localhost/mediawiki-1.5.6/index.php?title=Fr:Arts rather than an entry in a side menu to a "French" version of the page. So, my questions: 1) What am I missing in terms of my setup to process this stuff correctly? 2) Where is this documented? 3) What would the URL look like during development? I cannot quite imagine where the "en." would appear in a "localhost" style URL. Thanks! Hugh

2 1

← Newer
1
...
6
7
8
9
10
11
12
...
22
Older →

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

MediaWiki-l March 2006