On these pages are my WordPress plugins, the odd article and my Support Forum.

For my random rantings on everything else please visit my blog at Yellow Swordfish

WP Plugins


Articles

If you find any of my plugins useful, please comsider a donation towards my running costs.

Thank you

In preparation for the release of Simple:Press Version 4.0, the Support Forum has moved to a new site dedicated to the plugin. This will also be the future home for Simple:Press Forum.


Version 3.1.4 will still be available for download here in the short term.


For the support forum - and to visit our new site and to get details of version 4.0, click on the logo to take you to simplepressforum.com

This forum is currently locked - access is read only
Current User: Guest
Please consider registering

 
Search Forums:


 




Simple Forum Installation Error

UserPost

5:53 am
20 Feb 2007


Joe

Guest

1
I need your help trouble shooting my stalled installation.
 
Here are my versions: 
Wordpress 2.1
Simple Forum 1.6
MySQL 4.1.18-nt
 
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

10:07 am
20 Feb 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5252

2

Wow. I'm impressed with your confidence in changing table types. This might go beyond my own level of knowledge without doing some research but I assume that you now have a database with a mixture of table types. Can MySQL cope with that? I really don't know.

It looks to me like when it originally collapsed with the FULLTEXT error on the sfposts table, it stopped executing the create tables command oin activation. There was still one tabe left to create (sfwaiting).

The best bet is to create that in the same way as you did sfposts and see if that resolves things for you. The sql command for that is:

        CREATE TABLE IF NOT EXISTS ".SFWAITING." (
            topic_id bigint(20) NOT NULL,
            forum_id bigint(20) NOT NULL,
            post_count int(4) NOT NULL default '0',
            PRIMARY KEY topic_id (topic_id)
        );

That should finish the installation of the tables. The problem then is that there are commands AFTER that create that probably have not been executed either so there might still be some problems… But do that first then I can help get the rest done if things are still shaky. The rest will be easy in comparison!

3:43 pm
20 Feb 2007


Joe

Guest

3

Wow, Thank you for such a prompt and complete response.

I used the following SQL command to create the right table.

CREATE TABLE IF NOT EXISTS wp_SFWAITING (topic_id bigint(20) NOT NULL,forum_id bigint(20) NOT NULL,post_count int(4) NOT NULL default '0',PRIMARY KEY topic_id (topic_id) )TYPE=MyISAM;

It seems to have worked.   I'll keep you posted.

Thanks! I really like your forum…. great code and design.

4:36 pm
20 Feb 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5252

4

Hey - good news. I was rather thinking this one might get away from us but it's good to hear it was salvaged oK. Great stuff.

11:52 pm
21 Feb 2007


Joe

Guest

5

I have a question that may or may not be related to my installation.

The forum does not seem to display, unless I am logged into Wordpress.  If I am logged in, it looks awesome, if I am logged out, I get a blank page:

 Here is where it lives:

http://governmentfutures-dev.com/talk/?page_id=43

the slug is sf-forum

Any thougthts?  Thanks for your help, Joe

9:15 am
22 Feb 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5252

6

I don't see that it could be related (I don't think anyway) but it is very curious. Before digging too deeply, could this be as a result of any other plugin you may have installed? I can think of no obvious reason and other plugns often turn out to be the problem.

11:16 am
22 Feb 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5252

7

I dont know why it is but I CAN tell that your header is not recognising that the forum page is being loaded. Are you absolutely sure that the page ID is the correct one? If the header does not recognise the page ID as being the forum page then it will stop the content from loading.

5:23 pm
23 Feb 2007


Joe

Guest

8

I am pleased to report that it is fixed and the page is displaying properly.

The page was not "published" in wordpress. To fix the forum page, I had to simply publish it. That is why it was only appearing in a logged in state.

My mistake, and further confirmation that it is the little things, like missed checkboxes and "publishing" a wordpress page that can be the most baffling to troubleshoot.

I want to thank you for your diligence. You have a great product, and you can ber very proud of your professionalism and committment to helping your benefactors.

Thanks, Joe

5:58 pm
23 Feb 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5252

9

Strange that it was not set to 'publish'. The query that creates the page certainly includes that field and has worked here on tests and elsewhere. All the same, glad you sorted it and that it was something so simple! 



Reply to Topic: Simple Forum Installation Error

NOTE: New Posts are subject to administrator approval before being displayed

Guest Name (Required):

Guest EMail (Required):

Guest URL (required)

Math Required!
What is the sum of: 11 + 11        (Required)

Topic Reply:


 
 

About the Stuff at Yellow Swordfish forum

Currently Online:

phonictony

8 Guests

Maximum Online: 71

Forums:

Groups: 3

Forums: 16

Topics: 2068

Posts: 14091

Members:

There are 1003 members

There are 837 guests


Yellow Swordfish has made 5252 posts

Top Posters:

Mr Papa - 1602

-Radio- - 558

ovizii - 114

jfv - 82

angelic007 - 72

Administrator: Yellow Swordfish | Moderators: Yellow Swordfish, Mr Papa, -Radio-


© Simple:Press Forum - Version 3.1.4 (Build 357)