CiviCRM Community Forums (archive)

Created custom profile and I get this error when trying to preview it.

    Sorry. A non-recoverable error has occurred.

    DB Error: syntax error

    Database Error Code: 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, 1064

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -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            = 'addressee'
  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
    [user_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            = 'addressee'
  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]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" 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            = 'addressee'
  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