Skip to main content
2 of 2
added 110 characters in body

DB Error : Uknown error (When a new profile is created in multilingual CiviCRM setup)

Trying to create a new profile to get attached in contribution page, when hit save, a message box "DB Error: unknown error" appears.

This happening on multilingual civiCRM setup on multiple versions 5.35.2 to 5.50.3. On single language CiviCRM setup this error doesn't appear instead.

Looking in civiCRM log appears

    Jun 30 15:39:23  [debug] $Query = SELECT path, data, UNIX_TIMESTAMP(expired_date) as expires FROM civicrm_cache WHERE group_name = "checks" AND path = "systemStatusCheckResult"

Jun 30 15:39:23  [info]  QUERY DONE IN 0.000821  seconds. Result is 0 rows by 3 columns. 

Jun 30 15:39:23  [debug] $Query = BEGIN

Jun 30 15:39:23  [debug] $Query = SELECT path, data, UNIX_TIMESTAMP(expired_date) as expires FROM civicrm_cache WHERE group_name = "contact-20fields" AND path = "custom importableFields UFGroup_0_0_0_0__0__0__0_0__1_7acce319"

Jun 30 15:39:23  [info]  QUERY DONE IN 0.000765  seconds. Result is 0 rows by 3 columns. 

Jun 30 15:39:23  [debug] $Query = INSERT INTO `civicrm_uf_group_en_US` (`is_active` , `title` , `frontend_title` , `help_pre` , `help_post` , `is_update_dupe` , `name` , `created_id` , `created_date` ) VALUES ( 1 , 'New Membership Signup' ,  NULL ,  NULL ,  NULL ,  1 , 'New_Membership_Signup' ,  2 ,  20220630153923 ) 

Jun 30 15:39:23  [debug] $Query = COMMIT

When look in database this record does not exist.

----- Update ---- DB Error on profile creation

CiviCRM ver: 5.35.2 to 5.50.3, Wordpress ver: 5.9.1, PHP ver: 7.3.31, MariaDB ver: 10.3.31

Thanks for any guidance!