Getting this wierd new error

[marinefiend]

When clicking to look at a new member I am getting this

Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
FROM hc1usernote 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

But I have no problem looking at a user profile

I created a ticket at VB.com
and this is the response

Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php


PHP Code:
define('DISABLE_HOOKS', true);

_______________________________

So I have done that then retraced my steps back to disableing the gallery and the problem has gone away.

When I enable the gallery again it returns.

So I am going to asume that it is somewehere in the gallery code, but I am not sure where.

[Chuck S]

well what version of the gallery are you running. I dont know why the gallery would affect some query thats not part of the gallery but anyway some more info would be needed here. like specifically what action your doing script name etc. I am assuming its member.php right

[marinefiend]

K, Chuck

here is the complete error, I am running PhotoPost vBGallery v2.5

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
FROM hc1usernote 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 : Sunday, November 22nd 2009 @ 09:57:23 AM
Error Date : Sunday, November 22nd 2009 @ 09:57:23 AM
Script : Hardcore Aquatics Inc. - A dedicated place for Responsible Aquarium Husbandry.
Referrer : Hardcore Aquatics Inc. - A dedicated place for Responsible Aquarium Husbandry.

Classname : vB_Database
MySQL Version : 5.0.81-community


Everything else is fine. I only get this erro when trying to click on Welcome to our newest member, USERNAME HERE

Now this is really weird. When I click the previous user 1235 it shows the member info no problem. when I go and click on 1236 I get that error.

When I diable the gallery in the pluggins section I can see the member no problem.

[marinefiend]

Chuck maybe it has something to do with the CMPS block, because when i turn off the pluggin for the gallery the block gets turned off as well, and than I can see the user again.

[marinefiend]

Now to make this work I have to disable the ppvbgallery in the Pluggin and Products section...Oh and it only happens on the last member that signed up.

[Chuck S]

I will search and see if I can find anything

Now you can send admin login ftp info through the contact us link so I can look into it

[marinefiend]

OK will do, and message sent

[Chuck S]

No problem I emailed you back

[Larry]

When I disable PhotoPost vBGallery 2.5 this problem goes away.
when I re-enable problem comes back.

Only produces error for some users, not all.

Forum is internal, so error message is scrubbed.

text of error is:
------------------------------

Database error in vBulletin 3.8.4:

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 : Tuesday, December 22nd 2009 @ 08:15:22 AM
Error Date : Tuesday, December 22nd 2009 @ 08:15:22 AM
Script : http://***/member.php?u=114
Referrer : https://***/
IP Address : *.*.*.*
Username : Larry
Classname : vB_Database_MySQLi
MySQL Version : 5.0.84

[Chuck S]

You can send us an actual admin login to view things and I will see if I can help

[Larry]

Disabled Userinfo Merge - OK now

It is an internal forum, you would not be able to get through the firewall.

Thanks for the offer.

[Chuck S]

You can try this post

http://www.photopost.com/forum/1253725-post28.html