Support Forum
Support Forum
Offline
That will be the root of all the problems. The sfmembers table is joined with all the main views so if it had crashed and thus unavailable it would return no data to the queries making the forum appear empty.
The most common reason for tables to crash is because the overhead has just built up and has become to much. The key is to keep the database optimised as often as possible. I would recommend weekly optimisation runs at the very least.
 |
YELLOW
SWORDFISH
|
Offline
yes, repair it...
that lends credence to an earlier hypothesis of mine that mysql crapped out during the upgrade...
Visit Cruise Talk Central and Mr Papa's World
Offline
Alright now here is something a little more strange. Everything is back kinda. The only problem now is that when you click on a topic it goes to the next screen and says topic not found.
Offline
I am going to go ahead and repair the table now to see if everything will go back to normal. I will let you know what happens.
Offline
Before I repaired the database I checked the error log and found this:
file: /services2/webpages/d/o/doggroominginhouston.com/public/wp-content/plugins/simple-press/forum/content/classes/sp-forum-view-class.php
line: 305
function: select
error: Unknown column 'keywords' in 'field list'
SELECT wp_sftopics.forum_id, forum_slug, forum_name, forum_status, group_id, topic_count, forum_icon, topic_icon, topic_icon_new, forum_desc, forum_rss, forum_rss_private, parent, children, forum_message, keywords, wp_sftopics.topic_id, topic_slug, topic_name, topic_status, topic_pinned, topic_opened, wp_sftopics.post_id, wp_sftopics.post_count, post_ratings, use_tags, topic_desc, topic_watches FROM wp_sftopics JOIN wp_sfforums ON wp_sftopics.forum_id = wp_sfforums.forum_id WHERE wp_sfforums.forum_id=1 AND wp_sftopics.post_count_held > 0 ORDER BY topic_pinned DESC, wp_sftopics.post_id_held DESC LIMIT 0, 12
I repaired my table successfully also. hmmm
Offline
so look in your db... the sfforums table... is there a keywords column? there should be as it was added some time ago...
if not, you will need to manually enter it... see the wp-content/sp-startup/install/sp-install.php for the structure of the column... if you cant find it, let us know and we can post it here...
not sure how you would have missed that update though...
Visit Cruise Talk Central and Mr Papa's World
Offline
yes, you need to add that column with those characteristics to your sfforums table...
hopefully there are not any other db schema updates missing from upgrades...
out of curiosity, is this *nix or IIS? and what version of mysql?
Visit Cruise Talk Central and Mr Papa's World
Offline
Now I get another error
error: Unknown column 'post_ratings' in 'field list'
I am not sure what version is on the server or what server setup they have but I can contact them tomorrow to get that info. I am with a really old hosting company that has very low time to first byte but they also have the oldest GUI. They do seem to keep up with all the updates. I would like to move to a new host but have very bad luck every time I try a new hosting company.
All RSS1 Guest(s)