CiviCRM Community Forums (archive)

Can anyone help, or guide me in debugging please?

I need to add the prefix 'Miss' 

When I attempt to do so I get the following error -


Home › Administer CiviCRM
Individual Prefix Options

unrecoverable error
    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 = 35' at line 1, 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 MAX(CONVERT(value, DECIMAL)) AS max_weight FROM civicrm_option_value WHERE option_group_id = 35 [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 = 35' at line 1]
    [type] => DB_Error
    [user_info] => SELECT MAX(CONVERT(value, DECIMAL)) AS max_weight FROM civicrm_option_value WHERE option_group_id = 35 [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 = 35' 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 = 35 [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 = 35' at line 1]"]
)


Hi,

i'm also having this exact same problem, i'm using mySQL 4.1.20 and civiCRM 2.0.4 Drupal PHP5.
is there any fix out or is it a case of inserting new preffixes manually via the database?

thanks in advance
Tom

Thanks for your reply and I'm sorry that I missed it earlier 

It is a MySQL version problem - the host is running a 4. something and I'm stuck with it for the moment.

I've added the row to the table using the following query:

INSERT INTO civicrm_option_value (option_group_id,label,value,name,weight) VALUES
(35,'Miss','5','Miss',5);

Notes
1) All my tables in the database are prefixed with civicrm_ I'm not sure if that will be true for anyone else.

2) The option_group_id is 35, not 6. In the option_group table there are two entries for individual_prefix - numbers 6 and 35. I presume that number 6 is the preset group only - when I set my new entry to 6 it didn't show up in the drop down or in the admin screen. It does now.

By the way - my users and I think this system is awesome! Wish I was as well!

Thanks