CiviCRM Community Forums (archive)

I'm using the latest Drupal 5.x version, and the 2.02 version of CiviCRM

Most things seem to work, but when I go to add a new role, it fails with a message about a database error. Specifically from the log, it looks like:
Apr 18 15:55:44  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

 => -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 = 8 [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 = 8' at line 1]
    [type] => DB_Error
    [user_info] => SELECT MAX(CONVERT(value, DECIMAL)) AS max_weight FROM civicrm_option_value WHERE option_group_id = 8 [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 = 8' 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 = 8 [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 = 8' at line 1]"]
I'm not sure where to find this particular statement, nor exactly whats wrong with it. I'm using php5, and mysql version 4.1.22-standard. I'm not using the mysqli protocol, but I could if needed.

Any clues as to what the error means and how to correct it?

Thanks

Ok. The MySQL version is the likely culprit. Since the host doesn't run that yet, I won't be able to use it.

I finally found the requirements, but it would have been helpful if they had be included in the readme file.

Thanks for the reply. I won't have to spend more time looking for a solution. I'll look at vtiger and SugarCRM for an online solution. They aren't as demanding about the MySQL version. Maybe I can run CiviCRM on my WAMP stack locally, but it diminishes its effectiveness to do that.