https://bugzilla.wikimedia.org/show_bug.cgi?id=20256
Summary: RecentChanges broken for SQLite
Product: MediaWiki
Version: 1.16-svn
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: major
Priority: Normal
Component: Database
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: maxsem.w...@gmail.com
SQL error from within function "SpecialRecentChanges::doMainQuery". SQLite
returned error "1: near "(": syntax error".
Query:
(SELECT * FROM recentchanges LEFT JOIN watchlist ON ((wl_user=2 AND
wl_title=rc_title AND wl_namespace=rc_namespace)) LEFT JOIN page ON
((rc_cur_id=page_id)) LEFT JOIN tag_summary ON ((ts_rc_id=rc_id)) WHERE rc_new
= '1' AND (rc_timestamp >= '20090808000000') AND rc_bot = '0' ORDER BY
rc_timestamp DESC LIMIT 50 ) UNION (SELECT * FROM recentchanges LEFT JOIN
watchlist ON ((wl_user=2 AND wl_title=rc_title AND wl_namespace=rc_namespace))
LEFT JOIN page ON ((rc_cur_id=page_id)) LEFT JOIN tag_summary ON
((ts_rc_id=rc_id)) WHERE rc_new = '0' AND (rc_timestamp >= '20090808000000')
AND rc_bot = '0' ORDER BY rc_timestamp DESC LIMIT 50 ) ORDER BY rc_timestamp
DESC LIMIT 50
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
