[Bug 2.4.3] Plugin on fetch_userinfo_query causes DB errors
 

This causes ppgal_user.userid being read as userid - which is fatal if there is no entry for that user (eg. userid = NULL).

I performed the mainenance functions but the error persisted - so I had to disable the plugin.

There should not be a error on creation of the user in the gallery table.
- plugin: register_addmember_complete * Add User to Gallery AdminCP
- plugin: useradmin_update_save * Add User to Gallery on Register

Is there another way you are adding users that might need a SQL entry?

There is a single quote on AdminCP plugin in wrong place that a few people had problems with. (weird my 2 test systems did not error.)

edit:
forum/includes/vbgallery/useradmin_update_data.php

Change:
To:

[quoteIs there another way you are adding users that might need a SQL entry?[/quote]
There could be any curcumstances the DB entry could be missing - for example when new users are being createds while the product/plugin system is disabled.

You must make sure that standard fields (like user.userid) do not get overwritten.

I am going to change the system a bit.

Tables Merge:
ppgal_user => user
ppgal_settings => settings
ppgal_settinggroup => settinggroup

Sorry, I can't understand all.

I have the same error with the plugin "Userinfo Merge". DB errors at registration and also if cklicking on a not registered (not verifed) member (link to the memberprofil).

What does the plugin "Userinfo Merge" do? Is it necessary for the galery? And what have I to do exactly to correct the error?

You can disable for now, I will phase it out and collect the data another way.

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:

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 : 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
Referrer :
IP Address : X.X.X.X
Username : Unregistered
Classname : vB_Database
MySQL Version :
----------

Thanks

I have the same error as above.....I had to disable vbgallery for now....

same problem here with user information, and user cannot register on the board and admin cannot make changes on new register.


PROBLEM WITH USERS THAT LOOKS ON THE PROFILE:
Invalid SQL:
SELECT COUNT(*) as X FROM thanks 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 1
Error Number : 1064
Request Date : Sunday, August 3rd 2008 @ 11:15:39 PM
Error Date : Sunday, August 3rd 2008 @ 11:15:39 PM
Script : Animate e.V. - Profil ansehen: Master94
Referrer :
IP Address : 86.33.55.56
Username : seiya
Classname : vB_Database
MySQL Version : 5.0.32-Debian_7etch5-log


PROBLEM WITH USERS THAT WANT TO REGISTER:

Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT INTO logins (userid, username, ipaddress, phpdate, logintype) VALUES (, 'testaccount66322', '86.33.55.56', 1217867834, '');

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 ' 'testaccount66322', '86.33.55.56', 1217867834, '')' at line 1
Error Number : 1064
Request Date : Monday, August 4th 2008 @ 06:37:14 PM
Error Date : Monday, August 4th 2008 @ 06:37:14 PM
Script : Animate e.V. - Powered by vBulletin
Referrer : Animate e.V.
IP Address : 86.33.55.56
Username : testaccount66322
Classname : vB_Database
MySQL Version :

Here are a few of the errors i recieve
 

and the bookmarks block is broken.........I currently have the gallery shutoff so my site can continue to run. Hopefully there will be some sort of fix to this.....If a zach needs, i can give him access to my site and he can try to see if he can locate the problem from there........It took me a while to find that it was the vbgallery causing the problem, which sucks, cause it is a great software....

Have you tried turning off the plugins Zach noted or running them?

I am not too familiar with vbGallery but you could send info for us to look at this.

Think it's time for a bugfix! :cool:

But until this, go in the admin cp -> Add-ons & Plug-ins -> manage Plug-ins.

Find there under "Add-on : PhotoPost vBGallery" the Plug-in "Userinfo Merge" / Hook: "fetch_userinfo_query" and uncheck it.

This should help. Also no problems with the gallery.

Yes I do beleive this is what Zachariah had stated above until he could rewrite that entire plugin.

thanks Mike_K and Chuck_S for the support, i think i wait for the bug fixed version.......

Is Zach still working on this? Considering the renewal fees are the same as the more expensive products, I hope we get some bug fixes at least. Thanks for helping out Chuck/Mike.

Right now the only fix is to disable this plugin and there is no degrade to the product in doing so. I myself have fixed about 4 bugs in the last couple weeks.

When I disable the userinfo_merge plugin as recommended, it no longer shows the latest pictures in a member's profile page. So although this may fix the registration problems, it is disabling a very useful feature.

have anyone fixed the bug?

http://www.photopost.com/forum/1224161-post2.html

This post has the bugfix that I am aware of.

I tried that fix today chuck i still get this error as i did before: