Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Ask? official ER-Diagram of myBB-DB
#11
(05-02-2012, 02:46 PM)serizawaki Wrote: when i tried to convert mybb_post into innoDB, an error accured.
it said #1214 - The used table type doesn't support FULLTEXT indexes ...

what should I do?
I converted mybb_posts to InnoDB
mysql> show create table mybb_posts;
........................
| mybb_posts | CREATE TABLE `mybb_posts` (
........................
  PRIMARY KEY (`pid`),
  KEY `tid` (`tid`,`uid`),
  KEY `uid` (`uid`),
  KEY `visible` (`visible`),
  KEY `dateline` (`dateline`),
  KEY `longipaddress` (`longipaddress`),
  FULLTEXT KEY `message` (`message`)
) ENGINE=MyISAM AUTO_INCREMENT=5477 DEFAULT CHARSET=utf8 |
1 row in set (0.00 sec)
Next step
mysql> alter table mybb_posts drop index message;
Query OK, 5427 rows affected (0.16 sec)
Records: 5427  Duplicates: 0  Warnings: 0
When I try to open any topic, I see that:
[Image: 996fd28276166ec59696e4ee57a29c4e.jpg]


Forum Jump:


Users browsing this thread: 1 Guest(s)