[Bug 2.4.3] Plugin on fetch_userinfo_query causes DB errors - Page 4

Chuck S · June 11th, 2009, 10:48 AM

Have you disabled all products and plugins except vbgallery and tried? I am sitting here with a default vb and vbgallery 2.5 and can not product that issue.

None of the queries your noting also have anything to do with vbgallery which is the stumper.

horusbird · September 10th, 2009, 04:02 AM

Hello, I just bought Photopost VBGallery and installed it on VBulletin 3.8.4
After some hours, I noticed some errors in the database and verified that they were about new users registered after installing Photopost; looking on your forum, I read that it could be caused by userinfo merge and disabled it in plugin management.
The database error disappeared, but I still have the problem that new registered users have 0 post in the forum even if they have more, and they are in a group "guest" that doesn't exist in the VBulletin groups.
To resolve this I have to launch in VBGallery the option "Update User Counts"
Is it possible to resolve this bug?
The gallery is active and functioning, so it can't be caused by this like I read in your forum.

Thanks

Chuck S · September 10th, 2009, 10:21 AM

To our knowledge any reported bugs have been resolved.

Now what is your specific error?

horusbird · September 11th, 2009, 08:30 AM

with enabled userinfo enable the error is:

Code:

Content visible to verified customers only.

with enabled userinfo disable no error in database but:

Code:

Content visible to verified customers only.

Code:

Content visible to verified customers only.

Chuck S · September 11th, 2009, 10:22 AM

well quite simply what is the contents of your user update data plugin hook?

The add user to gallery admincp is the plugin question I believe it should be this

Code:

Content visible to verified customers only.

horusbird · September 11th, 2009, 11:08 AM

Yes, "Add User to Gallery AdminCP" contains that code and is enabled.

Chuck S · September 11th, 2009, 11:23 AM

well make sure it is exactly as I posted there was a minor difference with the reported bug but I dont see how there could be any errors running the code. I have a test gallery setup and running vbgallery I am not seeing any issues. This is an old reported issue.

horusbird · September 12th, 2009, 04:53 AM

Yes, it is the same.
I tried to uninstall vBGallery I deleted all the files and I have reupload, I reinstalled but the problem remains.

I have a doubt, the registration of users is not made by VBulletin forum because I use a joomla bridge that passes the user data to VBulletin may depend on it?

Alternatively, you can create a scheduled task in vbulletin that runs every hour "update user counts"?

thanks

horusbird · September 12th, 2009, 05:10 AM

The problem is the same as shown in this post: Problem

Chuck S · September 12th, 2009, 08:27 AM

Is it the same as in post 65 above and you can always recount users to add old users. make sure the code is as I posted and register a new user.

horusbird · September 14th, 2009, 07:05 AM

Quote:

Originally Posted by Chuck S

Is it the same as in post 65 above and you can always recount users to add old users. make sure the code is as I posted and register a new user.

The code is identical, for security I copied yours and I pasted, I registered a new user and the problem remains the same

Chuck S · September 14th, 2009, 09:27 AM

well feel free to post a url admin login ftp info etc to the contact us link.

Remember the error your getting has NOTHING TO DO WITH VBGALLERY nor the original post of this thread.

Code:

Content visible to verified customers only.

Nowhere does vbgallery send emails such as this or does it have anything to do with user activations. Your not even querying a vbgallery table there.

horusbird · September 16th, 2009, 11:09 AM

i KNOW THAT THE DATABASE ERROR IS NOT DIRECTLY LINKED TO VGALLERY'S TABLES, BUT SURELY DEPENDS FROM THE FACT that vgallery's user table is not automatically refreshed when an user registers on vbulletin.

If I open the tables I see that vbulletin's users are 14001 when in vbgallery they are 14000

if I launch update user counts instead, the two tables become 14001 and the error disappears.

deactivating vbgallery, there is no error.

actually the plugin that must write new users in vgallery's table doesn't automatically do that and some operations on user profile in Vbulletin (like avatar management or others that I didn't really understand) create errors on the database because they look for a user with "empty" userid.

to verify online what data do you actually need: admin password and ftp password?

thank you

Chuck S · September 16th, 2009, 11:20 AM

Right but the problem I see here is why is the userid blank?

Remember it does not matter persay if the user is not in the vbgallery user table well it does for vbgallery stuff not vb so the query in question here is not a vbgallery one.

Code:

Content visible to verified customers only.

Your not querying the vbgallery user table there thats an all vb query there. So thats why I am wondering why vbgallery would be causing anything there.

Now as far as adding the user to the vbgallery user table the query to do that should be this

Code:

Content visible to verified customers only.

You could try removing the conditional around it in that plugin to see if that helps

Code:

Content visible to verified customers only.

Chuck S · September 16th, 2009, 11:26 AM

Now personally my choice observation here is maybe you have a hack conflict.

I have a totally clean vb and vbgallery install no other hacks or products installed. Clean vb code in every way. Now if I register a user in vb the userid is entered in the vbgallery users table. Things appear to work just fine.

Therefore as I believe I have posted before the first order of business is to uncheck all other plugins and leave vb and vbgallery as default code and test.

horusbird · September 16th, 2009, 02:34 PM

Quote:

Originally Posted by Chuck S

Code:

Content visible to verified customers only.

You could try removing the conditional around it in that plugin to see if that helps

Code:

Content visible to verified customers only.

I removed the conditional , I registered a new user and now seems to work without errors!

Now I'm still testing and see if we have solved.
Many thanks

Marco

http://www.vesparesources.com

Chuck S · September 16th, 2009, 07:59 PM

Interesting indeed since my site is working with the default code. Have you tried the default code without any other plugins active?

Luciano · September 17th, 2009, 05:47 AM

Quote:

Originally Posted by Chuck S

Interesting indeed since my site is working with the default code. Have you tried the default code without any other plugins active?

I am interested also...

Quote:

Originally Posted by horusbird

I have a doubt, the registration of users is not made by VBulletin forum because I use a joomla bridge that passes the user data to VBulletin may depend on it?

could this be a reason?

luc

Chuck S · September 17th, 2009, 06:40 AM

Horusbird well exactly there is your issue. If your registration is being done by joomla and its just dumping a vb user info into vb's tables etc then there are some actions its not accounting for or completes normally if your running a normal vb.

horusbird · September 17th, 2009, 08:06 AM

umm.....some errors have disappeared while others still remain, I believe that the best solution is to make a cron every hour that launches "update user count," you can tell me how to write it?
Thanks