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



  • 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?



  • 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


Log in to reply
 


Datenschutz / Privacy Policy