CiviCRM Community Forums (archive)

Folks, I need to add new Option Values. After clicking on "New Option Value" link I get the following in CiviCRM 3.2.3. What's the workaround?


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 '' at line 1, 1064
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => SELECT max( `weight` ) as weight FROM `civicrm_option_value` where option_group_id= [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 '' at line 1]
    [type] => DB_Error
    [user_info] => SELECT max( `weight` ) as weight FROM `civicrm_option_value` where option_group_id= [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 '' at line 1]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT max( `weight` ) as weight FROM `civicrm_option_value` where option_group_id= [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 '' at line 1]"]
)

The query error indicates that you're trying to add an option_value row w/o specifying the option_group it belongs to. Please describe the steps you are taking (menu item / url's) to get this error. Option value records are used in many different places.

I somehow got into the "New Option" page, from somewhere. I couldn't find it from under the Administrator menu.

Luckily I copied the URL and I just paste it into the web browser and in I go. Here is the link :

http://server.com/index.php?q=civicrm/admin/optionValue&reset=1&action=browse

That isn't a valid URL - what exactly are you trying to do? What functionality are you trying to add an option value for? There should be valid menu-based links for most purposes (under Administer > Option Lists, or under Administer > Customize > Custom Data (drill down to Custom Fields / Multiple Choice Options).

Thanks Dave for the pointer! I got it working now.