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
Database error after theme update
Avatar
Massimo Interlandi
Member
Free Members
sp_UserOfflineSmall Offline
Jun 21, 2014 - 8:36 am

Here is the error:

21 giugno 2014 14:24 | spaErrError | 32767 | database


file: /problem-with-post-edit-buttonome/cuffie5/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-support-functions.php

line: 130

function: sp_track_online

error: Table './cuffie5_cuffie2/wp_sftrack' is marked as crashed and should be repaired

INSERT INTO wp_sftrack (trackuserid, trackname, forum_id, topic_id, trackdate, pageview, device, display) VALUES (444, 'shanaish8', 3, 297, '2014-05-22 21:38:11', 'topic', 'D', 'spType-User spRank-membro spUsergroup-membri spUsergroup-audiofilo-100')

Anything I should do about it?

Thanks for your time

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 21, 2014 - 8:53 am

Yes indeed. You should do exactly what the error message tells you to do.

If you have access to phpMyAdmin via your hosting control panel you will need to open the database - mark the table using the checkbox down the side  and the from the options at the bottom choose 'repair'. You shouyld check thje rest of the database as well and optimise it.

This has nothing to do with any updates. This is probably caused by an unoptimised database getting badly fragmented. Or possibly a system crash at some critical moment causing the table to become corrupted.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Massimo Interlandi
Member
Free Members
sp_UserOfflineSmall Offline
Jun 21, 2014 - 12:54 pm

Ok, so when I see lines where its said SELECT... FROM, JOIN, ORDER BY, am I supposed to go and follow those instructions all the way on my database?

I attached a screen print of some error so you can tell me what should I do. I'm not a programmer and I dont know PHP or database lanuage, but I will follow every step you will indicate me to ficks those problems if you believe they need urgent ficks.

Thanks again

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 21, 2014 - 5:22 pm

Sorry - instructions are in the error message. Here:

Table './cuffie5_cuffie2/wp_sftrack' is marked as crashed and should be repaired

and on my post above I was trying to describe how you do it. It is not php and it is not SQL. A table has crashed/corrupted and needs to be repaired. This is neither a WordPress or a Simple:Press issue as such as it can happen any time. I would suggest uyou read up on database optimisation as, while the WP guys never tell you, it really should be done regularly. There are some database manager plugins available that will do it all for you. I think 'WP Database Manager' for example.

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: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625