I get the following this error when matchmaking is turned on when the join form is processed in Dolphin 7.
The
user is created successfully but there is a database error message when
the user has filled in the form and clicks "Join Now"
Email Message contents:
Subject: Database error in <SiteName>
Database error in
Query:
SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` != 12 AND `` = 'female'
Mysql error: Unknown column '' in 'where clause'
Found error in the file '/var/www/vhosts/xxx.com/xxxxx/cms8/inc/match.inc.php' at line 57.
Called 'getAllWithKey' function with erroneous argument #0.
It seems to me that the unknown column should be "sex" but I don't understand why this is happening. When matchmaking is turned off the error disapears.
Any pointers are appreciated. Thanks.