CiviCRM Community Forums (archive)

Hi there,
Been trying to upgrade for a few hours with no success.
After clicking the upgrade db button, i get this

Sorry. A non-recoverable error has occurred.
DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

Database Error Code: Error on rename of './amurt_civicrm2/civicrm_group_organization' to './amurt_civicrm2/#sql2-b48-54a61' (errno: 152), 1025

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => -- CRM-4610
    ALTER TABLE `civicrm_group_organization`
        DROP FOREIGN KEY `FK_civicrm_group_organization_group_id`,
        DROP FOREIGN KEY `FK_civicrm_group_organization_organization_id` [nativecode=1025 ** Error on rename of './amurt_civicrm2/civicrm_group_organization' to './amurt_civicrm2/#sql2-b48-54a61' (errno: 152)]
    [type] => DB_Error
    [user_info] => -- CRM-4610
    ALTER TABLE `civicrm_group_organization`
        DROP FOREIGN KEY `FK_civicrm_group_organization_group_id`,
        DROP FOREIGN KEY `FK_civicrm_group_organization_organization_id` [nativecode=1025 ** Error on rename of './amurt_civicrm2/civicrm_group_organization' to './amurt_civicrm2/#sql2-b48-54a61' (errno: 152)]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="-- CRM-4610
    ALTER TABLE `civicrm_group_organization`
        DROP FOREIGN KEY `FK_civicrm_group_organization_group_id`,
        DROP FOREIGN KEY `FK_civicrm_group_organization_organization_id` [nativecode=1025 ** Error on rename of './amurt_civicrm2/civicrm_group_organization' to './amurt_civicrm2/#sql2-b48-54a61' (errno: 152)]"]
)


here it goes

CREATE TABLE `civicrm_group_organization` (
 `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Relationship ID',
 `group_id` int(10) unsigned NOT NULL COMMENT 'ID of the group',
 `organization_id` int(10) unsigned NOT NULL COMMENT 'ID of the Organization Contact',
 PRIMARY KEY  (`id`),
 KEY `FK_civicrm_group_organization_group_id` (`group_id`),
 KEY `FK_civicrm_group_organization_organization_id` (`organization_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Hi there,

I followed all the steps, but got an error while importing the data-only sql file.
SQL query:

-- -- Dumping data for table 'civicrm_activity' -- INSERT INTO civicrm_activity (id, source_contact_id, source_record_id, activity_type_id, subject, activity_date_time, due_date_time, duration, location, phone_id, phone_number, details, status_id, priority_id, parent_id, is_test, medium_id, is_auto, relationship_id, is_current_revision, original_id, is_deleted) VALUES (1, 1, NULL, 3, 'teste', '2009-07-10 15:47:00', NULL, NULL, NULL, NULL, NULL, 'Olá {contact.do_not_phone}{contact.home_URL}\r\nteste\r\n', 2, NULL, NULL, 0, NULL, 0, NULL, 1, NULL, 0), (2, 51, 1, 6, '€ 15.00', '2009-09-01 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, 0, NULL, 0, NULL, 1, NULL, 0), (3, 45, 2, 6, '€ 12.00 - 1€ p mes', '2009-08-25 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, 0, NULL, 0, NULL, 1, NULL, 0), (4, 51, 3, 6, '€ 15.00 - 1€ por mes', '2009-10-01 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, 0, NULL, 0, NULL, 1, NULL, 0), (5, 60, 4, 6, '�[...]

MySQL said:

#1054 - Unknown column 'due_date_time' in 'field list'

Due to some recent changes, the link i gave you looks to be incomplete/confusing and therefore can't ask you if you following the docs correctly.

While i correct that link, you could follow a previous version - http://wiki.civicrm.org/confluence/display/CRMDOC30/Ensuring+Schema+Integrity+on+Upgrades, which has correct information.

That indicates that there are some orphaned entries in your data i.e civicrm_activity table pointing to non existing contact, causing that error (which IMO isn't a big concern).

Disabling foreign key checks while importing should work.

ok I got that one.
edited my data-only sql file and added back the line which disabled the checks.
upgrade to 2.2.8 was ok. i'm trying 3.0.4 now

well if "show create table civicrm_group_organization;" doesn't show you the constraint in the format:
| civicrm_group_organization | CREATE TABLE `civicrm_group_organization` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Relationship ID',
  `group_id` int(10) unsigned NOT NULL COMMENT 'ID of the group',
  `organization_id` int(10) unsigned NOT NULL COMMENT 'ID of the Organization Contact',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_group_organization` (`group_id`,`organization_id`),
  KEY `FK_civicrm_group_organization_group_id` (`group_id`),
  KEY `FK_civicrm_group_organization_organization_id` (`organization_id`),
  CONSTRAINT `FK_civicrm_group_organization_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_civicrm_group_organization_organization_id` FOREIGN KEY (`organization_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |


means schema / structure is still the same and sth went wrong while following the instructions.

You might want to contact http://civicrm.org/professional for better help.

seems like thats more a mysql/innodb/shared hosting issue than a civicrm issue

as deepak suggested, your best bet would be to hire someone who can look at the error messages and make progress based on responses

lbo