Fehler beim editieren Schrank

_Chekov_

Hi,

ich bekomme folgende fehler mit i-doit v0.9.3 Revision 3480:

isys_exception_dao > Running transaction has been canceled. Could not isys_component_dao::update() : MySQL-Error: Unknown column 'isys_catg_formfactor_list__installation_height' in 'field list' Query: UPDATE isys_catg_formfactor_list SET isys_catg_formfactor_list__installation_height = '0.000000000000000000000000000000', isys_catg_formfactor_list__installation_depth = '0.000000000000000000000000000000', isys_catg_formfactor_list__installation_width = '0.000000000000000000000000000000', isys_catg_formfactor_list__isys_catg_formfactor_type__id = NULL, isys_catg_formfactor_list__isys_depth_unit__id = '1', isys_catg_formfactor_list__rackunits = '42' WHERE (isys_catg_formfactor_list__id = '1');

Noch was: beim anlagen eine neue Schrank, bekomme ich auch:

Could not display category: Schrank - Theres a distribution problem.

und beim speichern eine neue Schrank:

Exception occurred:

isys_exception_dao > Running transaction has been canceled. Could not isys_component_dao::update() : MySQL-Error: Unknown column 'isys_catg_formfactor_list__installation_height' in 'field list' Query: UPDATE isys_catg_formfactor_list SET isys_catg_formfactor_list__installation_height = '', isys_catg_formfactor_list__installation_depth = '', isys_catg_formfactor_list__installation_width = '', isys_catg_formfactor_list__isys_catg_formfactor_type__id = NULL, isys_catg_formfactor_list__isys_depth_unit__id = '1', isys_catg_formfactor_list__status = '2', isys_catg_formfactor_list__rackunits = NULL WHERE (isys_catg_formfactor_list__id = '30');

Trotzdem eine neue Schrank wird generiert.

Cheers,

Chekov

ds

Das Feld "isys_catg_formfactor_list__installation_height" aus der Tabelle isys_catg_formfactor_list wurde aufgrund eines Rechtschreibfehlers umbenannt. Im aktuellen Update-Script sollte die Änderung enthalten sein.

_Chekov_

Hi,

ich habe gerade v0.9.3 Revision 3483 herunterladen und bin mit http://idoit/updates
auch durch. Trotzdem kommt das gleiche Fehler mit Schrank.

Wie aktualisiere ich den Datenbank?

Cheers,

Chekov

ds

Über /updates ist richtig.
Zeig mir mal bitte die letzten 50 Zeilen aus dem idoit-update.log im /temp Verzeichnis

_Chekov_

Hi,

hier die letzten 50 Zeilen aus die logfile:

2008-10-13 12:10:21: Checking :: SHOW TABLES LIKE 'isys_container';
2008-10-13 12:10:21: Result :: False
2008-10-13 12:10:21: Creating table isys_container.. Table already existing.
2008-10-13 12:10:21: –
2008-10-13 12:10:21: Checking :: SHOW COLUMNS FROM isys_dependency WHERE (Field = 'isys_dependency__datetime')
2008-10-13 12:10:21: Result :: False
2008-10-13 12:10:21: Adding field isys_dependency__datetime to table isys_dependency.. Already exists.
2008-10-13 12:10:21: –
2008-10-13 12:10:21: Checking :: SHOW COLUMNS FROM isys_catg_global_list WHERE (Field = 'isys_catg_global_list__isys_contact__id')
2008-10-13 12:10:21: Result :: False
2008-10-13 12:10:21: Adding field isys_catg_global_list__isys_contact__id to table isys_catg_global_list.. Already exists.
2008-10-13 12:10:21: –
2008-10-13 12:10:21: Checking :: SHOW COLUMNS FROM isys_contact_data_item WHERE (Field = 'isys_contact_data_item__isys_organisation_intern_iop__id')
2008-10-13 12:10:21: Result :: False
2008-10-13 12:10:21: Adding field isys_contact_data_item__isys_organisation_intern_iop__id to table isys.. Already exists.
2008-10-13 12:10:21: –
2008-10-13 12:10:21: Checking :: SHOW COLUMNS FROM isys_catg_global_list WHERE (Field = 'isys_catg_global_list__order_no')
2008-10-13 12:10:21: Result :: False
2008-10-13 12:10:21: Adding field isys_catg_global_list__order_no to table isys_catg_global_list.. Already exists.
2008-10-13 12:10:21: –
2008-10-13 12:10:21: Checking :: SHOW COLUMNS FROM isys_catg_formfactor_list WHERE (Field = 'isys_catg_formfactor_list__installation_hight')
2008-10-13 12:10:21: Result :: False
2008-10-13 12:10:21: Changing field isys_catg_formfactor_list__installation_hight in table isys_catg_for.. Changed.
2008-10-13 12:10:21: –
2008-10-13 12:10:21: Checking :: SHOW TABLES LIKE 'isys_logbook_archive';
2008-10-13 12:10:21: Result :: True
2008-10-13 12:10:21: Creating table isys_logbook_archive.. Created.
2008-10-13 12:10:21: –
2008-10-13 12:10:21: Checking ::
SELECT * FROM isys_logbook_archive;

2008-10-13 12:10:21: Result :: False
2008-10-13 12:10:21: Updating value.. Value(s) inserted.
2008-10-13 12:10:21: Copying files to /var/www/idoit-svn/trunk..
2008-10-13 12:10:21: Source-Directory: /var/www/idoit-svn/trunk/updates/versions/v0.9.3-rX/files/
2008-10-13 12:10:21: –
2008-10-13 12:10:21: Deleting files
2008-10-13 12:10:21: No files to delete this time
2008-10-13 12:10:21: Applying config file
2008-10-13 12:10:21: Backing up config: /var/www/idoit-svn/trunk/src/config.inc.php
2008-10-13 12:10:21: to: /var/www/idoit-svn/trunk/src/config.inc.php.20081013121021
2008-10-13 12:10:21: Backing up old config
2008-10-13 12:10:21: Creating new one
2008-10-13 12:10:21: Writing config to /var/www/idoit-svn/trunk/src/config.inc.php
2008-10-13 12:10:21: –
2008-10-13 12:10:21: Deleting temp directories..
2008-10-13 12:10:21: Used-Temp directory: /var/www/idoit-svn/trunk/temp/
2008-10-13 12:10:21: Done. Deleted 7 temp files.
2008-10-13 12:10:21: –

Cheers,

Chekov

ds

OK, in dem Update war die Änderung mit der Tabelle nicht drin.
Sollte eigentlich nach:
[2008-10-13 12:10:21]: Checking :: SELECT * FROM isys_logbook_archive; ..
kommen.

_Chekov_

Hi,

wird die Fehler in den kommenden Revisionen gehoben?

Cheers,

Chekov