Long wait after submitting new posts

[BugOutGirl]

Basically when anyone submits a new post to a thread, the software freezes/thinks for about 15-20 seconds before the post appears in the thread.

This has been happening for about a month, maybe two. I have opened a ticket with vbulletin and also with my host and neither were able to find the problem. I was hoping that with 5.1.8 the situation would resolve itself, as many of my issues do with the updates. But it's still the same. Doesn't seem to matter what browser or device is used. I thought it was my connection initially but other users are complaining about it as well.

I haven't changed anything on my website over the last few months. It just started happening out of the blue. It happens 100% of the time. I saw in another thread here today that a different user was experiencing the same issue on their site.

Any suggestions would be appreciated.

[Wayne Luke]

This is on vBulletin 5.1.8? If you look at your site on the network panel does anything stand out as taking a long time? To see the network panel in your browser press F12 and click on the Network or Net tab before submitting your post.

[BugOutGirl]

Correct 5.1.8

This is what happened in the network tab. 30 seconds to post... yikes!

[Mark.B]

Can you please try running these two queries and see if it improves things?

DELETE FROM cache
DELETE FROM cacheevent

NOTE: Do not run DELETE queries on any other table - you will break your site permanently!

[BugOutGirl]

Can you please try running these two queries and see if it improves things?

DELETE FROM cache
DELETE FROM cacheevent

NOTE: Do not run DELETE queries on any other table - you will break your site permanently!

It does not appear I am authorized to do so...

[glennrocksvb]

Edit /core/config.php and add your userid:

$config['SpecialUsers']['canrunqueries'] = '1'; //change 1 to your admin userid 

[BugOutGirl]

Ok, so I was able to give myself the authorization, but when I attempted to run the query, the main window in cpanel opened with my site and displayed a blank page with

"That action could not be completed. Please try again, and if this occurs again please contact the system administrator and tell them how you got this message. "

[Wayne Luke]

Go to Usergroups -> Administrator Permission and make sure you have all permissions.

Otherwise you can use phpMyAdmin or whatever tool your hosting provider has made available for that purpose.

[Mark.B]

Make sure also, if using the admincp method of running queries, that you run the queries one at a time.
If you paste them both together you will get the error you describe.

[BugOutGirl]

Yes I did them one at a time. And set all my permissions to yes.

I'm in touch with the server people to see how to do it on their end.

thanks guys.

[Mark.B]

Check this line in /core/includes/config.php:

$config['SpecialUsers']['superadmins']

Make sure your admin's userid is in the list of userids in that line of code.

So if your admin userid is 150, add it like this:

$config['SpecialUsers']['superadmins'] = '1,150';

[BugOutGirl]

Thanks, Mark.

i'll let you guys know how I make out

[Wayne Luke]

What version of MySQL are you using?

[Mark.B]

I just ran into the query issue on another site...the reason it's throwing that error is because you probably have a table prefix.
So you'll need to add that into the queries.

For example:

DELETE FROM vb_cache
DELETE FROM vb_cacheevent

Simplest way to see if you have a prefix is to go to AdminCP > Maintenance > Repair / Optimize Tables
In there you'll see all the table names and if they have a prefix you'll see it in front of each table name. (Don't actually do anything in that screen though!)

[BugOutGirl]

OK I managed to execute the queries successfully... but unfortunately it did not have any effect on the long wait... still about 30.5 seconds. any other ideas?

MySQL Version

5.5.42-cll-lve