Hello,

On a new install (new MySQL database, new installation directory, version 4.1.2 on Unix OS) we have an error in log when connnecting to ProjeQtOr.

2014-02-11 10:44:41 ===== TRACE ===== NEW CONNECTED USER 'xxxxx'
2014-02-11 10:44:43 ** ERROR ** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'TestSession.id' in 'where clause'
2014-02-11 10:44:43 ** ERROR ** For query : select * from testsession where (exists (select 'x' from assignment x where x.refType='TestSession'
and x.refId=TestSession.id and x.idResource='5')) and idle=0 and done=0 LIMIT 101
2014-02-11 10:44:43 ** ERROR ** Strack trace :
2014-02-11 10:44:43 ** ERROR ** #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1285]
2014-02-11 10:44:43 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:418]
2014-02-11 10:44:43 ** ERROR ** #2 showActivitiesList called at [/var/www/projeqtor/view/today.php:342]
2014-02-11 10:44:43 ** ERROR ** #3 showAssignedTasks called at [/var/www/projeqtor/view/today.php:597]
2014-02-11 10:44:43 ** ERROR ** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Meeting.id' in 'where clause'
2014-02-11 10:44:43 ** ERROR ** For query : select * from meeting where (exists (select 'x' from assignment x where x.refType='Meeting' and x.re
fId=Meeting.id and x.idResource='5')) and idle=0 and done=0 LIMIT 101
2014-02-11 10:44:43 ** ERROR ** Strack trace :
2014-02-11 10:44:43 ** ERROR ** #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1285]
2014-02-11 10:44:43 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:421]
2014-02-11 10:44:43 ** ERROR ** #2 showActivitiesList called at [/var/www/projeqtor/view/today.php:342]
2014-02-11 10:44:43 ** ERROR ** #3 showAssignedTasks called at [/var/www/projeqtor/view/today.php:597]

We have disabled every authorization to "Tests" module.

Problem seems to be case sensitive (TestSession.id instead of testsession.id).

With a MySQL client :

mysql> select * from testsession where (exists (select 'x' from assignment x where x.refType='TestSession' and x.refId=TestSession.id and x.idResource='5')) and idle=0 and done=0 LIMIT 101;
ERROR 1054 (42S22): Unknown column 'TestSession.id' in 'where clause'

mysql> select * from testsession where (exists (select 'x' from assignment x where x.refType='TestSession' and x.refId=testsession.id and x.idResource='5')) and idle=0 and done=0 LIMIT 101;
Empty set (0.01 sec)

Regards,

Lionel