CiviCRM Community Forums (archive)

Hi Folks

Having a major problem and our sites have been down for a couple of days now.

We have a multi language setup that had the option for English UK, Dutch and Catalonian (Spanish). Since upgrading to 4.3.3 we are unable to make any changes to data and get a 'Duplicate Entry' error message as follows;


Database Error Code: Duplicate entry 'European Register of Exercise Professionals' for key 'UI_title_ca_ES', 1062
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

 => -5
   

[message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_group_en_GB (name , title , is_active , group_type , created_id ) VALUES ('European_Register_of_Exercise_P_tmp' , 'European Register of Exercise Professionals' ,  1 ,  NULL ,  102 )  [nativecode=1062 ** Duplicate entry 'European Register of Exercise Professionals' for key 'UI_title_ca_ES']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_group_en_GB (name , title , is_active , group_type , created_id ) VALUES ('European_Register_of_Exercise_P_tmp' , 'European Register of Exercise Professionals' ,  1 ,  NULL ,  102 )  [nativecode=1062 ** Duplicate entry 'European Register of Exercise Professionals' for key 'UI_title_ca_ES']
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_group_en_GB (name , title , is_active , group_type , created_id ) VALUES ('European_Register_of_Exercise_P_tmp' , 'European Register of Exercise Professionals' ,  1 ,  NULL ,  102 )  [nativecode=1062 ** Duplicate entry 'European Register of Exercise Professionals' for key 'UI_title_ca_ES']"]
)


When you look at the Localisation setting in Civi it no longer says Catalonian but 'ca_ES' which seems to tie in with the error message. Also when you select the 'Add Language' drop down in settings it shows the language code rather than the name, see attached screen shot.

To be honest we no longer need the Catalonian language and I am hoping shortly to drop Dutch as well reverting to a single language setup. But first we need to get the sites working again.

If anybody has a clue what's gone wrong here and can advise it would be most appreciated.

Cheers

Robbie
YNWA

As I read it PHP 5.3.24 is a later (more recent) version than 5.3.2, so I would say that this is not the problem.

You should be fine with php 5.3.24. I am using php 5.3.17 with civicrm 4.3.3 and all is working as expected.

Hi Upperholme

Many thanks...I never knew that.

Robbie