magento中的高级搜索错误
我在 magento 中进行高级搜索时遇到问题。我收到以下错误。
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `s`.`store_id`='1') ON DUPLICATE KEY UPDATE `relevance`=VALUES(`relevance`' at line 1
我只是执行
PLease 指南
I am facing problem while doing advance search in magento. I am getting following error.
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `s`.`store_id`='1') ON DUPLICATE KEY UPDATE `relevance`=VALUES(`relevance`' at line 1
I am simply executing <URL>/catalogsearch/advanced/result/?category=7
PLease guide
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我在 Magento EE 1.10.0.1 中看到同样的错误
解决方案是在管理中更改，然后在目录中将搜索选项更改为Mysql Fulltext，而不是像全文一样，然后错误就消失了。
I see the same error in Magento EE 1.10.0.1
The solution was to change in the admin, then catalog, the search options to Mysql Fulltext, and instead of like, also fulltext, then the error disappears.
谢谢..但我通过另一种方式解决了错误。对于我的情况，我需要在侧栏中显示 FILTER 框，但 Magento 不支持它，所以我评论了该块，它对我有用。
Thanks.. But i resolve the error by another way. For my case , I needed to show FILTER box in side bar, but its not supported in Magento so I commented that block and it worked for me.