GAB Issue Mark All Forums Read SQL Error

[Michael-MI]

Users are reporting and I can confirm via sql database errors.

The user is doing the following:

- Forum Home
- Click Quick Links
- Click Mark All Forums Read
- Invalid SQL:
SELECT DISTINCT type, adid FROM GAB_listing
WHERE 1=1 AND script = 'forumdisplay' AND forumid= ORDER BY RAND() LIMIT 1;

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 RAND() LIMIT 1' at line 2
Error Number : 1064
Date : Saturday, February 11th 2006 @ 08:08:34 PM
Script : http://www.mouseinfo.com/forums/forumdisplay.php?do=markread
Referrer : http://www.mouseinfo.com/forums/search.php?searchid=361504
IP Address : XXXXXXXXX
Username : Michael
Classname : vb_database

- I temporary removed the forumdisplay script and that did not resolve the issue. Any ideas? Thank you.

Michael

[The Geek]

Thanks... give me a few minutes and ill update the package.

[Michael-MI]

I updated the files and that resolved my issue. Thank you!

Michael