I am having this same problem. It's been about 2 months, is there a fix in the works? Disabling this particular plugin removed the gallery pictures from a member profile.
Here is a copy of the error I receive when, for example, you try to view the profile of a member who has not yet been approved.
Database error in vBulletin 3.7.2:
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 : Monday, July 28th 2008 @ 02:56:16 AM
Error Date : Monday, July 28th 2008 @ 02:56:16 AM
Script : http://www.xxxx/forums/members/xxxx.html
IP Address : X.X.X.X
Username : Unregistered
Classname : vB_Database
MySQL Version :