双11后迁移数据库,网站访问正常,编辑发布文章也正常,就是搜索功能页面白屏。
百思不得其解,debug发现有个索引表eps_search_index,查询sql类似如下:
SELECT
*,
((1 * (MATCH(title) AGAINST('" create"' IN BOOLEAN MODE))) + (0.6 * (MATCH(title) AGAINST('" create"' IN BOOLEAN MODE))) ) AS score
FROM eps_search_index
WHERE MATCH(title,content)AGAINST('+" create"'IN BOOLEAN MODE) >= 1
AND STATUS = 'normal'
ORDER BY score DESC, editedDate desc
解决办法:给title和content两个字段分别创建全文索引即可。