CiviCRM Community Forums (archive)

When trying to add an activity or event type, I get the following error message:

(I'll also mention here that "preview" on this forum doesn't work - not on Safari, anyway... so I hope this post looks OK!)

Event Type Options

Sorry. A non-recoverable error has occurred.
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 'DECIMAL)) AS max_weight FROM civicrm_option_value WHERE option_group_id = 14' at line 1, 1064
Return to home page.
Error Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => SELECT MAX(CONVERT(value, DECIMAL)) AS max_weight FROM civicrm_option_value WHERE option_group_id = 14 [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 'DECIMAL)) AS max_weight FROM civicrm_option_value WHERE option_group_id = 14' at line 1]
    [type] => DB_Error
    [user_info] => SELECT MAX(CONVERT(value, DECIMAL)) AS max_weight FROM civicrm_option_value WHERE option_group_id = 14 [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 'DECIMAL)) AS max_weight FROM civicrm_option_value WHERE option_group_id = 14' 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(CONVERT(value, DECIMAL)) AS max_weight FROM civicrm_option_value WHERE option_group_id = 14 [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 'DECIMAL)) AS max_weight FROM civicrm_option_value WHERE option_group_id = 14' at line 1]"]
)
Trying to get this site into production - I have to say it's looking pretty scary at this point. Whoever takes a look at this, thanks very much in advance for your help![/code]

Guilty... as charged. Hosting company is running 4.1.20. They're doing the upgrade right now - I'll let you know and thanks a million!