PDA

View Full Version : SQL Error After Installing


skooby
02 Jun 2006, 04:49
I can pretty much say there is a problem with vRewrite because when I turn it off the SQL Problem stops.

Here is the SQL error that comes up when vRewrite is enabled:

Database error in vBulletin 3.5.4:

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 (3,64,6,61,68)
AND t.visible = 1;

MySQL Error : You have an error in your SQL syntax near 'ON (u.username=t.lastposter)
WHERE t.threadid IN (3,64,6,61,68)
AND t.v' at line 3
Error Number : 1064

I am running VB 3.5.4 and vRewrite 1.5.1. I left all the options on their default settings (except for turning it on). I double checked the 3 template files and the added line of code is correctly placed above $headinclude. Thanks for the help and it seems like a great plugin :)

Cheers :)
-Jimmy

Hypocrisy
01 Sep 2006, 10:01
I've got the same problem too. How do I fix this?

GafferSports
11 Sep 2006, 13:54
Superb support, considering I get this problem too and it has not been answered since June