Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 3.1
-
Fix Version/s: 3.1
-
Component/s: CiviCRM Profile
-
Labels:None
Description
If we include any of contact greeting (email, postal, addressee) field in a mixed profile and if we use this profile in Event/ Contribution page, it fails and displays following db error
[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] =>
SELECT v.label as label ,v.value as value, v.grouping as grouping
FROM civicrm_option_value v,
civicrm_option_group g
WHERE v.option_group_id = g.id
AND g.name = 'email_greeting'
AND v.is_active = 1
AND g.is_active = 1 AND (v.filter = 0 OR v.filter =) ORDER BY v.weight [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY v.weight' at line 7]
[type] => DB_Error
Steps to replicate:
1. Create a profile and include a field which is one of for Contribution/ Participant.
2. Include any contact greeting field in it so that it will become a mixed profile.
3. Now if we use this profile in Contribution/ Event page, we get above db error.
Same problem for profile preview.