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

    Fehler beim Update auf 0.9.9-1

    Scheduled Pinned Locked Moved
    Entwicklung
    3
    9
    1.7k
    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
      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
        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
          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
            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
              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
                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
                  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
                    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
                      maichelt
                      last edited by

                      Hallo,

                      keiner mehr eine Idee?

                      Danke.

                      Gruß

                      Tobi

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