Database problem
-
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?
-
Did you remember to also update the databases?
Which version was your initial i-doit version? What updates, patches did you install? -
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 -
