Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
coding-topic
flat_1sftrack table crashed
Avatar
Jimmy Thomson
Australia
Member
Free Members
sp_UserOfflineSmall Offline
Apr 19, 2016 - 1:56 am

My Forum has crashed.  I have been getting an "out of Memory" error message but found several variations of the following in the log:

19/04/2016 3:00 pm | spaErrError | 5 | database


file: /home/flatchat/public_html/wp-content/plugins/simple-press/forum/content/sp-common-view-functions.php
line: 3044
function: spdb_count
error: Table './flatchat_flatchat/flat_1sftrack' is marked as crashed and should be repaired

SELECT COUNT(*) FROM flat_1sftrack

 

How do I repair it?

Avatar
Jimmy Thomson
Australia
Member
Free Members
sp_UserOfflineSmall Offline
Apr 19, 2016 - 2:10 am

As you were.

Corrupted database at the Host which has now been repaired.

Reloading my plugins with crossed fingers

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Apr 19, 2016 - 2:12 am

You need to do what the message says and repair the table. You could probably do with a check and optimisation across the database as when it starts to fail like this it might well need a clean up. Sadly - so many people do not do this...

Your hosting probably bundles the phpMyAdmin application which will allow you to repair and optimise.

But there are also some WP plugins available that will not only do this for you but will also allow you to set up scheduled checks and optimisations in the background. Well worth doing for the health and performance of your database.

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: 616
Members: 17344
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10117
Posts: 79600