Support Forum
Support Forum
Offline
All of a sudden today I get "Invalid database query" every single time I load or post..... on the forum.
I haven't made any changes. What should I do? Is this a Simple:Press thing or a server problem?
Thanks
"The richest person is not the one who has the most, but the one who needs the least."
Learn to Play Violin for Free - http://www.fiddlerman.com
Offline
It is probably coming from SP.
You can go to the Forum admin > Tool Box > Error log and look for something that says there is a database error.
Copy and paste the latest one here and someone can help from there.
Custom Simple Press Themes
Offline
Also if you updated Simple:Press to the latest version but see some SP Plugins that need to be updated then update them and see if the issue is resolved.
Offline
| December 8, 2014 1:33 pm | spaErrError | 133 | database
file: /problem-with-post-edit-buttonome/fiddlerm/public_html/wp-content/plugins/simple-press/forum/content/sp-template-control.php line: 323 function: sp_add_cache error: Incorrect key file for table './fiddlerm_data/wp_sfcache.MYI'; try to repair it REPLACE INTO wp_sfcache(cache_id, cache_out, cache) VALUES ('207.46.13.9*topic', 1418004952, 's:4:"3991";') |
| December 8, 2014 1:41 pm | spaErrError | 8127 | database
file: /problem-with-post-edit-buttonome/fiddlerm/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-framework.php line: 426 function: sp_clean_cache error: Incorrect key file for table './fiddlerm_data/wp_sfcache.MYI'; try to repair it DELETE FROM wp_sfcache WHERE cache_out < 1418003862 |
"The richest person is not the one who has the most, but the one who needs the least."
Learn to Play Violin for Free - http://www.fiddlerman.com
Offline
All my plugins are updated and I'm using the latest version of SP.
Thanks
"The richest person is not the one who has the most, but the one who needs the least."
Learn to Play Violin for Free - http://www.fiddlerman.com
Offline
I think the 'Incorrect key file for table' error normally comes down to a space issue, and they both reference cache so it could be that temporary files are taking up a lot of room.
Do you maintain the database? i.e cleanup?
Also, have you tried a repair at all as suggested in the first error?
Offline
I agree that the repair is most probably the important bit of info in there. Looks likely that you have a corruopt table.
Do you have a regime of table and database optimisation in place? If not then I would do so as yours, I believe, is quite a busy site and would benefit from at least weekly optimisation. It will also help tables from becoming fragmented and eventually corrupted which is probably the case here.
If your host can not help then I would use a plugin like - WP db Manager - I believe it is called - that will carry our repairs and checks on demand but also allow you to schedule regular optimisations.
 |
YELLOW
SWORDFISH
|
Offline
Done and it worked. Thanks guys. Best support ever. 
"The richest person is not the one who has the most, but the one who needs the least."
Learn to Play Violin for Free - http://www.fiddlerman.com
Offline
Great news. Worth noting that an un-optimised database that starts to fragment can also be a drag in performance as it has to work harder to compile query results. Just another good reason for regular optimisation.
|
YELLOW
SWORDFISH
|
All RSS1 Guest(s)