I need your help trouble shooting my stalled installation.
I encountered a FULLText related error when activating the plug in for simpleforum, it threw off this error:
WordPress database error: [The used table type doesn't support FULLTEXT indexes]
CREATE TABLE IF NOT EXISTS wp_sfposts ( post_id bigint(20) NOT NULL auto_increment, post_content text, post_date datetime NOT NULL, topic_id bigint(20) NOT NULL, user_id bigint(20) default NULL, forum_id bigint(20) NOT NULL, guest_name varchar(25) default NULL, guest_email varchar(50) default NULL, post_status int(4) NOT NULL default '0', PRIMARY KEY post_id (post_id), FULLTEXT KEY post_content (post_content) );
I did my research on your pdf (very well written I might add) and googled up the differences between InnoDB MySQL and MyISAM. As it turns out the default on mysql is InnoDB, but all of my wordpress databases are TYPE=MyISAM
So I tried the SET table_type=MYISAM command (executed successfully)
Then adjusted any remaining tables individually using the "Operations" tab and changing the "Table Type" to MyISAM.
I tried unsuccessfully to deactivate and reactivate the plugin getting the same error message as before:
WordPress database error: [The used table type doesn't support FULLTEXT indexes]
CREATE TABLE IF NOT EXISTS wp_sfposts ( post_id bigint(20) NOT NULL auto_increment, post_content text, post_date datetime NOT NULL, topic_id bigint(20) NOT NULL, user_id bigint(20) default NULL, forum_id bigint(20) NOT NULL, guest_name varchar(25) default NULL, guest_email varchar(50) default NULL, post_status int(4) NOT NULL default '0', PRIMARY KEY post_id (post_id), FULLTEXT KEY post_content (post_content) );
So I tried creating the table using the following command:
CREATE TABLE IF NOT EXISTS wp_sfposts ( post_id bigint(20) NOT NULL auto_increment, post_content text, post_date datetime NOT NULL, topic_id bigint(20) NOT NULL, user_id bigint(20) default NULL, forum_id bigint(20) NOT NULL, guest_name varchar(25) default NULL, guest_email varchar(50) default NULL, post_status int(4) NOT NULL default '0', PRIMARY KEY post_id (post_id), FULLTEXT KEY post_content (post_content) )TYPE=MyISAM;
(with the TYPE=MyISAM at the end)
Now the wp_sfposts table exists in my tables list, but is not referenced under my Wordpress database and I get this error: "The additional Features for working with linked Tables have been deactivated. To find out why click here. "
And when I launch my Simple Forum Page, I get this:
WordPress database error: [Table 'wp_govfutures.wp_sfwaiting' doesn't exist]
SELECT topic_id, wp_sfwaiting.forum_id, forum_name, group_id, post_count FROM wp_sfforums LEFT JOIN wp_sfwaiting ON wp_sfforums.forum_id = wp_sfwaiting.forum_id WHERE post_count > 0 ORDER BY forum_id, topic_id
Here is the link to the page: http://governmentfutures-dev.com/talk/index.php?pagename=sf-forum
Please help me with next steps.
Thanks,
Joe