Jump to content

Upgrade failure: No FULL TEXT for MyISAM


Shehi

Recommended Posts

Posted

mt_id int(10) NOT NULL auto_increment, mt_date int(10) NOT NULL default '0', mt_title varchar(255) NOT NULL default '', mt_hasattach smallint(5) NOT NULL default '0', mt_starter_id int(10) NOT NULL default '0', mt_start_time int(10) NOT NULL default '0', mt_last_post_time int(10) NOT NULL default '0', mt_invited_members text, mt_to_count int(3) NOT NULL default '0', mt_to_member_id int(10) NOT NULL default '0', mt_replies int(10) NOT NULL default '0', mt_last_msg_id int(10) NOT NULL default '0', mt_first_msg_id int(10) NOT NULL default '0', mt_is_draft int(1) NOT NULL default '0', mt_is_deleted int(1) NOT NULL default '0', mt_is_system int(1) NOT NULL default '0', PRIMARY KEY (mt_id), KEY mt_starter_id (mt_starter_id), FULLTEXT KEY mt_title (mt_title) ) TYPE=INNODB; The used table type doesn't support FULLTEXT indexes Error: CREATE TABLE ibf_message_posts ( msg_id int(10) NOT NULL auto_increment, msg_topic_id int(10) NOT NULL default '0', msg_date int(10) default NULL, msg_post text, msg_post_key varchar(32) NOT NULL default '0', msg_author_id mediumint(8) NOT NULL default '0', msg_ip_address varchar(16) NOT NULL default '0', msg_is_first_post int(1) NOT NULL default '0', PRIMARY KEY (msg_id), KEY msg_topic_id (msg_topic_id), KEY msg_date (msg_date), FULLTEXT KEY msg_post (msg_post) ) TYPE=INNODB; The used table type doesn't support FULLTEXT indexes Error: CREATE TABLE ibf_search_index ( app varchar(255) NOT NULL, content text NOT NULL, content_title varchar(255) NOT NULL, `type` varchar(32) NOT NULL, type_id bigint(10) unsigned NOT NULL, type_2 varchar(32) NOT NULL, type_id_2 bigint(10) unsigned NOT NULL, updated int(10) unsigned NOT NULL, misc text NOT NULL, member_id mediumint(8) unsigned NOT NULL, KEY app (app), FULLTEXT KEY content (content,content_title) ) TYPE=INNODB; The used table type doesn't support FULLTEXT indexes

Error: CREATE TABLE ibf_message_topics (


























































Posted

Oops, wrong alarm :) Forgot to update $INFO['mysql_tbl_type'] variable in my conf file. Please ignore the topic.

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...