Author Topic: DB Error: Unknown Error adding or updating custom fields! (Read 5442 times)

bcastillov · June 14, 2013, 12:01:55 am

hello!
Since yesterday, after adding or modifying any custom data in CiviCRM, the system displays the error:

DB Error: Unknown Error

By reviewing the custom data that was added or modified, CiviCRM has done correctly. But it shows this error message after doing so.

This behavior has been inconsistent, we are working with CiviCRM about two weeks and it has happened yesterday.

Any help or suggestions are welcome!

Thank you!

See the image attached. The problem is in this path:
../civicrm/admin/custom/group/field/add
../civicrm/admin/custom/group/field/update

My config:
Drupal 7.22
CiviCRM 4.3.3
PHP 5.3.3
MySQL 5.1.69
PHP Register globals: disabled
PHP memory limite: 128Mb
PHP Extensions: enabled
WebServer Apache

bcastillov · June 14, 2013, 12:38:58 am

Hi!

I activated the debug mode in my civicrm. The error behind DB Error: Unknown Error is this:

Identifier name 'civicrm_value_datos_complementarios_del_voluntario_6_after_insert' is too long, 1059
Detalles Adicionales:

DROP TRIGGER IF EXISTS civicrm_value_datos_complementarios_del_voluntario_6_after_insert nativecode=1059 ** Identifier name 'civicrm_value_datos_complementarios_del_voluntario_6_after_insert' is too long
DB_Error
DROP TRIGGER IF EXISTS civicrm_value_datos_complementarios_del_voluntario_6_after_insert nativecode=1059 ** Identifier name 'civicrm_value_datos_complementarios_del_voluntario_6_after_insert' is too long
db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="DROP TRIGGER IF EXISTS civicrm_value_datos_complementarios_del_voluntario_6_after_insert nativecode=1059 ** Identifier name 'civicrm_value_datos_complementarios_del_voluntario_6_after_insert' is too long

I edit the name of that group of custom data to other short and try to eliminate the custom fields in. I get this error:

Código de Error de la Base de Datos: Can't DROP 'nombre_del_idioma_39'; check that column/key exists, 1091
Detalles Adicionales:

DB Error: not found
ALTER TABLE civicrm_value_dominio_de_idiomas_del_voluntario_7 DROP COLUMN `nombre_del_idioma_39` nativecode=1091 ** Can't DROP 'nombre_del_idioma_39'; check that column/key exists
DB_Error
ALTER TABLE civicrm_value_dominio_de_idiomas_del_voluntario_7 DROP COLUMN `nombre_del_idioma_39` nativecode=1091 ** Can't DROP 'nombre_del_idioma_39'; check that column/key exists
db_error: message="DB Error: not found" code=-4 mode=callback callback=CRM_Core_Error::handle prefix="" info=" ALTER TABLE civicrm_value_dominio_de_idiomas_del_voluntario_7 DROP COLUMN `nombre_del_idioma_39` nativecode=1091 ** Can't DROP 'nombre_del_idioma_39'; check that column/key exists"

¿Some ideas?

jamie · June 28, 2013, 12:12:09 pm

I had a similar error. I found a posted bug here: http://issues.civicrm.org/jira/browse/CRM-12780

The work around is a bit complex though.

CiviCRM Community Forums (archive)

News:

Author Topic: DB Error: Unknown Error adding or updating custom fields! (Read 5442 times)

bcastillov

DB Error: Unknown Error adding or updating custom fields!

bcastillov

Re: DB Error: Unknown Error adding or updating custom fields!

jamie

Re: DB Error: Unknown Error adding or updating custom fields!