Question #249253 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/249253
Description changed to:
Please help! This problem only happens recently, since I upgraded to
MySQL 5.6 and convert the database tables to InnoDB.
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT searchcore.searchgroupid,
MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('g@mes') AS
score
FROM searchcore AS searchcore
JOIN searchcore_text AS searchcore_text ON
(searchcore_text.searchcoreid = searchcore.searchcoreid)
WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST
('g@mes' IN BOOLEAN MODE);
MySQL Error : syntax error, unexpected '@', expecting $end
Error Number : 1064
MySQL version: mysql56u-5.6.17-3.centos6.x86_64
--
You received this question notification because you are a member of IUS
Core Development, which is an answer contact for IUS Community Project.
_______________________________________________
Mailing list: https://launchpad.net/~ius-coredev
Post to : [email protected]
Unsubscribe : https://launchpad.net/~ius-coredev
More help : https://help.launchpad.net/ListHelp
