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

    Fehler beim Update auf 0.9.9-1

    Scheduled Pinned Locked Moved Entwicklung
    9 Posts 3 Posters 2.0k 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.
    • M Offline
      maichelt
      last edited by

      Hallo,

      bekomme beim Update bei allen Mandanten diesen Fehler:

      isys_exception_database : Query error: 'ALTER TABLE isys_netp_port CHANGE isys_netp_port__isys_obj__id isys_catg_port_list__isys_obj__id INT( 10 ) UNSIGNED NULL DEFAULT NULL , CHANGE isys_netp_port__isys_port_negotiation__id isys_catg_port_list__isys_port_negotiation__id INT( 10 ) UNSIGNED NULL DEFAULT NULL , CHANGE isys_netp_port__isys_catg_netp_list__id isys_catg_port_list__isys_catg_netp_list__id INT( 10 ) UNSIGNED NULL DEFAULT NULL , CHANGE isys_netp_port__isys_port_standard__id isys_catg_port_list__isys_port_standard__id INT( 10 ) UNSIGNED NULL DEFAULT NULL , CHANGE isys_netp_port__isys_port_duplex__id isys_catg_port_list__isys_port_duplex__id INT( 10 ) UNSIGNED NULL DEFAULT NULL , CHANGE isys_netp_port__isys_port_type__id isys_catg_port_list__isys_port_type__id INT( 10 ) UNSIGNED NULL DEFAULT NULL , CHANGE isys_netp_port__isys_port_speed__id isys_catg_port_list__isys_port_speed__id INT( 10 ) UNSIGNED NULL DEFAULT NULL , CHANGE isys_netp_port__isys_plug_type__id isys_catg_port_list__isys_plug_type__id INT( 10 ) UNSIGNED NULL DEFAULT NULL': Error on rename of './xxx_idoit_xxx/#sql-e9b_210e' to './xxx_idoit_xxx/isys_netp_port' (errno: 150)

      Danke.

      Gruß

      Tobi

      1 Reply Last reply Reply Quote 0
      • D Offline
        dbluemer
        last edited by

        Hallo,

        bitte einmal das Ergebnis von

        
