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
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)]
> 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 ::::
> 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> ::::
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/
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.
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?
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
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