CiviCRM Community Forums (archive)

Howdie folks,

Just investigating a Joomla 3.2.5 -> 3.4.8 upgrade error. 
Will look into this in more detail tomorrow but thought I would post here in case people know what is going on and can point me in the right direction in the mean time.

Thanks!

/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 159
, handle,
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 931
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 968
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 564
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/CRM/Utils/File.php, query, 260
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php, sourceSQLFile, 154
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php, source, 276
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php, processLocales, 292
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Incremental/php/ThreeThree.php, processSQL, 115
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Page/Upgrade.php, upgrade_3_3_alpha1, 241
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 223
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/admin.civicrm.php, invoke, 85
/Users/michaelmcandrew/p/fed/www/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 45
/Users/michaelmcandrew/p/fed/www/libraries/joomla/application/component/helper.php, require_once, 162
/Users/michaelmcandrew/p/fed/www/administrator/includes/application.php, renderComponent, 136
/Users/michaelmcandrew/p/fed/www/administrator/index.php, dispatch, 67
/Users/michaelmcandrew/p/fed/www/administrator/index2.php, include, 14

Summarising the error message:

Sorry. A non-recoverable error has occurred.

DB Error: unknown error

Database Error Code: Error on rename of './fed_joomla/civicrm_contact' to './fed_joomla/#sql2-452f-f9' (errno: 152), 1025

ALTER TABLE civicrm_contact DROP  FOREIGN KEY FK_civicrm_contact_mail_to_household_id

oops, sorry forgot to say that I have already checked that it is innodb and has the foreign key.

Here is the SHOW CREATE TABLE