SHOW CREATE TABLE isys_netp_port;

        posten.

        1 Reply Last reply Reply Quote 0
        • M Offline
          maichelt
          last edited by

          CREATE TABLE isys_netp_port (
          isys_netp_port__id int(10) unsigned NOT NULL auto_increment,
          isys_netp_port__isys_obj__id int(10) unsigned NOT NULL,
          isys_netp_port__isys_port_negotiation__id int(10) unsigned default NULL,
          isys_netp_port__isys_port_standard__id int(10) unsigned default NULL,
          isys_netp_port__isys_port_duplex__id int(10) unsigned default NULL,
          isys_netp_port__isys_plug_type__id int(10) unsigned default NULL,
          isys_netp_port__cable_name varchar(255) collate utf8_unicode_ci default NULL,
          isys_netp_port__isys_port_type__id int(10) unsigned default NULL,
          isys_netp_port__isys_port_speed__id int(10) unsigned default NULL,
          isys_netp_port__isys_catg_netp_list__id int(10) unsigned default NULL,
          isys_netp_port__port_speed_value bigint(32) default NULL,
          isys_netp_port__title varchar(255) collate utf8_unicode_ci default NULL,
          isys_netp_port__description text collate utf8_unicode_ci,
          isys_netp_port__mac varchar(255) collate utf8_unicode_ci default NULL,
          isys_netp_port__state_enabled int(10) unsigned default '1',
          isys_netp_port__number int(10) unsigned default '0',
          isys_netp_port__status int(10) unsigned default NULL,
          isys_netp_port__property int(10) unsigned default NULL,
          PRIMARY KEY  (isys_netp_port__id),
          KEY isys_netp_port_FKIndex1 (isys_netp_port__isys_port_type__id),
          KEY isys_netp_port_FKIndex2 (isys_netp_port__isys_catg_netp_list__id),
          KEY isys_netp_port_FKIndex3 (isys_netp_port__isys_port_speed__id),
          KEY isys_netp_port_FKIndex5 (isys_netp_port__isys_port_duplex__id),
          KEY isys_netp_port_FKIndex6 (isys_netp_port__isys_port_negotiation__id),
          KEY isys_netp_port_FKIndex7 (isys_netp_port__isys_port_standard__id),
          KEY isys_netp_port__isys_plug_type__id (isys_netp_port__isys_plug_type__id),
          KEY isys_netp_port__isys_obj__id (isys_netp_port__isys_obj__id),
          CONSTRAINT isys_netp_port_ibfk_10 FOREIGN KEY (isys_netp_port__isys_port_type__id) REFERENCES isys_port_type (isys_port_type__id) ON DELETE SET NULL ON UPDATE CASCADE,
          CONSTRAINT isys_netp_port_ibfk_11 FOREIGN KEY (isys_netp_port__isys_plug_type__id) REFERENCES isys_plug_type (isys_plug_type__id) ON DELETE SET NULL ON UPDATE CASCADE,
          CONSTRAINT isys_netp_port_ibfk_3 FOREIGN KEY (isys_netp_port__isys_port_speed__id) REFERENCES isys_port_speed (isys_port_speed__id) ON DELETE NO ACTION ON UPDATE NO ACTION,
          CONSTRAINT isys_netp_port_ibfk_5 FOREIGN KEY (isys_netp_port__isys_port_duplex__id) REFERENCES isys_port_duplex (isys_port_duplex__id) ON DELETE NO ACTION ON UPDATE NO ACTION,
          CONSTRAINT isys_netp_port_ibfk_6 FOREIGN KEY (isys_netp_port__isys_port_negotiation__id) REFERENCES isys_port_negotiation (isys_port_negotiation__id) ON DELETE NO ACTION ON UPDATE NO ACTION,
          CONSTRAINT isys_netp_port_ibfk_7 FOREIGN KEY (isys_netp_port__isys_port_standard__id) REFERENCES isys_port_standard (isys_port_standard__id) ON DELETE NO ACTION ON UPDATE NO ACTION,
          CONSTRAINT isys_netp_port_ibfk_8 FOREIGN KEY (isys_netp_port__isys_obj__id) REFERENCES isys_obj (isys_obj__id) ON DELETE CASCADE ON UPDATE CASCADE,
          CONSTRAINT isys_netp_port_ibfk_9 FOREIGN KEY (isys_netp_port__isys_catg_netp_list__id) REFERENCES isys_catg_netp_list (isys_catg_netp_list__id) ON DELETE SET NULL ON UPDATE CASCADE
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

          1 Reply Last reply Reply Quote 0
          • D Offline
            dawnbreak
            last edited by

            Hallo,

            Ich habe gerade bei der selben Tabelle ein ähnliches Problem:
            isys_exception_database : Query error: 'ALTER TABLE isys_netp_port CHANGE isys_netp_port__id isys_catg_port_list__id INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT': Error on rename of './idoit_XXX/#sql-61b_2d6' to './idoit_XXX/isys_netp_port' (errno: 150)

            SHOW CREATE TABLE isys_netp_port;

CREATE TABLE `isys_netp_port` (
  `isys_netp_port__id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `isys_catg_port_list__isys_obj__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_port_list__isys_port_negotiation__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_port_list__isys_port_standard__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_port_list__isys_port_duplex__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_port_list__isys_plug_type__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_port_list__cable_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `isys_catg_port_list__isys_port_type__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_port_list__isys_port_speed__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_port_list__isys_catg_netp_list__id` int(10) unsigned DEFAULT NULL,
  `isys_catg_port_list__port_speed_value` bigint(32) DEFAULT NULL,
  `isys_catg_port_list__title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `isys_catg_port_list__description` text COLLATE utf8_unicode_ci,
  `isys_catg_port_list__mac` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `isys_catg_port_list__state_enabled` int(10) unsigned DEFAULT '1',
  `isys_catg_port_list__number` int(10) unsigned DEFAULT '0',
  `isys_catg_port_list__status` int(10) unsigned DEFAULT NULL,
  `isys_catg_port_list__property` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`isys_netp_port__id`),
  KEY `isys_netp_port_FKIndex1` (`isys_catg_port_list__isys_port_type__id`),
  KEY `isys_netp_port_FKIndex2` (`isys_catg_port_list__isys_catg_netp_list__id`),
  KEY `isys_netp_port_FKIndex3` (`isys_catg_port_list__isys_port_speed__id`),
  KEY `isys_netp_port_FKIndex5` (`isys_catg_port_list__isys_port_duplex__id`),
  KEY `isys_netp_port_FKIndex6` (`isys_catg_port_list__isys_port_negotiation__id`),
  KEY `isys_netp_port_FKIndex7` (`isys_catg_port_list__isys_port_standard__id`),
  KEY `isys_netp_port__isys_plug_type__id` (`isys_catg_port_list__isys_plug_type__id`),
  KEY `isys_netp_port__isys_obj__id` (`isys_catg_port_list__isys_obj__id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

            Der MySQL User hat "ALL PRIVILEGES" auf der Datenbank idoit_XXX.

            Ich habe von einer älteren Installation geupdated und alle Schritte mit dem Webupdater gemacht und es gab keine Probleme, bis auf das letzte Update jetzt von 0.9.9 auf 0.9.9-1.

            1 Reply Last reply Reply Quote 0
            • D Offline
              dbluemer
              last edited by

              Bitte mal alle Constraints aus der Tabelle löschen und das Update danach nochmal ausführen.

              1 Reply Last reply Reply Quote 0
              • M Offline
                maichelt
                last edited by

                Alles gelöscht und Update nochmal gemacht, dann kommt diese Meldung:

                isys_exception_database : Query error: 'ALTER TABLE `isys_netp_port` CHANGE `isys_netp_port__cable_name` `isys_catg_port_list__cable_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL , CHANGE `isys_netp_port__port_speed_value` `isys_catg_port_list__port_speed_value` BIGINT( 32 ) NULL DEFAULT NULL , CHANGE `isys_netp_port__title` `isys_catg_port_list__title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL , CHANGE `isys_netp_port__description` `isys_catg_port_list__description` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL , CHANGE `isys_netp_port__mac` `isys_catg_port_list__mac` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL , CHANGE `isys_netp_port__state_enabled` `isys_catg_port_list__state_enabled` INT( 10 ) UNSIGNED NULL DEFAULT '1', CHANGE `isys_netp_port__number` `isys_catg_port_list__number` INT( 10 ) UNSIGNED NULL DEFAULT '0', CHANGE `isys_netp_port__status` `isys_catg_port_list__status` INT( 10 ) UNSIGNED NULL DEFAULT NULL , CHANGE `isys_netp_port__property` `isys_catg_port_list__property` INT( 10 ) UNSIGNED NULL DEFAULT NULL': Unknown column 'isys_netp_port__cable_name' in 'isys_netp_port'

                Danke.

                Gruß

                Tobi

                1 Reply Last reply Reply Quote 0
                • D Offline
                  dbluemer
                  last edited by

                  Bitte erst die Datenbank zurückspielen, dann die Constraints löschen, dann Update nochmal ausführen.

                  1 Reply Last reply Reply Quote 0
                  • M Offline
                    maichelt
                    last edited by

                    Hallo,

                    bis auf 3 Mandanten lief das Update und bei diesen 3 kommt diese Meldung, DB zurückgespielt und Constraints gelöscht:

                    
isys_exception_database : Query error: 'ALTER TABLE `isys_netp_port` CHANGE `isys_netp_port__cable_name` `isys_catg_port_list__cable_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL , CHANGE `isys_netp_port__port_speed_value` `isys_catg_port_list__port_speed_value` BIGINT( 32 ) NULL DEFAULT NULL , CHANGE `isys_netp_port__title` `isys_catg_port_list__title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL , CHANGE `isys_netp_port__description` `isys_catg_port_list__description` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL , CHANGE `isys_netp_port__mac` `isys_catg_port_list__mac` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL , CHANGE `isys_netp_port__state_enabled` `isys_catg_port_list__state_enabled` INT( 10 ) UNSIGNED NULL DEFAULT '1', CHANGE `isys_netp_port__number` `isys_catg_port_list__number` INT( 10 ) UNSIGNED NULL DEFAULT '0', CHANGE `isys_netp_port__status` `isys_catg_port_list__status` INT( 10 ) UNSIGNED NULL DEFAULT NULL , CHANGE `isys_netp_port__property` `isys_catg_port_list__property` INT( 10 ) UNSIGNED NULL DEFAULT NULL': Unknown column 'isys_netp_port__cable_name' in 'isys_netp_port'

                    Danke

                    Gruß

                    Tobi

                    1 Reply Last reply Reply Quote 0
                    • M Offline
                      maichelt
                      last edited by

                      Hallo,

                      keiner mehr eine Idee?

                      Danke.

                      Gruß

                      Tobi

                      1 Reply Last reply Reply Quote 0

                      Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                      Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                      With your input, this post could be even better 💗

                      Register Login
                      • First post
                        Last post