Database error when viewing user profile

HenrikHansen · January 13th, 2009, 01:21 PM

Only when vbgallery is enabled, I get a database error when trying to see userprofile for (only) one of my users. This user has not uploaded any pictures in the vbgallery.

Database error in vBulletin 3.8.0 Release Candidate 2:
Invalid SQL:
SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
FROM usernote AS usernote
WHERE userid =;

No database error when trying to see other users. What might be the problem?
When I disable vbgallery, the problem disappears.

Chuck S · January 13th, 2009, 01:39 PM

what version of vbgallery are you using and when did you last update it?

HenrikHansen · January 15th, 2009, 01:55 PM

I am using 2.4.3. I guess it was last updated shortly after this version was released.

swordfish01 · February 5th, 2009, 05:47 PM

any resolution to this bug???

Chuck S · February 5th, 2009, 08:55 PM

I beleive there is another thread I posted on this issue. Have you tried disabling plugins other than vbulletin and vbgallery maybe another hack is your issue?

I have a stock vbgallery installed as a test with vbulletin 3.81 and I do not see any issues try looking here as an example

Reeftalk Forums - View Profile: Chuck S

Reeftalk Forums - View Profile: testing

Is there some other action we are unaware of? Those are links of a user who has no gallery pictures and me who has many.

swordfish01 · February 6th, 2009, 10:05 AM

yes I tried disabling vbseo.. the only other mod I have installed.

This is on VB 3.8.1

Quote:

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
FROM usernote 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
Request Date : Friday, February 6th 2009 @ 10:52:59 AM
Error Date : Friday, February 6th 2009 @ 10:52:59 AM
Script : Braces Forums - View Profile: jenn773
Referrer : Braces Before and After Photo Gallery
IP Address : *********
Username : *********
Classname : *********
MySQL Version : 4.1.22-standard

swordfish01 · February 6th, 2009, 10:09 AM

apparently when I disable this plugin, everything works OK.

When enabled, I get that mysql error and also notice a bunch of member are showing as usergroup GUEST

The gallery however is still live even when disable...? and seems to work normally...

swordfish01 · February 6th, 2009, 10:23 AM

I updated User Counts through the maintenance and all works well now...

Chuck S · February 6th, 2009, 10:38 AM

Not a problem glad you sorted it.