Sorry I meant all the groups have been deleted.

we will need more info…  the upgrade cannot delete groups, there is no facility for doing so… 

perhaps  your db glitched during the update or the site had an issue?

what do you mean deleted your groups??  have you looked in the db to see if data is still there?  there is only 1 database, the one wp is in… there is no other db that the forum accesses or could access…

or are you just saying your forum is not accessible because of a pending update?

please explain the issue further so we can help…

A message “invalid database query” popped up. I checked the database and everything is there. But I think all the data is missing out of the tables. I am checking my backups now but I am not sure if I have backups that far :S My hosting company backs up for only 3 days and this issue is 2 weeks old. What a mess :/ 

I am not sure if you viewed my site but it still shows data for guest posters stats.

Yes I did,

Can you describe exactly what you did in detail? And from which version you are upgrading from?

I will have to look at my history in Chrome browser to see if I can find which version I upgraded from. I just installed the latest version from your site which cleared the update notice that would not go away even after I successfully updates via wordpress. Here are the steps I take when I update anything on wordpress.

First I find the plugin that has an update. I open a duplicate tab to deactivate the plugin. I then go back to the first tab and hit the automatic update link. I always get a successful update, even this time.

Right after I updated the plugin it asked me if I wanted to update to the version I just updated to and was currently on. This notice would not go away then soon after I found all my groups were missing. BTW I did check the database and everything is there. So this morning I figured I would install the fresh copy from your site and not wordpress. So I copies the plugin folder via ftp and went through a new second window to update simple:press again via the simple:press plugin GUI. Well this fixed the issue with the update window bug in wordpress. Now I am on the latest version you have on your site. 

well,  I am glad you are back working… still a bit unsure of what the sequence was there and what went south… sounds like the new version was not being detected despite the upgrade having occurred… odd…

Yes I figured this would be a good one for you guys My last known good configuration was from an update on July 15th so that should help us find the version from which I upgraded from.

Also one table crashed. #1194 – Table ‘wp_sfmembers’ is marked as crashed and should be repaired 

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.

yes, repair it…

that lends credence to an earlier hypothesis of mine that mysql crapped out during the upgrade…

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.

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.

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