Update report manager
-
Hallo zusammen,
beim Update auf die Version 0.9.3-boxed schlägt der Datenbankupdate fehl.
Folgende Fehlermeldung kommt.Fatal error: Uncaught Exception occured in (/srv/www/htdocs/i-doit/src/classes/components/isys_component_dao.class.php:232): isys_exception_dao : DAO Exception: Running transaction has been canceled. Could not isys_component_dao::update() : ALTER TABLE isys_report ADD
isys_report__typechar(1) NOT NULL
MySQL-Error: (Extended Information: 0) thrown in /srv/www/htdocs/i-doit/src/classes/components/isys_component_dao.class.php on line 232Was mir auffällt ist, dass ich gar keine Tabelle isys_report in meiner Datenbank habe.
Kann mir jemand helfen ?
Vielen Dank
-
Die Report Tabelle sollte eigentlich Bestandteil des Updates sein
Hier der SQL Befehl für isys_report:
DROP TABLE IF EXISTS
isys_report;
CREATE TABLE IF NOT EXISTSisys_report(
isys_report__idint(32) NOT NULL auto_increment,
isys_report__titlevarchar(255) NOT NULL,
isys_report__descriptiontext NOT NULL,
isys_report__querytext NOT NULL,
isys_report__query_rowtext NOT NULL,
isys_report__mandatorint(32) NOT NULL,
isys_report__datetimedatetime NOT NULL,
isys_report__last_editeddatetime NOT NULL,
isys_report__typechar(1) NOT NULL,
PRIMARY KEY (isys_report__id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;Danach müsste das Update ohne Fehler funktionieren
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login