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
Version: 1.16.x
Severity: major
OS: Windows XP
Platform: PC