Update auf V0.9.9-1

[Ingo01]

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

[dbluemer]

Hallo,

zeig mal bitte

SHOW CREATE TABLE isys_cats_access_point_list;

[Ingo01]

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

[tsaydo]

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

[dbluemer]

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`;

[tsaydo]

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

Danke für die schnelle Hilfe!!

[Ingo01]

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

[tfoks]

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

[ds]

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 ?

[Starko]

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) 

[ds]

SHOW CREATE TABLE isys_netp_port_2_isys_netp_con

bitte

[Starko]

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