Re: Wiki URL configuration

Hello All,

I got another chance to look at the Apache2 setup for the wiki.  I
believe I've got the rewrite rules configured correctly.

All is not perfect (of course).  I clicked on the related changes
link, and got an SQL syntax error.  I briefly turned on SQL error
reporting to see see this:

----------------------------------------------------------------------------


A database query syntax error has occurred. This may indicate a bug in
the software. The last attempted database query was:

    (SELECT recentchanges.*,wl_user,ts_tags FROM recentchanges LEFT
JOIN watchlist ON ((wl_user=2 AND wl_title=rc_title AND
wl_namespace=rc_namespace)) LEFT JOIN tag_summary ON
((ts_rc_id=rc_id)) INNER JOIN pagelinks ON ((rc_namespace =
pl_namespace AND rc_title = pl_title)) WHERE (rc_timestamp >=
'20121124000000') AND rc_bot = '0' AND pl_from = '1583' ORDER BY
rc_timestamp DESC LIMIT 50 ) UNION (SELECT
recentchanges.*,wl_user,ts_tags FROM recentchanges LEFT JOIN watchlist
ON ((wl_user=2 AND wl_title=rc_title AND wl_namespace=rc_namespace))
LEFT JOIN tag_summary ON ((ts_rc_id=rc_id)) INNER JOIN templatelinks
ON ((rc_namespace = tl_namespace AND rc_title = tl_title)) WHERE
(rc_timestamp >= '20121124000000') AND rc_bot = '0' AND tl_from =
'1583' ORDER BY rc_timestamp DESC LIMIT 50 ) UNION (SELECT
recentchanges.*,wl_user,ts_tags FROM recentchanges LEFT JOIN watchlist
ON ((wl_user=2 AND wl_title=rc_title AND wl_namespace=rc_namespace))
LEFT JOIN tag_summary ON ((ts_rc_id=rc_id)) INNER JOIN imagelinks ON
((rc_title = il_to)) WHERE (rc_timestamp >= '20121124000000') AND
rc_bot = '0' AND il_from = '1583' AND rc_namespace = '6' ORDER BY
rc_timestamp DESC LIMIT 50 ) ORDER BY rc_timestamp DESC LIMIT 50

from within function "SpecialRecentchangeslinked::doMainQuery".
Database returned error "1: near "(": syntax error".

----------------------------------------------------------------------------

My first pass at this is that SQLite3 doesn't like the parens around
each of the three select statements.  I'll file a bug report about
this.

James