CiviCRM Community Forums (archive)

Looking for clues as to what may have caused this error

Database Error Code: Incorrect information in file: './testv4mmp_crm/civicrm_domain.frm', 1033

Error Details:

[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: './testv4mmp_crm/civicrm_domain.frm']"]

They look OK. This is a test site which I upgraded to 1.8 a few days ago. We had a problem with the main site and when we went to look at the test site it started throwing this error too.

Yes, meticulously! Reset the Drupal session and cleaned up template cache.

The site has been working fine for the last few days

1. most likely your civicrm_domain table is corrupt. You will need to repair it (mysql command)

2. are you using MyISAM? (i'm pretty sure you are). CiviCRM uses transactions and rollbacks to avoid getting into a bad state. This is NOT supported by MyISAM, and hence will cause you issues down the road. You should definitely move the db's to InnoDB

lobo

in your mysql database, can u run this command:

mysql> show create table civicrm_domain \G;

There is a difference between what is present in the sql file and what mysql interprets it as

The main reason i think u r with MyISAM is because of the civicrm_domain.frm file, which i think is a MyISAM based file

lobo

Things started to work better when a second instance of MySQL was killed!

Now I get the following which confirms that these are MyISAM tables.

mysql> show create table civicrm_domain \G;
*************************** 1. row ***************************
       Table: civicrm_domain
Create Table: CREATE TABLE `civicrm_domain` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Domain ID',
  `name` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'Name of Domain / Organization',
  `description` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Description of Domain.',
  `contact_name` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'Name of the person responsible for this domain',
  `email_domain` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'The domain from which outgoing email for this domain will appear to originate',
  `email_return_path` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'The domain from which outgoing email for this domain will appear to originate',
  `config_backend` text collate utf8_unicode_ci COMMENT 'Backend configuration.',
  `config_frontend` text collate utf8_unicode_ci COMMENT 'Frontend configuration.',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `UI_name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Bryght suggested this command
mysql_convert_table_format --user='username' --password='password' --type=innodb databasename

Which does what it says. I'll try it later tonight.

Neil:

another alternative of doing the conversion is:

1. Do a mysql dump of the data only
2. create a new database
3. load the right civicrm_41.mysql
4. load the data file created in step 1

lobo