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

    Database problem

    Scheduled Pinned Locked Moved Operating
    4 Posts 3 Posters 2.6k 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.
    • D Offline
      drilox
      last edited by

      I, have installed the SVN and .tar.gz last versions and always after the installation and first login using admin,admin i received this message:

      isys_exception_database : Query error: 'SELECT * FROM isys_person_intern LEFT JOIN isys_group_2_isys_person_intern ON isys_group_2_isys_person_intern__isys_person_intern__id = isys_person_intern__id LEFT JOIN isys_group ON isys_group_2_isys_person_intern__isys_group__id = isys_group__id WHERE 1 AND (isys_person_intern__status = C__RECORD_STATUS__NORMAL) AND (isys_person_intern__id = '1') GROUP BY isys_person_intern__id ;': Unknown column 'C__RECORD_STATUS__NORMAL' in 'where clause' (Extended Information: array ( 'server' => '5.0.45-Debian_1ubuntu3-log', 'host' => '127.0.0.1 via TCP/IP', 'client' => '5.0.45', 'proto' => 10, ))

      Fatal error: Uncaught Exception occured in (/var/www/i-doit/src/classes/components/isys_component_dao.class.php:182): isys_exception_dao : DAO Exception: Could not retrieve: SELECT * FROM isys_person_intern LEFT JOIN isys_group_2_isys_person_intern ON isys_group_2_isys_person_intern__isys_person_intern__id = isys_person_intern__id LEFT JOIN isys_group ON isys_group_2_isys_person_intern__isys_group__id = isys_group__id WHERE 1 AND (isys_person_intern__status = C__RECORD_STATUS__NORMAL) AND (isys_person_intern__id = '1') GROUP BY isys_person_intern__id ; (Extended Information: 0) thrown in /var/www/i-doit/src/classes/components/isys_component_dao.class.php on line 182

      any clues?

      1 Reply Last reply Reply Quote 0
      • N Offline
        npotthast
        last edited by

        Did you remember to also update the databases?
        Which version was your initial i-doit version? What updates, patches did you install?

        MfG,
        Niclas Potthast

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

          Looks like the constant manager cannot write the essential i-doit cache files.

          I think you've got a problem with the file-system rights on the i-doit temp folders.
          Try the script "idoit-rights.sh" in the i-doit root directory, which will set the rights automatically:

          
cd /var/www/i-doit
chmod +x idoit-rights.sh
./idoit-rights.sh unset
          1 Reply Last reply Reply Quote 0
          • D Offline
            drilox
            last edited by

            that's it! running the idoit-rights.sh script solved the problem.

            i'm able to login now.

            thx a lot

            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