Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

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

    Scheduled Pinned Locked Moved Operating
    2 Posts 1 Posters 1.6k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • J Offline
      jannav
      last edited by

      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?

      1 Reply Last reply Reply Quote 0
      • J Offline
        jannav
        last edited by

        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

        1 Reply Last reply Reply Quote 0
        • First post
          Last post