All forums are back and I rebuilt all indexes for each forum. I then click on the forum and it states “invalad database query”. At least all the forums are back. I have not looked at the error codes yet but I am going to leave it alone for now until you get back.
That will probably be because you still have columns missing from the updates. So – check the error log. Clean it out first and then run the forum and see what you get reported.
I figured it was that keywords column missing again.
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, forum_disabled, 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
in case you dont have it, the schema for the keywords:
keywords varchar(256) default NULL,
Well last time I did but I am not an SQL expert. If I give you the field that I need to fill in can you tell me what should go in those fields?
sorry, Andy out for dinner and I am away from computer replying by email… so I can’t see images or html… but the table would be sfforums… set:
name – keywords type – varchar(256) default – null
you should also set the collation to whatever the other tables/columns are in your db…
Fixed that one but I am missing more field :/ My girl wants to watch a movie with me because this is taking too much time away from her. 
I will be back in a couple hours.
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 ‘use_tags’ 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, forum_disabled, 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
what are you waiting for? get to the movie! 
we can just take these one at at time as they come up…
same table, sfforums…
name – use_tags type – smallint(1) null – NOT NULL default – 1
Sounds like a plan Stan errr I mean Mr. Papa Here is the next error posted below. BTW you have to watch a movie called “Coriolanus”. It is made just as well if not better than all time #1 “Shawshank Redemption”.
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 ‘topic_desc’ 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, forum_disabled, 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
Geoffrey WIlson said
to watch a movie called “Coriolanus”. It is made just as well if not better than all time #1 “Shawshank Redemption”.
Are you talking about this movie?
http://youtu.be/Di-XOO_LTlw
It looks pretty awesome.
sheesh… did we ever ask you to check with your host and see if your mysql user has ‘alter table’ permission? it seems to not be able to run upgrade scripts where the tables get altered… actually, you might be able to see your user permissions from phpmyadmin…
anyways…
table – sftopics
name – topic_desc
type – text
default – NULL
and these last two have all been from plugins… so I assume you are actually using the tags and topic description plugin….