search

boonex / dolphin.pro

Dolphin.Pro - Social Network Platform
http://www.boonex.com
MIT License
147 stars 138 forks source link

SQL error when searching for profiles from mobile apps #605

Closed AlexTr closed 6 years ago

AlexTr commented 6 years ago

Query: 

            SELECT * ,  MATCH (`NickName`, `City`, `DescriptionMe`, `Tags`) AGAINST ('simone')  FROM `Profiles`
            WHERE `Status` = 'Active' AND (`Profiles`.`Couple` = 0 OR `Profiles`.`Couple` > `Profiles`.`ID`)   AND  MATCH (`NickName`, `City`, `DescriptionMe`, `Tags`) AGAINST ('simone')   
            ORDER BY `DateLastNav` DESC
            LIMIT 0, 5

Mysql error: Can't find FULLTEXT index matching the column list

Found error in the file /.../xmlrpc/BxDolXMLRPCSearch.php at line 133.