Author Topic: Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286 (Read 2980 times)

avanoers · March 09, 2010, 03:50:12 pm

Hello,

After a drupal upgrade to Drupal 6.16 from 6.15 I can not access CiviCRM. The error when trying to login is:

unrecoverable error
Sorry. A non-recoverable error has occurred.
DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286

Error Details:
Array
(
[callback] => Array
(

=> CRM_Core_Error

Code: [Select]

 => a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => SELECT * 
 FROM civicrm_preferences 
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 ) 
  [nativecode=1286 ** Unknown table engine 'InnoDBTԪ*']
    [type] => DB_Error
    [user_info] => SELECT * 
 FROM civicrm_preferences 
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 ) 
  [nativecode=1286 ** Unknown table engine 'InnoDBTԪ*']
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT * 
 FROM civicrm_preferences 
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 ) 
  [nativecode=1286 ** Unknown table engine 'InnoDBTԪ*']"]
)

When I look at the CiviCRM database all the table in that database have the Unkown table engine error. Some just say InnoDB some have weird characters behind that.

Any help would be greatly appreciated.

Piotr Szotkowski · March 10, 2010, 03:23:30 am

Quote from: avanoers on March 09, 2010, 03:50:12 pm

After a drupal upgrade to Drupal 6.16 from 6.15 I can not access CiviCRM. The error when trying to login is:

unrecoverable error
Sorry. A non-recoverable error has occurred.
DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286

[…]

When I look at the CiviCRM database all the table in that database have the Unkown table engine error. Some just say InnoDB some have weird characters behind that.

This is very strange and something we haven’t seen before.

My guess would be that something unrelated to the upgrade happened to your CiviCRM database; can you try rolling back to your latest backup and checking whether it works with Drupal 6.16?

avanoers · March 10, 2010, 06:42:23 am

Yes it was a problem with our hosting service. For some reason the database dropped support for the InnoDB engine. It totally corrupted the database and I've had to recreate a new database, create a fresh CiviCRM instal and now when I am trying to import my backup data via PhpMyadmin and my sql dump I get a foreign key error:
#1217 - Cannot delete or update a parent row: a foreign key constraint fails
Any ideas about this? In the meantime I'll look around on the forums.

Never a dull day!

Piotr Szotkowski · March 10, 2010, 10:07:41 am

Quote from: avanoers on March 10, 2010, 06:42:23 am

when I am trying to import my backup data via PhpMyadmin and my sql dump I get a foreign key error:
#1217 - Cannot delete or update a parent row: a foreign key constraint fails
Any ideas about this?

You can try turning off foreign key constraints checks in your SQL dump. Our developer dump uses the below:

Code: [Select]

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

…dump here…

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

CiviCRM Community Forums (archive)

News:

Author Topic: Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286 (Read 2980 times)

avanoers

Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286

Piotr Szotkowski

Re: Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286

avanoers

Re: Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286

Piotr Szotkowski

Re: Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286