Viewing user profile produces DB Error

[StarBuG]

Now after fixing the ACP user issue by uploading the newest 2.4.3. version on my forum I can't view user profiles anymore.

I get the following db error.

Datenbankfehler in vBulletin 3.7.4:

Invalid SQL:

SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
FROM usernote AS usernote
WHERE userid =;

MySQL-Fehler : 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
Fehler-Nr. : 1064
Fehler-Zeit : Tuesday, 24.02.2009 @ 17:11:51
Datum : Tuesday, 24.02.2009 @ 17:11:52
Skript : http://www.domain.de/member.php?action=getinfo&u=470
Referrer :
IP-Adresse : 88.68.207.16
Benutzername : T-Rex
Klassenname : vB_Database
MySQL-Version : 5.0.67-0.dotdeb.1-log

[Chuck S]

Interesting are you using any other hacks?

http://www.reeftalk.com/forums/member.php?u=1

I enabled the gallery profile thing and my stuff comes up.

How about did you do this?

AdminCP => vBGallery => Maintenance => Update User Counts

[StarBuG]

ok, after updating the counter it works

[Chuck S]

have a good day.