CREATE TABLE `civicrm_contact` (
 `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique Contact ID',
 `contact_type` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'Type of Contact.',
 `contact_sub_type` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'May be used to over-ride contact view and edit templates.',
 `do_not_email` tinyint(4) default '0',
 `do_not_phone` tinyint(4) default '0',
 `do_not_mail` tinyint(4) default '0',
 `do_not_sms` tinyint(4) default '0',
 `do_not_trade` tinyint(4) default '0',
 `is_opt_out` tinyint(4) NOT NULL default '0' COMMENT 'Has the contact opted out from receiving all bulk email from the organization or site domain?',
 `legal_identifier` varchar(32) collate utf8_unicode_ci default NULL COMMENT 'May be used for SSN, EIN/TIN, Household ID (census) or other applicable unique legal/government ID.',
 `external_identifier` varchar(32) collate utf8_unicode_ci default NULL COMMENT 'Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations.',
 `sort_name` varchar(128) collate utf8_unicode_ci default NULL COMMENT 'Name used for sorting different contact types',
 `display_name` varchar(128) collate utf8_unicode_ci default NULL COMMENT 'Formatted name representing preferred format for display/print/other output.',
 `nick_name` varchar(128) collate utf8_unicode_ci default NULL COMMENT 'Nick Name.',
 `legal_name` varchar(128) collate utf8_unicode_ci default NULL COMMENT 'Legal Name.',
 `image_URL` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Optional URL for preferred image (photo, logo, etc.) to display for this contact',
 `preferred_communication_method` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'What is the preferred mode of communication.',
 `preferred_mail_format` enum('Text','HTML','Both') collate utf8_unicode_ci default 'Both' COMMENT 'What is the preferred mode of sending an email.',
 `hash` varchar(32) collate utf8_unicode_ci default NULL COMMENT 'Key for validating requests related to this contact.',
 `api_key` varchar(32) collate utf8_unicode_ci default NULL COMMENT 'API Key for validating requests related to this contact.',
 `source` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'where contact come from, e.g. import, donate module insert...',
 `first_name` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'First Name.',
 `middle_name` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'Middle Name.',
 `last_name` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'Last Name.',
 `prefix_id` int(10) unsigned default NULL COMMENT 'Prefix or Title for name (Ms, Mr...). FK to prefix ID',
 `suffix_id` int(10) unsigned default NULL COMMENT 'Suffix for name (Jr, Sr...). FK to suffix ID',
 `email_greeting_id` int(10) unsigned default NULL COMMENT 'FK to civicrm_option_value.id, that has to be valid registered Email Greeting.',
 `email_greeting_custom` varchar(128) collate utf8_unicode_ci default NULL COMMENT 'Custom Email Greeting.',
 `email_greeting_display` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Cache Email Greeting.',
 `postal_greeting_id` int(10) unsigned default NULL COMMENT 'FK to civicrm_option_value.id, that has to be valid registered Postal Greeting.',
 `postal_greeting_custom` varchar(128) collate utf8_unicode_ci default NULL COMMENT 'Custom Postal greeting.',
 `postal_greeting_display` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Cache Postal greeting.',
 `addressee_id` int(10) unsigned default NULL COMMENT 'FK to civicrm_option_value.id, that has to be valid registered Addressee.',
 `addressee_custom` varchar(128) collate utf8_unicode_ci default NULL COMMENT 'Custom Addressee.',
 `addressee_display` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Cache Addressee.',
 `job_title` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Job Title',
 `gender_id` int(10) unsigned default NULL COMMENT 'FK to gender ID',
 `birth_date` date default NULL COMMENT 'Date of birth',
 `is_deceased` tinyint(4) default '0',
 `deceased_date` date default NULL COMMENT 'Date of deceased',
 `mail_to_household_id` int(10) unsigned default NULL COMMENT 'OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct mail communications to household rather than individual location.',
 `household_name` varchar(128) collate utf8_unicode_ci default NULL COMMENT 'Household Name.',
 `primary_contact_id` int(10) unsigned default NULL COMMENT 'Optional FK to Primary Contact for this household.',
 `organization_name` varchar(128) collate utf8_unicode_ci default NULL COMMENT 'Organization Name.',
 `sic_code` varchar(8) collate utf8_unicode_ci default NULL COMMENT 'Standard Industry Classification Code.',
 `user_unique_id` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for logging in to CiviCRM',
 `employer_id` int(10) unsigned default NULL COMMENT 'OPTIONAL FK to civicrm_contact record.',
 `is_deleted` tinyint(1) NOT NULL default '0',
 `preferred_language` varchar(5) collate utf8_unicode_ci default NULL COMMENT 'Which language is preferred for communication. FK to languages in civicrm_option_value.',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `UI_external_identifier` (`external_identifier`),
 KEY `index_contact_type` (`contact_type`),
 KEY `index_contact_sub_type` (`contact_sub_type`),
 KEY `index_sort_name` (`sort_name`),
 KEY `index_preferred_communication_method` (`preferred_communication_method`),
 KEY `index_hash` (`hash`),
 KEY `index_api_key` (`api_key`),
 KEY `index_first_name` (`first_name`),
 KEY `index_last_name` (`last_name`),
 KEY `UI_prefix` (`prefix_id`),
 KEY `UI_suffix` (`suffix_id`),
 KEY `UI_gender` (`gender_id`),
 KEY `index_household_name` (`household_name`),
 KEY `index_organization_name` (`organization_name`),
 KEY `FK_civicrm_contact_mail_to_household_id` (`mail_to_household_id`),
 KEY `FK_civicrm_contact_primary_contact_id` (`primary_contact_id`),
 KEY `FK_civicrm_contact_employer_id` (`employer_id`),
 KEY `index_is_deleted` (`is_deleted`),
 CONSTRAINT `FK_civicrm_contact_employer_id` FOREIGN KEY (`employer_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL,
 CONSTRAINT `FK_civicrm_contact_mail_to_household_id` FOREIGN KEY (`mail_to_household_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL,
 CONSTRAINT `FK_civicrm_contact_primary_contact_id` FOREIGN KEY (`primary_contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=48528 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci