[Bug 2.4.3] Plugin on fetch_userinfo_query causes DB errors

Kirby · May 12th, 2008, 11:05 AM

Code:

Content visible to verified customers only.

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.

Zachariah · May 13th, 2008, 07:47 AM

Quote:

Originally Posted by Kirby

Code:

Content visible to verified customers only.

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:

Code:

Content visible to verified customers only.

To:

Code:

Content visible to verified customers only.

Kirby · May 15th, 2008, 05:55 AM

[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.

Zachariah · May 20th, 2008, 07:15 AM

I am going to change the system a bit.

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

Mike_K · May 23rd, 2008, 08:19 AM

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?

Zachariah · May 23rd, 2008, 09:50 AM

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

info5538 · July 28th, 2008, 06:17 AM

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

hotwheels · August 2nd, 2008, 03:49 PM

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

animate · August 4th, 2008, 12:30 PM

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 :

hotwheels · August 5th, 2008, 09:33 AM

Quote:

Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT user.username, shout.userid, shout.shoutid, shout.shoutby, shout.message, shout.dateline
FROM vbp_shout AS shout
LEFT JOIN vb3user AS user ON (shout.userid = user.userid)
WHERE shout.visible = 1
AND (shout.private = 0 OR shout.userid = )

ORDER BY shout.shoutid
DESC LIMIT 6;
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 ')

ORDER BY shout.shoutid
DESC LIMIT 6' at line 5
Error Number : 1064
Request Date : Tuesday, July 29th 2008 @ 09:06:56 PM
Error Date : Tuesday, July 29th 2008 @ 09:06:56 PM
Script : Insane Mustangs - Insane Mustangs
Referrer :
IP Address : ******
Username : ******
Classname : vb_database
MySQL Version :

Quote:

Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
FROM vb3usernote 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, July 29th 2008 @ 08:12:22 PM
Error Date : Tuesday, July 29th 2008 @ 08:12:22 PM
Script : Insane Mustangs, GT, Saleen, Roush, Cobra - View Profile: sslivingu
Referrer :
IP Address : ********
Username : Unregistered
Classname : vb_database
MySQL Version :

Quote:

Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT location, badlocation FROM vb3session WHERE userid = AND lastactivity > 1217385135 ORDER BY lastactivity DESC LIMIT 1;
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 'AND lastactivity > 1217385135 ORDER BY lastactivity DESC LIMIT 1' at line 1
Error Number : 1064
Request Date : Tuesday, July 29th 2008 @ 10:47:15 PM
Error Date : Tuesday, July 29th 2008 @ 10:47:15 PM
Script : Insane Mustangs, GT, Saleen, Roush, Cobra - View Profile: 20080729
Referrer : Insane Mustangs - Insane Mustangs
IP Address : *******
Username : hotwheels
Classname : vb_database
MySQL Version : 5.0.51a-community

Quote:

Database error in vBulletin 3.7.2:
Invalid SQL:
INSERT INTO vb3logins (userid, username, ipaddress, phpdate, logintype) VALUES (, 'bparks77', '205.247.207.210', 1217361945, '');
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 ' 'bparks77', '205.247.207.210', 1217361945, '')' at line 1
Error Number : 1064
Request Date : Tuesday, July 29th 2008 @ 04:05:45 PM
Error Date : Tuesday, July 29th 2008 @ 04:05:45 PM
Script : Insane Mustangs, GT, Saleen, Roush, Cobra - Powered by vBulletin
Referrer : Insane Mustangs - Insane Mustangs
IP Address : ********
Username : bparks77
Classname : vb_database
MySQL Version :

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....

Chuck S · August 5th, 2008, 09:34 AM

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.

Mike_K · August 5th, 2008, 02:43 PM

Think it's time for a bugfix!

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.

Chuck S · August 5th, 2008, 08:11 PM

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

animate · August 6th, 2008, 12:27 PM

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

info5538 · August 12th, 2008, 08:16 PM

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.

Chuck S · August 12th, 2008, 09:47 PM

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.

info5538 · August 13th, 2008, 06:11 PM

Quote:

Originally Posted by Chuck S

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.

animate · August 22nd, 2008, 02:38 PM

have anyone fixed the bug?

Chuck S · August 22nd, 2008, 02:45 PM

[Bug 2.4.3] Plugin on fetch_userinfo_query causes DB errors

This post has the bugfix that I am aware of.

hotwheels · August 24th, 2008, 04:17 PM

I tried that fix today chuck

Quote:

if (!$vbulletin->GPC['userid'])
{
$galusers = $db->query("SHOW TABLE STATUS LIKE '". TABLE_PREFIX . "user'");
while ($galuser = $db->fetch_array($galusers))
{
$galuserid = $galuser['Auto_increment'];
$db->query_write("REPLACE INTO ". TABLE_PREFIX . "ppgal_user (userid) VALUES ($galuserid)");
}
}
?>

i still get this error as i did before:

Quote:

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
FROM vb3usernote 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, August 24th 2008 @ 05:15:22 PM
Error Date : Sunday, August 24th 2008 @ 05:15:22 PM
Script : Insane Mustangs, GT, Saleen, Roush, Cobra - View Profile: lilspitfire98
Referrer : Insane Mustangs - Insane Mustangs
IP Address : **********
Username : **********
Classname : vb_database
MySQL Version : 5.0.51a-community