查看完整版本: 5.4整站系统高级查询出错

5.4整站系统高级查询出错

5.4整站系统高级查询出错，错误提示如下：

You have an error in your SQL syntax; check the manual that correspondsto your MySQL server version for the right syntax to use near \'INNERJOIN #__categories AS b ON b.id=a.catid\n LEFT JOIN #__menu m ON m.link= \'\' at line 7 SQL=SELECT a.title AS title,\n CONCAT(a.introtext,a.fulltext) AS text,\n CONCAT_WS( \'/\', b.title ) AS section,\nCONCAT( \'index.php?option=com_easyfaq&task=view&id=\', a.id,\'&Itemid=\', m.id ) AS href,\n \'2\' AS browsernav\n FROM#__easyfaq AS a\n INNER JOIN #__categories AS b ON b.id=a.catid\n LEFTJOIN #__menu m ON m.link = \'index.php?option=com_easyfaq\' ANDm.published = 1\n WHERE ( (LOWER(a.title) LIKE \'%长%\' ORLOWER(a.introtext) LIKE \'%长%\' OR LOWER(a.fulltext) LIKE \'%长%\') )\nAND b.published = 1\n AND b.access <= mos_\n GROUP BY a.id\n ORDERBY a.title ASC

在mysql4.0,5.0下均存在问题。请版主检查

新安装曼波5.4.0的高级搜索并没发现问题

你这里面有 com_easyfaq, 会不会是它的搜索触发器有问题？