Error if I view a profile of new user

[jazde86]

I get a error, if I view a profile of a new registered user under vB 3.7.0 - where is the section for this version? I've to disable vBGallery to get the profiles working.

Datenbankfehler in vBulletin 3.7.0:

Invalid SQL:

SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
FROM pre_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 : Wednesday, 07.05.2008 @ 10:01:13
Datum : Wednesday, 07.05.2008 @ 10:01:13
Skript : http://forum.???.de/member.php?u=1303
Referrer : http://forum.???.de/index.php
IP-Adresse : ??.???.???.???
Benutzername : test
Klassenname : vB_Database
MySQL-Version : 5.0.51a-community

[Zachariah]

I have tryed 2 different ways of adding a new user.
- forums/register.php
- AdminCP -> Users -> Add New User

Everything seems ok.

========================

Please make sure that these 2 files are there on your server.

At forums\includes\vbgallery:
- register_addmember_complete.php
- useradmin_update_data.php

-----------------------------------

Lets also make sure that the plugins are in your database and active.

AdminCP => Plugins & Products => Plugin Manager
- Product : PhotoPost vBGallery
-- Add User to Gallery AdminCP
-- Add User to Gallery on Register

-----------------------------------
You can sync your gallery user table and forum table
- AdminCP => vBGallery => Maintenance
-- Update User Counts

[jazde86]

These files are there and the plugins are active too.

The userid not exists in the error. User profiles from users registered before upgrading to vB 3.7 I can browse without any errors.

[jazde86]

Yeah, thx for the edit Zachariah. I've done every Maintenance and now it works very well.

Looking forward to see what happened, if a new user has been registered.