View Single Post
Old November 22nd, 2009, 09:53 AM   #1 (permalink)
marinefiend
Member
Verified Customer
 
Join Date: Dec 2004
Location: Toronto, Ontario
Posts: 30
Getting this wierd new error

When clicking to look at a new member I am getting this

Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
FROM hc1usernote AS usernote
WHERE userid =;
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 '' at line 3
Error Number : 1064

But I have no problem looking at a user profile

I created a ticket at VB.com
and this is the response

Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php


PHP Code:
define('DISABLE_HOOKS', true);

_______________________________

So I have done that then retraced my steps back to disableing the gallery and the problem has gone away.

When I enable the gallery again it returns.

So I am going to asume that it is somewehere in the gallery code, but I am not sure where.
marinefiend is offline   Reply With Quote