Jump to content

Script error:MySQL said: Incorrect arguments to AGAINST


arcanine

Recommended Posts

 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?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.