Likely Bug found:
From the forum homepage, with this mod enabled (on the left side): If a user clicks "quick links->Mark Forums Read" it generates the following mysql error..
PHP Code:
Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.postusername, thread.replycount, thread.lastposter, thread.views, thread.attach,icon.title AS icontitle, icon.iconpath
FROM thread AS thread
LEFT JOIN icon AS icon ON(icon.iconid = thread.iconid)
WHERE forumid =
order by views DESC
LIMIT 10;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by views DESC
LIMIT 10' at line 5
Error Number : 1064
Request Date : Tuesday, May 20th 2008 @ 01:21:45 PM
Error Date : Tuesday, May 20th 2008 @ 01:21:45 PM
Script : xxx/forumdisplay.php?do=markread
Referrer : xxx/index.php
IP Address : XX.XX.XX.XX
Username : XXXXX
Classname : vB_Database
MySQL Version : 5.0.45-community
This does not happen with the mod disabeld.
thanks
-vissa