Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Forum Down: DB Corrupted?
Avatar
Joe Bunting
Member
sp_UserOfflineSmall Offline
Mar 14, 2017 - 8:25 am

Anyone dealt with a problem like this before? Getting this error above every page on the site:

Warning: mysql_query(): Unable to save result set in /home/thewrite/public_html/wp-includes/wp-db.php on line 1879
 
Deactivating simple:press clears it, so I'm assuming it's a problem in the forum database. I've gone in and repaired each table but still seeing the error message. 
 
Can I uninstall simple:press and reinstall? Will that lose all the data (have almost 100,000 posts in the forum, so that would be awful)? 
 
Any ideas?
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 14, 2017 - 8:43 am

First off - to be frank - unless you believe there may be an actual code corruption in a file - or you are missing some code files - uninstalling and re-installing is always a complete waste of time.

I am not sure, however, where that message is coming from (it is neither ours or from WordPress) so I have to assume it is from the database code itself.

The most likely thing is that you need to repair and optimise your database. This hardly ever gets a mention but it is good practice to optimise your database on a regular basis - especially if it is big with lots of posts etc. MySQL databases can get 'broken' and regular, simple maintenance can stop this from happening.

So - you can do a test, repair and optimise run from phpMyAdmin if that tool is available in your hosting control panel. But I would recommend you install a WP plugin where you can schedule a regular optimise to be done in the background. It takes but a few seconds to perform.

One I have used in the past is https://wordpress.org/plugins/.....dbmanager/ and is kept up to date.

If - for some reason this is NOT the issue then you will need to look at your servers error log to see iof there is more information available. Maybe even talk to your hosting support.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 618
Members: 17357
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10123
Posts: 79616