仅在某些查询中出现 MySQL 全文搜索错误

Question

当我在我的 MySQL 5.6 MyISAM 表中使用全文搜索时，我有时会遇到错误，但大多数时候它工作正常。

这个查询工作正常

SELECT title, MATCH(title, keywords, description) AGAINST ('background+water+sea') AS 'relevance' FROM `content` WHERE 
MATCH(title, keywords, description) AGAINST ('background+water+sea');

但是这个没有

SELECT title, MATCH(title, keywords, description) AGAINST ('background+water+sea+blue') AS 'relevance' FROM `content` WHERE 
MATCH(title, keywords, description) AGAINST ('background+water+sea+blue');

它们基本相同，只是第二个也要求“蓝色”。表中有超过 100,000 行。如果在网站上运行，它会在 phpMyAdmin 中显示“#2014 - 命令不同步；您现在无法运行此命令”和“存储引擎出现错误 -1”。

有什么想法吗？

Answer 1

来自 MySQL 5.6 manual :

If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order.

This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you have called mysql_free_result(). It can also happen if you try to execute two queries that return data without calling mysql_use_result() or mysql_store_result() in between.

如果您一次执行两个或多个语句，PHPMyAdmin 有时会出现此错误。检查the question有类似的问题。

不幸的是，这就是我在不知道调用所有这些的代码的情况下所能提出的所有建议。如果还不能解决问题，您可以分享更多细节