skooby
06-02-2006, 02:49 AM
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
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