Author: lianluoyuan
Description:
I'm using
- MediaWiki: 1.5beta4
- PHP: 4.3.10 (apache2handler)
- MySQL: 3.23.58
when run Special:Random, it shows:
SELECT page_id,page_title FROM `page` FORCE INDEX (page_random) WHERE
page_namespace=0 AND page_is_redirect=0 AND page_random>0.083694135933 ORDER BY
page_random LIMIT 1
from function "wfSpecialRandompage"。 MySQL returns error "1064: You have an
error in your SQL syntax near 'INDEX (page_random) WHERE page_namespace=0 AND
page_is_redirect=0 AND page_' at line 2 (localhost)"。
when run Special:Contributions
SELECT page_namespace,page_title,page_is_new,page_latest,
rev_id,rev_timestamp,rev_comment,rev_minor_edit,rev_user_text, rev_deleted FROM
page,revision FORCE INDEX (usertext_timestamp) WHERE page_id=rev_page AND
rev_user_text='老猪' ORDER BY rev_timestamp DESC LIMIT 50
from function "contribs_finder::find"。 MySQL returns error "1064: You have an
error in your SQL syntax near 'INDEX (usertext_timestamp) WHERE page_id=rev_page
AND rev_user_text='老猪'' at line 5 (localhost)"。
when run Special:Watchlist:
SELECT page_namespace,page_title,rev_comment, page_id,
rev_user,rev_user_text,rev_timestamp,rev_minor_edit,rev_id,page_is_new,wl_notificationtimestamp
FROM watchlist,page,revision FORCE INDEX (page_timestamp) WHERE wl_user=2
AND wl_namespace=page_namespace AND wl_title=page_title AND page_latest=rev_id
AND rev_timestamp > '20050803005507' ORDER BY rev_timestamp DESC
from function "wfSpecialWatchlist"。 MySQL returns error "1064: You have an
error in your SQL syntax near 'INDEX (page_timestamp) WHERE wl_user=2 AND
wl_namespace=page_namespace ' at line 4 (localhost)"。
Version: 1.5.x
Severity: normal
URL: http://www.dongfangtiger.de/wiki/