CiviCRM Community Forums (archive)

Sorry. A non-recoverable error has occurred.
DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
Error Details
Database Error Code: Specified key was too long; max key length is 1000 bytes, 1071
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => ALTER TABLE civicrm_option_value MODIFY COLUMN value varchar(512) [nativecode=1071 ** Specified key was too long; max key length is 1000 bytes]
    [type] => DB_Error
    [user_info] => ALTER TABLE civicrm_option_value MODIFY COLUMN value varchar(512) [nativecode=1071 ** Specified key was too long; max key length is 1000 bytes]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE civicrm_option_value MODIFY COLUMN value varchar(512) [nativecode=1071 ** Specified key was too long; max key length is 1000 bytes]"]
)



i tried as you said with no success, i altered all tables to innodb and then run the upgrade.
what should i do?

this is the error:

Sorry. A non-recoverable error has occurred.
DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
Error Details
Database Error Code: Error on rename of './DB/civicrm_contact' to './DB/#sql2-6693-3be' (errno: 152), 1025
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => ALTER TABLE civicrm_contact DROP  FOREIGN KEY FK_civicrm_contact_mail_to_household_id [nativecode=1025 ** Error on rename of './DB/civicrm_contact' to './DB/#sql2-6693-3be' (errno: 152)]
    [type] => DB_Error
    [user_info] => ALTER TABLE civicrm_contact DROP  FOREIGN KEY FK_civicrm_contact_mail_to_household_id [nativecode=1025 ** Error on rename of './DB/civicrm_contact' to './DB/#sql2-6693-3be' (errno: 152)]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE civicrm_contact DROP  FOREIGN KEY FK_civicrm_contact_mail_to_household_id [nativecode=1025 ** Error on rename of './DB/civicrm_contact' to './DB/#sql2-6693-3be' (errno: 152)]"]
)



You might also want to take a look at this document, just in case:
http://wiki.civicrm.org/confluence/display/CRMDOC33/Ensuring+Schema+Integrity+on+Upgrades

Thx,
m