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
Comment #1
mscdex commentedProblem fixed by switching the default MySQL engine to MyISAM in my.ini and manually executing the SQL statement for f_posts from uieforum.install.
Comment #2
Haggle commentedFor 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?
Comment #3
daniel.hunt commentedI've added this to the install file, so you don't need to worry about it.
Daniel
Comment #4
(not verified) commented