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下均存在问题。请版主检查
