Database error when viewing user profile
 

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.

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

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

any resolution to this bug???

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.

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

This is on VB 3.8.1

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...

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

Not a problem glad you sorted it.