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

    Update auf V0.9.9-1

    Scheduled Pinned Locked Moved Betrieb
    12 Posts 6 Posters 2.4k Views
    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.
    • 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