Last modified: 2009-10-17 12:24:55 UTC
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
Probably it just can't handle () UNION (): sqlite> select 1 as foo union select 2 as foo; 1 2 sqlite> (select 1 as foo) union (select 2 as foo); SQL error: near "(": syntax error
Created attachment 6532 [details] Proposed patch
Patch committed in r57861