unrecoverable error: Error on rename of /civicrm_group_organization

[arlind]

Hi,

I'm impressed with CiviCRM and was looking forward to 3.0 - but I get this error when I run the update script.

:-) Bo

Code: [Select]

Upgrade CiviCRM to Version 3.0.0

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

    Database Error Code: Error on rename of './sik_live_crm/civicrm_group_organization' to './sik_live_crm/#sql2-43c1-43f06' (errno: 152), 1025

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => 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 './sik_live_crm/civicrm_group_organization' to './sik_live_crm/#sql2-43c1-43f06' (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 './sik_live_crm/civicrm_group_organization' to './sik_live_crm/#sql2-43c1-43f06' (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 './sik_live_crm/civicrm_group_organization' to './sik_live_crm/#sql2-43c1-43f06' (errno: 152)]"]
)
[/code]

[Donald Lobo]

1. what version of mysql are you using

2. also if you are familiar with mysql, can you run the following:

 ALTER TABLE `civicrm_group_organization`
        DROP FOREIGN KEY `FK_civicrm_group_organization_group_id`,
        DROP FOREIGN KEY `FK_civicrm_group_organization_organization_id`

and see if that works

lobo

[arlind]

Hi Lobo

Thanks for helping me out, but I still get the an error.

MySQL: 5.0.32

Error:
#1025 - Error on rename of './sik_live_crm/civicrm_group_organization' to './sik_live_crm/#sql2-43c1-44190' (errno: 152)

I dont know whether the database is correct updated from 2.2.7 to 2.2.8, since the update script stopped - see issue:
http://forum.civicrm.org/index.php/topic,9374.msg40471.html#msg40471

thanks Bo :-)

Code: [Select]

-- phpMyAdmin SQL Dump
-- version 2.8.2.4
-- http://www.phpmyadmin.net
--
-- Vært: localhost:3306
-- Genereringstid: 02/10 2009 kl. 17:34:53
-- Serverversion: 5.0.32
-- PHP version: 5.2.6
--

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `civicrm_group_organization`
--
-- Oprettelse: 02/10 2009 kl. 16:12:50
--

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;

--
-- Data dump for tabellen `civicrm_group_organization`
--
(none)


[Donald Lobo]

Did u try the alter statement and that did not work?

What are the contents of the group_organization table?

lobo

[arlind]

I deleted the two index, but still got an error when updating.

The update script for 3.0 says the database is not updated to 2.2.8 - only 2.2.7 even though I use 2.2.8. When trying to update to 2.2.8 I get same non-existent-error:
http://forum.civicrm.org/index.php/topic,9374.msg40471.html#msg40471

The table contains no data.

:-) Bo

[Donald Lobo]

can u email your database to deepak at webaccess dot co dot in

We'll take a look and get back 2 u

lobo

[Blake]

Was there any resolution to this error? I got the exact same error with same error details when updating from 2.2.9 w/ drupal 6.14.

Should I also email my database to deepak?

[arlind]

Hi Lobo and Donald

I was greatfull for the help offered by Lobo, but I think, it would be against local danish law to mail a member-database of a political party to outsiders.

Thus my problem is not solved, but I am sure that it would have been could I use the help provided.

:-) Bo

[Donald Lobo]

hey blake:

can u please email you db to deepak

thanx

lobo

[Blake]

I emailed Deepak earlier in the day and look forward to figuring this thing out! 

[Deepak Srivastava]

Blake,

We found that your database is missing Foreign Key Constraints in all the tables. One of the reason could be change of storage engine (probably from MyISAM to InnoDB).

Try correcting the schema by following the steps documented here - http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades and then go for upgrade.

[jeffw]

Getting exact same thing here on 2.2.5 to 3.0.2.  I'll look at the thing on the last post.

[Blake]

What Deepak recommended did work, however it was a really pain in the butt to do. You are best off avoiding phpmyadmin altogether if you hit a timeout (which will probably happen unless you have a small database).

Here are some shell commands I used on MediaTemple. Most hosts require less:
import from backup: mysql -u [username] -p[password] -t [database-name] -h [hostname]  <  [file-to-import].sql
data only dump: mysqldump --no-create-info -u [username] -h [hostname] -p[password] [database-name] > [name-of-new-data-file].sql
table only dump: mysqldump --no-data -u [username] -h [hostname] -p[password] [database-name] > [name-of-new-table-file].sql

Good luck.