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

Support Forum : Something wrong with DB

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:


 




Home Forums Simple Forum Version 2.1 Something wrong with DB

Something wrong with DB
Page: 1
UserPost

6:37 pm
11 Feb 2007


revebi

Guest

1

I've the foloowing message

 " 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) );

Problem creating wp_sfposts table".


What's wrong ?  Thanks 

8:33 pm
11 Feb 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5252
2

It either means the MySQL version your host is using is ancient - which is a possibility - or - they will not let you create a FULLTEXT index - or, and I think  I am correct here - your MySQL tables have been set up with InnoDB type instead of MyISAM type, which is most unusual for a WP installation. Either way it will be the way your host has things set up.

The forum uses the FULLTEXT index for searching so this means you could use it but without that facility. And yould need to modify the table creation  code (which I can help you with) if you wanted to go ahead anyway.

5:02 pm
15 Feb 2007


revebi

Guest

3

Hello,

 Sorry for the delay ! I'm with mysql 5 in InnoDB. Ok for special Tables whitout the

Fulltext ! Thanks for the help. 

5:39 pm
15 Feb 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5252
4

I'll email it to you
Page: 1


Reply to Topic: Something wrong with DB

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: 6 + 12        (Required)

Topic Reply:


 
 

About the Stuff at Yellow Swordfish forum

Currently Online:

12 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)