[Bhuwan]

Originally Posted by funinthesun

I've just installed this and when I switch vRewrite on I get this error

Database error in vBulletin 3.5.3:
 
Invalid SQL:
 
            SELECT t.lastposter AS username, u.userid, t.threadid
            FROM thread AS t JOIN user AS u ON (u.username=t.lastposter)
            WHERE t.threadid IN (5476,2059,1341,5487,3926,5491,3643,5497,5489,5488,5298,5498,5343,5486,5310,5465)
                AND t.visible = 1;
 
MySQL Error  : You have an error in your SQL syntax near 'ON (u.username=t.lastposter)
            WHERE t.threadid IN (5476,2059,1341,5487,3926,5' at line 3
Error Number : 1064

Any ideas why?

Which mysql version are you running?