DATABASE QUERY ERROR + Predefined data + Match

DATABASE QUERY ERROR occur when the situation below is used.

 

1- Fields Builder->Profile Fields: Create a profile item with a PREDEFINED list associated to is "Possible values" with type selector option.

and in the MATCH tab, match it to a field and add a value for the match.

2- Activate that field

3- Now, if you EDIT your profile and change de value of that field, it will create "DATABASE QUERY ERROR" and if you refresh the data will be save.

It only does that with predefined data list and MATCH option attributed to it. If match option of NOT SET and 0, no error occur.

A error occur also if you try to SEARCH MATCH: search.php?show=match

 

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

Found error in the file 'public_html/inc/match.inc.php' at line 57.
Called 'getAllWithKey' function with erroneous argument #0.

 

Something to do with that line:

$aMathFields[$sKey]['profiles'] = $oDb->getAllWithKey("SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` != $iProfileId AND $sCond", 'ID');

 

Quote · 15 Oct 2010

Hello

Match system requires setting of 2 fields as matching. So if u made field1 as matching with field2 then u should change settings of field2 too. Plz send me admin access to ur site via Unity mail and inform what fields should be set as match if ur new attempt will not success.

Regards

Quote · 18 Oct 2010

Hello ticket was added: http://www.boonex.com/trac/dolphin/ticket/2238

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 19 Oct 2010

trouble was fixed : http://www.boonex.com/trac/dolphin/changeset/14539

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 20 Oct 2010
 
 
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.