DB error when product Disabled

[Arachnopets]

Hey Guys,

I'm currently trying to troubleshoot some issues on my forums and need to turn off plugins. Unfortunately, whenever I disable vbgallery, I get the following sql error.

MySQL Error : Unknown column 'ppgal_user.lastpostid' in 'field list'

if I disable all hooks, in config php then I'm able to recover by reenabling vbgallery.

Please help.

Regards

[Chuck S]

What version of vbGallery? I do not see anything in the archives here on this so need some info.

[Arachnopets]

Version 2.51

[Chuck S]

So let me understand you.

If you simply disable all plugins you have no error. If you disable vbgallery you have this error?

What action is it that you are doing to get the error? What is the EXACT FULL error shown.

[Arachnopets]

If I either go into products and disable vbgallery or go into plugins and uncheck all vbgallery plugins, my db crashes. If I try to refresh the admin cp, errors out.

If I upload a config.php with the disable hooks code in it, then I am able to log back into the control panel. if at that point, I reenable vbgallery and then upload a config.php without the hooks disabled then it all works again.

I can shut off any other products or plugins without any problems to the forum.

The exact error email that I get is as follows:

Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS
passworddate, user.languageid AS saved_languageid,
IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
, user.userid AS userid, ppgal_user.lastpostid AS gallastpostid, user.lastpostid
AS lastpostid
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0,
1, user.languageid))

WHERE user.userid = 17099;

MySQL Error : Unknown column 'ppgal_user.lastpostid' in 'field list'
Error Number : 1054
Request Date : Thursday, May 19th 2011 @ 04:09:51 PM
Error Date : Thursday, May 19th 2011 @ 04:09:51 PM
Script : Arachnoboards - Powered by vBulletin
Referrer :
IP Address : 74.82.64.16
Username :
Classname : vB_Database
MySQL Version :

[Chuck S]

I just did a search on the vbGallery code there is no such code in our program so your issue must have to do with some code modification you have done.

There is no instance of gallastpostid in vbGallery so you have changed something and this is your issue.

[Arachnopets]

Hi Chuck,

I think I figured out the issue, but was wondering if you could tell me if there might be any consequences of it. It does have to do with an older version of vbgallery that was previously installed.

If you look at this thread:

[Bug 2.4.3] Plugin on fetch_userinfo_query causes DB errors

I looked through my plugins and I have the plugin from this post created:

[Bug 2.4.3] Plugin on fetch_userinfo_query causes DB errors

If that is disabled and I then disable the vbgallery product, then I'm not seeing any errors like I was before

Should it be okay to just delete that plugin? Have all of the problems that were discussed in that thread been fixed in 2.51?

Regards

[Chuck S]

Your issue would be with some alteration you applied suggested by some user not our company. Any true issues that might have caused any errors would have been fixed. There have been no such related issues posted regarding this about 2.51 and any other fixes where applied to 2.43 to my knowledge. The code your posting that has a problem with that query is the user suggestion not stock code.

[Arachnopets]

Hi Chuck,

I just noticed that when I disable that plugin, the original problem with the wrong last post information returns. with that plugin disabled & vbgallery turned off, the last post resolves correctly. Do you have any suggestions? vBgallery is apparently causing the issue still. At least on my installation.

[Arachnopets]

I have a question regarding this now. Under the vbgallery plugins, I have one called "userinfo merge". This uses the same hook that the "last post fix", that I created, plugin used. When I turn off your "userinfo merge" plugin in additon to my "last post fix" plugin, the problem also goes away. Has your "userinfo merge" plugin been removed as part of the program? Is it even supposed to be there anymore?

[Chuck S]

There are no sql issues using a default vbgallery build downloaded from us. any true issues the company posted a fix for have long since been applied to our product and things work fine. This entire discussion is around some modification you did to your code. I can not guess as to what interactions or issues you would have using some users suggestions in a thread. That would not have been tested by our company.

[Arachnopets]

okay, lets try this again.

ALL plugins and products are disabled except for vb Gallery.

Following me so far?

When I look at my profile, with YOUR "Userinfo Merge" plugin enabled, this is what I see:

Content visible to verified customers only.

If I disable YOUR "Userinfo Merge" plugin, then this is what I see:

Content visible to verified customers only.

Now to make sure that this is, in fact, YOUR "Userinfo Merge" plugin, this is the code that is in the "Userinfo Merge" plugin.

Content visible to verified customers only.

is that as it is supposed to be?

There was to my knowledge no modifications done to my code although, I could be wrong, it has been a while since I've done anything with the vB Gallery as it has been working fine.

The only things that I remember doing were creating a plugin, which is disabled and therefore of no consequence and editing templates which have since been updated and reverted to stock.

[Chuck S]

I do not see anything wrong in your examples.

If vbGallery is enabled all plugins for it should be enabled. when you disable vbGallery then you should not get any db errors. This is what I am responding about your actual error you posted here about.

I can not speak on the validity of what should or should not appear in your last posts field. That again is discussion in some other thread.

Your error here is with a modification you did yourself

Content visible to verified customers only.

This is nowhere in vbGallery and the heart of your issue

Get rid of any edits you did and your db error will go away. You applied some edit to a query as part of some mod you did and this is what is causing your issue.

[Arachnopets]

Chuck,

We're past that issue. That DB error went away after I turned off the plugin that I created to fix the last post issue. There were no other modifications that I did myself that still exist other than the creation of that plugin. that plugin is now disabled and everything is fine if I turn off the gallery.

Maybe I should have started a new thread....

The problem is now that on random users profile pages, my own included, if I go to the statistics page the "last post" information is incorrect.

If I then go into my plugins and turn off the "Userinfo Merge" plugin that is a part of vbulletin gallery, then the information on my statistics page is correct.

[Chuck S]

Feel free to post any new issues sure. Luciano can respond about any issue you report.