现在的位置: 首页 > 综合 > 正文

sql 全文检索功能

2012年12月11日 ⁄ 综合 ⁄ 共 532字 ⁄ 字号 评论关闭

WordPress database error: [The used table type doesn't support FULLTEXT indexes]
SELECT ID, post_title, post_content,MATCH (post_name, post_content) AGAINST ('mysql doesnt support fulltext indexes error solving') AS score FROM wp_posts WHERE MATCH (post_name, post_content) AGAINST ('mysql doesnt support fulltext indexes error solving') AND post_date <= '2007-11-17 06:41:45' AND (post_status IN ( 'publish', 'static' )) AND post_password = '' ORDER BY score DESC LIMIT 5

大意就是不支持全文索引,解决方案也挺简单的,打开my.ini
搜索

default-storage-engine=

你搜索到的应该是

default-storage-engine=INNODB

INNODB改成MyISAM重新启动Mysql吧,Done

抱歉!评论已关闭.