ius-coredev team mailing list archive

Thread
Date

[Question #249253]: MySQL Error 1064 syntax error, unexpected '@', expecting $end

To: ius-coredev@xxxxxxxxxxxxxxxxxxx
From: HUYNH NGUYEN <question249253@xxxxxxxxxxxxxxxxxxxxx>
Date: Sun, 25 May 2014 09:11:50 -0000
Reply-to: question249253@xxxxxxxxxxxxxxxxxxxxx
Sender: bounces@xxxxxxxxxxxxx

New question #249253 on IUS Community Project:
https://answers.launchpad.net/ius/+question/249253

Please help! This problem only happens recently, since I upgrade 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.