Predefined Values problems started with editing the SEX

I am getting a Database error  when I try to refill in the sex of all profiles, since that dropped when I tried to edit the SEX value in the predefined value in Settings. This is the message i get. What should I do to get rid of this error?

And any way to recapture the sex of each profile without having to go back through all each again one by one?

Query:

SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` != 55
AND `` = 'Male' Mysql error: Unknown column '' in 'where clause'

Found error in the file
'/HOME/********/PUBLIC_HTML/INC/MATCH.INC.PHP' at line 57.
Called 'GETALLWITHKEY' function with erroneous argument #0.

Quote · 24 Apr 2012

Sex Predefined Values


Value          LKey             LKey2
male        _Male         _LookinMale
female     _Female     _LookinFemale

 For others: the value for male female should be in all lower case letters. This will restore all values of sex for lost values for all your profiles. AND will not show a DATA BASE error!

solved!

Quote · 24 Apr 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.