Update from i-doit 0.9.9-1 to 0.9.9-2 fails ***SOLVED***

jannav

Dear i-doit team,

we are trying to upgrade our version to 0.9.9-2 but following error occurs

isys_exception_database : Query error: 'ALTER TABLE isys_catg_drive_list DROP FOREIGN KEY isys_catg_drive_list_ibfk_3': Error on rename of './idoitnew_mandant/isys_catg_drive_list' to './idoitnew_mandant/#sql2-37fc-798' (errno: 152)

It seems that this table has no such FOREIGN KEY

mysql> SHOW CREATE TABLE isys_catg_drive_list\G
*************************** 1. row ***************************
Table: isys_catg_drive_list
Create Table: CREATE TABLE isys_catg_drive_list (
isys_catg_drive_list__id int(10) unsigned NOT NULL AUTO_INCREMENT,
isys_catg_drive_list__isys_stor_raid_level__id int(10) unsigned DEFAULT NULL,
isys_catg_drive_list__isys_filesystem_type__id int(10) unsigned DEFAULT NULL,
isys_catg_drive_list__isys_stor_unit__id int(10) unsigned DEFAULT NULL,
isys_catg_drive_list__isys_memory_unit__id int(10) unsigned DEFAULT NULL,
isys_catg_drive_list__isys_catd_drive_type__id int(10) unsigned DEFAULT NULL,
isys_catg_drive_list__id__raid_pool int(10) unsigned DEFAULT NULL,
isys_catg_drive_list__title varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
isys_catg_drive_list__capacity bigint(20) DEFAULT NULL,
isys_catg_drive_list__description text COLLATE utf8_unicode_ci,
isys_catg_drive_list__driveletter varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
isys_catg_drive_list__partitionmapping varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
isys_catg_drive_list__filesystem varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
isys_catg_drive_list__sort int(10) unsigned DEFAULT '5',
isys_catg_drive_list__const varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
isys_catg_drive_list__property int(10) unsigned DEFAULT '0',
isys_catg_drive_list__status int(10) unsigned DEFAULT '2',
isys_catg_drive_list__isys_obj__id int(10) unsigned DEFAULT NULL,
PRIMARY KEY (isys_catg_drive_list__id),
KEY isys_catd_drive_list_FKIndex2 (isys_catg_drive_list__id__raid_pool),
KEY isys_catd_drive_list_FKIndex3 (isys_catg_drive_list__isys_catd_drive_type__id),
KEY isys_catd_drive_list_FKIndex4 (isys_catg_drive_list__isys_stor_unit__id),
KEY isys_catd_drive_list_FKIndex5 (isys_catg_drive_list__isys_filesystem_type__id),
KEY isys_catd_drive_list_FKIndex6 (isys_catg_drive_list__isys_stor_raid_level__id),
KEY isys_catd_drive_list__isys_memory_unit__id (isys_catg_drive_list__isys_memory_unit__id),
KEY isys_catg_drive_list__isys_obj__id (isys_catg_drive_list__isys_obj__id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
1 row in set (0.00 sec)

Do you know about some workaround that we can continue with upgrade?

jannav

SOLVED: problem is in our database - foreign keys are missing. They were not created for some strange reason

Update runs smoothly after creating foreign keys