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

    Update report manager

    Scheduled Pinned Locked Moved Betrieb
    2 Posts 2 Posters 1.0k 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.
    • H Offline
      hueber
      last edited by

      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__type char(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 232

      Was mir auffällt ist, dass ich gar keine Tabelle isys_report in meiner Datenbank habe.

      Kann mir jemand helfen ?

      Vielen Dank

      1 Reply Last reply Reply Quote 0
      • dsD Offline
        ds
        last edited by

        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 EXISTS isys_report (
          isys_report__id int(32) NOT NULL auto_increment,
          isys_report__title varchar(255) NOT NULL,
          isys_report__description text NOT NULL,
          isys_report__query text NOT NULL,
          isys_report__query_row text NOT NULL,
          isys_report__mandator int(32) NOT NULL,
          isys_report__datetime datetime NOT NULL,
          isys_report__last_edited datetime NOT NULL,
          isys_report__type char(1) NOT NULL,
          PRIMARY KEY  (isys_report__id)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

        Danach müsste das Update ohne Fehler funktionieren

        1 Reply Last reply Reply Quote 0

        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
        • First post
          Last post