CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286
Pages: [1]

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

avanoers

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286
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
    • [1] => handle
            )

       
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

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286
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?
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

avanoers

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
Re: Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286
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

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286
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 */;
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Database Error Code: Unknown table engine 'InnoDBTԪ*', 1286

This forum was archived on 2017-11-26.