arcanine Posted January 31, 2010 Share Posted January 31, 2010 Script error:MySQL said: Incorrect arguments to AGAINST with query: SELECT *, GROUP_CONCAT(`Key`,':',`Value` SEPARATOR ',') AS Tags FROM `gettomypc_groups` g LEFT OUTER JOIN ( SELECT * FROM `gettomypc_group_membership_users` WHERE IsDesignatedContact ) ug USING(`GID`) LEFT OUTER JOIN `gettomypc_users` u USING (`UID`) RIGHT JOIN `gettomypc_group_tags` gt USING (`GID`) RIGHT JOIN `gettomypc_tags` t USING (`TID`) RIGHT JOIN `gettomypc_tag_keys` tk USING (`KID`) GROUP BY `GID` HAVING MATCH (g.Name,Tags,g.SalesNotes,g.ContactInfo,u.FirstName,u.Surname,u.Organisation,u.Address1,u.Address2,u.Address3,u.Postcode,u.Telephone,u.Email,u.MobilePhone) AGAINST ('Abbey Medical Group' IN BOOLEAN MODE) ORDER BY `Name` ASC Has anyone got any ideas on this one? Is there anything wrong in the syntax that's obvious? Quote Link to comment https://forums.phpfreaks.com/topic/190480-script-errormysql-said-incorrect-arguments-to-against/ Share on other sites More sharing options...
fenway Posted February 1, 2010 Share Posted February 1, 2010 What mysql version? Quote Link to comment https://forums.phpfreaks.com/topic/190480-script-errormysql-said-incorrect-arguments-to-against/#findComment-1004825 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.