nativecode=1033 ** Incorrect information in file: './civicrm/civicrm_domain.frm

[cdm]

Hi all,

Today our civicrm install on drupal white screened our site and started outputting the following to the screen:

Code: [Select]

Sorry. A non-recoverable error has occurred. The error trace below might help to resolve the issue
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => SELECT  config_backend 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1033 ** Incorrect information in file: './civicrm/civicrm_domain.frm']
    [type] => DB_Error
    [user_info] => SELECT  config_backend 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1033 ** Incorrect information in file: './civicrm/civicrm_domain.frm']
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  config_backend 
 FROM civicrm_domain
 
 WHERE (  civicrm_domain.id = 1 ) 
 
 
 
 [nativecode=1033 ** Incorrect information in file: './civicrm/civicrm_domain.frm']"]
)



The only way I could get drupal to come back was to rename the civicrm config file and then disable the module. Any ideas on what this means and how to fix it? Thanks.[/code]

[emilyf]

In civicrm.settings.php, is the 'CIVICRM_UF_BASEURL' variable defined correctly to your site (including the trailing slash)?

[Dave Greenberg]

This is a MySQL error - seems to indicate either DB corruption or some problem in the MySQL configuration file(s). Doing a quick Google search on 'MySQL 1033' brings up this MySQL forum thread (among other results):

http://forums.mysql.com/read.php?22,106192,106192#msg-106192

[cdm]

Thanks Dave, that link led me in the right direction.

What I ended up doing was rebuilding the "civicrm_domain" table that was mentioned in the error message. All the resources online I found say you should use "myisamchk" but my civicrm tables are all Innodb! Is this normal?

Anyway I ran the following from the mysql command line after backing up the db
"ALTER TABLE civicrm_domain ENGINE = InnoDB;"

Then I turned civicrm back on in drupal and everything seems to be working correctly now.

[Dave Greenberg]

Glad it worked out. All CiviCRM tables should be INNODB, not ISAM.

[haggan]

Hej!

I got exactly the same error. When I checked Yum had updated mysql and removed my own /etc/my.cnf so that no innodb information was in it.

I copied back my old conf file and restarted mysql and I am back up again! pjuff