Database error invalid SQL select

Like many others, this morning I have been getting a million errors from something title='pluginlist'

My question is unfortunately I can't fix the issue until I get home from work around 3 et. Is my forum in a serious condition where this must be fixed now or will I be ok until I get home this afternoon.

I am on vb 3.8.7 pl2 and running seo 3.3.0.

I plan on upgrading seo when I get home but would like some help/encouragement to ease my nerves with this.

Hello ,

You need to check #167 and run vbseo_checkplugins2.zip script

Thanks for the reply. When I get home in a bit I'm gonna get started on this.

Right now I'm on vb 3.8.7 and seo 3.3.0.

Before I upgrade to the latest seo do you want me to run that check plugin script you provided above first?

I ask because I want to do this right the first time.

Any other suggestions/questions please ask me.

Run the tool first, clean it up.
Then do the upgrade,
And run the tool again to be sure.

Originally Posted by Arapahoe

Like many others, this morning I have been getting a million errors from something title='pluginlist'

My question is unfortunately I can't fix the issue until I get home from work around 3 et. Is my forum in a serious condition where this must be fixed now or will I be ok until I get home this afternoon.

I am on vb 3.8.7 pl2 and running seo 3.3.0.

I plan on upgrading seo when I get home but would like some help/encouragement to ease my nerves with this.

Exactly a similar issue here. Check this thread out: Getting Database Error Mails Despite of Applying Patch

Originally Posted by tyagikapil

Exactly a similar issue here. Check this thread out: Getting Database Error Mails Despite of Applying Patch

To fix this AFTER you've applied the patch (worked for me):

1) Log out
2) Clear ALL your cookies
3) Log back in
4) Go to plugins
5) Disable any plugin
6) Re-enable that plugin

Lemme know if that helps

Attached is what I see after I ran the /vbseo_checkplugins.php file

What should I do now? Click "Click here to reset datastore"?

I am running vbseo 3.3.0 and have not upgraded to the latest seo yet.

Yes, click the reset datastore link.

Well crap when I clicked it, this is what shows... now what

Can you run it again?

This has been fixed.

Thanks.

Stills for me...

Hello


1. Runing VBSEO 3.6
2. Patched the abstract file as mentioned on the Announcement
3. Ran the checkplugins2 file (nothing has shown up)
4. Repaired datastore template


result:
I am still getting 61 emails per minute with the invalid SQL warning:


Database error in vBulletin 3.8.2:


Invalid SQL:
SELECT * FROM datastore WHERE title='pluginlist';


MySQL Error :
Error Number :
Request Date : Thursday, January 26th 2012 @ 02:38:14 AM
Error Date : Thursday, January 26th 2012 @ 02:38:14 AM

Please just post in one spot. Having 3 threads to follow just makes it more difficult.

Originally Posted by Oleg Ignatiuk

Yes, click the reset datastore link.

Hi Oleg,

Even if we're not infected after vbseo_checkplugins2 checker, how do we reset datastore manually ?

You can run the script as: vbseo_checkplugins.php?resetds=1