I recently uninstalled the previous version of uieforum (for drupal 5) and installed the one dated 4/5/07 and I got this MySQL error:

user warning: The used table type doesn't support FULLTEXT indexes query: CREATE TABLE F_Posts ( PostID int(12) NOT NULL auto_increment, PostTitle varchar(255) default NULL, ThreadID int(8) NOT NULL default '0', Poster int(8) NOT NULL default '0', Posted datetime NOT NULL default '0000-00-00 00:00:00', Content text NOT NULL, Edit datetime default NULL, Editor int(8) default NULL, EditReason varchar(255) default NULL, PRIMARY KEY (PostID), KEY ThreadID (ThreadID), KEY Poster (Poster), KEY Posted (Posted), FULLTEXT KEY SearchFields (PostTitle,Content) ) /*!40100 DEFAULT CHARACTER SET UTF8 */;

Comments

mscdex’s picture

Status: Active » Closed (fixed)

Problem fixed by switching the default MySQL engine to MyISAM in my.ini and manually executing the SQL statement for f_posts from uieforum.install.

Haggle’s picture

For us non tech savy people could you be a bit more descriptive? Whats my.ini and what would be the proper format to execute the script manually?

daniel.hunt’s picture

Assigned: Unassigned » daniel.hunt
Status: Closed (fixed) » Fixed

I've added this to the install file, so you don't need to worry about it.

Daniel

Anonymous’s picture

Status: Fixed » Closed (fixed)