Support Forum

Invalid database query

CM Chris Marlow
Chris Marlow
Member

Hello — neither i nor my membership can access the forum. When we click on one of the forum topics it says invalid database query in a blue-green notice and then lower down it says “access denied–you do not have permission to view this page.”

Please help!

THanks

Chris Marlow

17 Answers

New Answer

MP Mr Papa
Mr Papa
Member

what version of wp? and sp? and all sp plugins up to date?

can you provide more info on the db query error? you should be able to see it on forum – toolbox – error log…

CM Chris Marlow
Chris Marlow
Member

it’s wp 4.0, and sp is version 5.5.2. I don’t know what you mean by “all sp plugins,” I only see the one sp plugin… I am attaching the error log, which of course I cannot read… I am not a coder…

Thank you Mr PaFORUM-ERROR-LOG-MARLOW.jpg

 

pa…

YS Yellow Swordfish
Yellow Swordfish
Member

Well Steve was asking about the versions of all the SP plugins you DO use. And it looks like you have updated WP and SP core but have not updated the plugin(s) you do use as that is, I think you will find, the cause. You should find that listed in the standard WP updates admin page.

CM Chris Marlow
Chris Marlow
Member

I was updating plugins when this happened. Everything is “blue” indicating they are updated except visual form builder pro but it does not say that it needs updating, and Wishlist member has a new version but I don’t want to update because I don’t need or want what their updates are.

I will say this… I hate updating. It always seems to lead to this kind of problem! Could it be that I deactivated something? I’m getting ready to get rid of some plugins b/c the site is so slow.

CM Chris Marlow
Chris Marlow
Member

Is there anyone here I can HIRE to fix this????

IK Ike
Ike
Member

I’m not sure if this is the case here, but it’s generally a good idea to update plugins because of the relationships between SP core, SP plugins and WP plugins (and of course WP core and WP plugins). If updating Wishlist member doesn’t take away from your usage and only adds features you are not interested in, I would strongly recommend updating it just to make sure it’s not causing a problem.

As for the questions being asked my Mr Papa and Yellow Swordfish, you haven’t mentioned SP plugins such as the one in the screenshot you posted which was referring to the file uploader with plupload.

Please take a look in the WP admin page at Forum > Plugins – to see if anything needs updating. I believe the plugin background being blue simply means it is active.

YS Yellow Swordfish
Yellow Swordfish
Member

That’s right – the SP File Uploader plugin. So – is it in the WP ‘Updates’ list?

CM Chris Marlow
Chris Marlow
Member

I found needed updates in Forum > Plugin — I had no idea they were there. Before I update them all, do I need to do anything else first, before updating them? I’m pretty nervous about causing more problems since I really understand only about half of what I’m hearing…

CM Chris Marlow
Chris Marlow
Member

ok, I updated the forum plugins but every one of them says “error — the plugin is already updated.” I checked the forum again and the problem is still there. I am really hesitant to update wishlist member b/c i don’t want to spend money on useless upgrades, and this problem happened RIGHT after I did the plugin updating. Please advise. Thank you.

Also do you know where I could go to find someone to hire to get this fixed? Could a regular wordpress pro figure this out, do you think?

CM Chris Marlow
Chris Marlow
Member

In Fact, i don’t want to EVER have to do this kind of work again. Who would be the right person to hire to make sure I don’t have downtime on my Forum? People are not getting in since yesterday…

YS Yellow Swordfish
Yellow Swordfish
Member

Can you explain this please? Are you saying they were listed in the WordPress admin > Dashboard > Updates panel as needing to be updated yet when you tried to update them you got a message saying they had already been done? 

If this is the case then it would be worthwhile trying to find out what is causing the problems. We have had thousands of updates to these items without incident.

if you really prefer to just let other people do it I can probably ask Brandon here to take a look.

CM Chris Marlow
Chris Marlow
Member

This problem happened after I did routine plugin updating at WP admin > plugins. Then Ike said this:

“Please take a look in the WP admin page at Forum > Plugins – to see if anything needs updating”

So I went to WP admin page > Forum > plugins. It appeared a number of plugins need updating. I updated them and it showed “error–plugin already updated.”

I checked the forum and tried to get into a topic and it returned “Invalid query”. I have not seen any change in anything.

I feel stuck and like I am wasting my time. I would appreciate if Brandon would take a look. It seems to me that the experts here, who know the forum technology, would be able to figure it out much faster than me. What do you need from me?

YS Yellow Swordfish
Yellow Swordfish
Member

First please see my previous post. WordPress admin > Dashboard > Updates. Please look there for Simple:Press plugins. Are any listed as needing updating. And if so – will you please just try and update them.

CM Chris Marlow
Chris Marlow
Member

I have done this exactly as you said YellowSwfsh.

It says “error — the plugin is at the latest version.:

I have SP version 5.5.2

There are 2 plugins that require SP 5.3:

Post preview

Who’s online

What next?