Topic on Project:Support desk

Last edited page: A database query error has occurred. This may indicate a bug in the software

3
Sirlordrouter (talkcontribs)

I get the following error on the Last Edited Page.

You'll find the Wiki here:

http://e-health-wiki.ch/index.php/Spezial:Letzte_%C3%84nderungen

The Error fromn SQL is as following:

SELECT  rc_id,rc_timestamp,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,rc_source,rc_patrolled,rc_ip,rc_old_len,rc_new_len,

rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,wl_user,wl_notificationtimestamp,page_latest,(SELECT  GROUP_CONCAT(ct_tag SEPARATOR ',')  FROM `wiki_change_tag`   WHERE ct_rc_id=rc_id  ) AS ts_tags,fp_stable,fp_pending_since  FROM `wiki_recentchanges` LEFT JOIN `wiki_watchlist` ON (wl_user = '3' AND (wl_title=rc_title) AND (wl_namespace=rc_namespace)) LEFT JOIN `wiki_page` ON ((rc_cur_id=page_id)) LEFT JOIN `wiki_flaggedpages` ON ((fp_page_id = rc_cur_id))  WHERE rc_bot = '0' AND (rc_timestamp >= '20170821000000') AND (rc_namespace NOT IN ()) AND rc_new IN ('0','1')   ORDER BY rc_timestamp DESC LIMIT 50 

  • Funktion: SpecialRecentChanges::doMainQuery
  • Fehler: 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 ')) AND rc_new IN ('0','1') ORDER BY rc_timestamp DESC LIMIT 50' at line 1 (localhost)

Version:

MediaWiki 1.26.0
PHP 5.5.4 (apache2handler)
MySQL 5.6.13-log
Reception123 (talkcontribs)
Ciencia Al Poder (talkcontribs)

This doesn't look like a missing updata.php, but a bug or misconfiguration. There's a where clause (rc_namespace NOT IN ()) which is obviously missing the "in" value list. Apparently the recent changes page is trying to exclude a list of namespaces from displaying changes. Maybe you're using an extension that's not properly configured (a list of namespaces to be hidden from rc?)

You should upgrade anyway to a supported MediaWiki version