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

    Update auf V0.9.9-1

    Scheduled Pinned Locked Moved Betrieb
    12 Posts 6 Posters 2.5k 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.
    • I Offline
      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 Offline
        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 Offline
          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 Offline
            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 Offline
              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 Offline
                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 Offline
                  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 Offline
                    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 Offline
                      ds
                      last edited by

                      SHOW CREATE TABLE isys_netp_port_2_isys_netp_con

                      bitte

                      1 Reply Last reply Reply Quote 0
                      • S Offline
                        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