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

    Update auf V0.9.9-1

    Scheduled Pinned Locked Moved
    Betrieb
    6
    12
    2.4k
    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.
    • I
      Ingo01
      last edited by

      Hallo,

      beim Update kommt folgende Fehlermeldung:

      isys_exception_database : Query error: 'ALTER TABLE isys_cats_access_point_list DROP isys_cats_access_point_list__isys_cats_distributor__id': Error on rename of '.\mandant#sql-190_3e' to '.\mandant\isys_cats_access_point_list' (errno: 150)

      System: Windows XP; PHP 5.3.2; mySQL 5.1.44; Apache 2.2.14

      Gruß Ingo

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

        Hallo,

        zeig mal bitte

        
SHOW CREATE TABLE isys_cats_access_point_list;
        1 Reply Last reply Reply Quote 0
        • I
          Ingo01
          last edited by

          SQL-Abfrageergebnis
          Host: localhost
          Datenbank: mandant
          Erstellungszeit: 08. April 2010 um 14:16
          Erstellt von: phpMyAdmin 3.2.5 / MySQL 5.1.44-community
          SQL-Befehl: SHOW CREATE TABLE isys_cats_access_point_list;
          Zeilen: 1

          Table  Create Table 
          isys_cats_access_point_list CREATE TABLE isys_cats_access_point_list (
          isys_cats_access_point_list__id int(10) unsigned NOT NULL AUTO_INCREMENT,
          isys_cats_access_point_list__isys_obj__id int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__isys_cats_distributor__id int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__isys_wlan_encryption__id int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__isys_wlan_function__id int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__isys_wlan_channel__id int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__isys_wlan_standard__id int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__isys_wlan_auth__id int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__title varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
          isys_cats_access_point_list__description text COLLATE utf8_unicode_ci,
          isys_cats_access_point_list__ssid varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
          isys_cats_access_point_list__key varchar(255) COLLATE utf8_unicode_ci NOT NULL,
          isys_cats_access_point_list__wep int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__wpa int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__psk int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__tkip int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__pbnac int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__encryption int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__cipher int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__broadcast_ssid int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__mac_filter int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__status int(10) unsigned DEFAULT NULL,
          isys_cats_access_point_list__property int(10) unsigned DEFAULT NULL,
          PRIMARY KEY (isys_cats_access_point_list__id),
          KEY isys_cats_access_point_list_FKIndex1 (isys_cats_access_point_list__isys_wlan_standard__id),
          KEY isys_cats_access_point_list_FKIndex2 (isys_cats_access_point_list__isys_wlan_channel__id),
          KEY isys_cats_access_point_list_FKIndex3 (isys_cats_access_point_list__isys_wlan_function__id),
          KEY isys_cats_access_point_list_FKIndex4 (isys_cats_access_point_list__isys_wlan_encryption__id),
          KEY isys_cats_access_point_list__isys_wlan_auth__id (isys_cats_access_point_list__isys_wlan_auth__id),
          KEY isys_cats_access_point_list__i_2 (isys_cats_access_point_list__isys_wlan_auth__id),
          KEY isys_cats_access_point_list__isys_cats_distributor__id (isys_cats_access_point_list__isys_cats_distributor__id),
          KEY isys_cats_access_point_list__isys_obj__id (isys_cats_access_point_list__isys_obj__id),
          CONSTRAINT isys_cats_access_point_list_ibfk_10 FOREIGN KEY (isys_cats_access_point_list__isys_wlan_channel__id) REFERENCES isys_wlan_channel (isys_wlan_channel__id) ON DELETE SET NULL ON UPDATE CASCADE,
          CONSTRAINT isys_cats_access_point_list_ibfk_11 FOREIGN KEY (isys_cats_access_point_list__isys_wlan_standard__id) REFERENCES isys_wlan_standard (isys_wlan_standard__id) ON DELETE SET NULL ON UPDATE CASCADE,
          CONSTRAINT isys_cats_access_point_list_ibfk_12 FOREIGN KEY (isys_cats_access_point_list__isys_wlan_auth__id) REFERENCES isys_wlan_auth (isys_wlan_auth__id) ON DELETE SET NULL ON UPDATE CASCADE,
          CONSTRAINT isys_cats_access_point_list_ibfk_6 FOREIGN KEY (isys_cats_access_point_list__isys_cats_distributor__id) REFERENCES idoit_data.isys_cats_distributor (isys_cats_distributor__id),
          CONSTRAINT isys_cats_access_point_list_ibfk_7 FOREIGN KEY (isys_cats_access_point_list__isys_obj__id) REFERENCES isys_obj (isys_obj__id) ON DELETE CASCADE ON UPDATE CASCADE,
          CONSTRAINT isys_cats_access_point_list_ibfk_8 FOREIGN KEY (isys_cats_access_point_list__isys_wlan_encryption__id) REFERENCES isys_wlan_encryption (isys_wlan_encryption__id) ON DELETE SET NULL ON UPDATE CASCADE,
          CONSTRAINT isys_cats_access_point_list_ibfk_9 FOREIGN KEY (isys_cats_access_point_list__isys_wlan_function__id) REFERENCES isys_wlan_function (isys_wlan_function__id) ON DELETE SET NULL ON UPDATE CASCADE
          ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

          Gruß Ingo

          1 Reply Last reply Reply Quote 0
          • T
            tsaydo
            last edited by

            Hallo, bekomme wohl die gleiche Fehlermeldung:

            isys_exception_database : Query error: 'ALTER TABLE isys_cats_access_point_list DROP isys_cats_access_point_list__isys_cats_distributor__id': Error on rename of '.\idoit_data_mp#sql-110_63' to '.\idoit_data_mp\isys_cats_access_point_list' (errno: 150)

            Ist schon eine Lösung in Sicht??

            Viele Grüße aus Frankfurt

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

              Bitte folgendes Statement ausführen und dann nochmal versuchen:

              
ALTER TABLE `isys_cats_access_point_list` DROP FOREIGN KEY `isys_cats_access_point_list_ibfk_6`;
              1 Reply Last reply Reply Quote 0
              • T
                tsaydo
                last edited by

                P R I M A  🙂
                Ihr seit die GRÖSSTEN !!

                Danke für die schnelle Hilfe!!

                1 Reply Last reply Reply Quote 0
                • I
                  Ingo01
                  last edited by

                  Da kamen noch 2 Meldungen:

                  isys_exception_database : Query error: 'SELECT * FROM isysgui_subcat ORDER BY isysgui_subcat__sort;': Table 'mandant.isysgui_subcat' doesn't exist

                  isys_exception_rs : RS Exception: Can't check for right, since right module 2 is not registered!

                  Das Update ist durch…

                  Dann werde ich mal testen...

                  Vielen Dank!

                  Gruß Ingo

                  1 Reply Last reply Reply Quote 0
                  • T
                    tfoks
                    last edited by

                    Hallo,
                    ich erhalte beim Update der Mandanten folgenden Fehler:

                    isys_exception_database : Query error: 'ALTER TABLE isys_catg_ip_list_2_isys_netp_port CHANGE isys_catg_ip_list_2_isys_netp_port__isys_catg_ip_list__id isys_catg_ip_list_2_isys_catg_port_list__isys_catg_ip_list__id INT( 10 ) UNSIGNED NOT NULL , CHANGE isys_catg_ip_list_2_isys_netp_port__isys_netp_port__id isys_catg_ip_list_2_isys_catg_port_list__isys_catg_port_list__id INT( 10 ) UNSIGNED NOT NULL': Error on rename of './idoit_gfac/#sql-bc4_40ec' to './idoit_gfac/isys_catg_ip_list_2_isys_netp_port' (errno: 150)

                    Wie läßt sich das fixen?

                    Gruss,
                    Thomas

                    1 Reply Last reply Reply Quote 0
                    • dsD
                      ds
                      last edited by

                      Bitte auch einmal das Ergebnis von

                      SHOW CREATE TABLE isys_catg_ip_list_2_isys_netp_port;

                      hier anhängen. Gab es beim Update auf die 0.9.9 Probleme mit diesem Mandanten ?

                      1 Reply Last reply Reply Quote 0
                      • S
                        Starko
                        last edited by

                        Ich habe auch Probleme beim Update…

                        isys_exception_database : Query error: 'ALTER TABLE `isys_netp_port_2_isys_netp_con` DROP FOREIGN KEY `isys_netp_port_2_isys_netp_con_ibfk_3`': Error on rename of './mandant/isys_netp_port_2_isys_netp_con' to './mandant/#sql2-763-69' (errno: 152)
                        1 Reply Last reply Reply Quote 0
                        • dsD
                          ds
                          last edited by

                          SHOW CREATE TABLE isys_netp_port_2_isys_netp_con

                          bitte

                          1 Reply Last reply Reply Quote 0
                          • S
                            Starko
                            last edited by

                            CREATE TABLE isys_netp_port_2_isys_netp_con (
                            isys_netp_port_2_isys_netp_con__id int(10) unsigned NOT NULL auto_increment,
                            isys_netp_port_2_isys_netp_con__isys_netp_port__id int(10) unsigned NOT NULL default '0',
                            isys_netp_port_2_isys_netp_con__isys_netp_con__id int(10) unsigned NOT NULL default '0',
                            PRIMARY KEY  (isys_netp_port_2_isys_netp_con__id),
                            KEY isys_netp_port_2_isys_netp_con__isys_netp_port__id (isys_netp_port_2_isys_netp_con__isys_netp_port__id),
                            KEY isys_netp_port_2_isys_netp_con__isys_netp_con__id (isys_netp_port_2_isys_netp_con__isys_netp_con__id),
                            CONSTRAINT isys_netp_port_2_isys_netp_con_ibfk_1 FOREIGN KEY (isys_netp_port_2_isys_netp_con__isys_netp_con__id) REFERENCES isys_netp_con (isys_netp_con__id) ON DELETE CASCADE
                            ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

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