Database - class mismatch

I have installed the current stable release (4.5.6) on ubuntu trusty and all looked to go fine, but when trying to login as admin/admin the webpage returns "invalid login parameters". Looking at the logs, it's requesting the table "user" but the users are in the table "resource". This looks like a bug to me, but maybe it's influenced by some configs? Would someone be able to help me?

2015-03-12 17:54:21 ***** ERROR ***** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2015-03-12 17:54:21 ***** ERROR ***** For query : desc user
2015-03-12 17:54:21 ***** ERROR ***** Strack trace :
2015-03-12 17:54:21 ***** ERROR ***** #0 Sql->query called at [/scratch/localwebs/projeqtor/model/persistence/SqlElement.php:2195]
2015-03-12 17:54:21 ***** ERROR ***** #1 SqlElement->getFormatList called at [/scratch/localwebs/projeqtor/model/persistence/SqlElement.php:1952]
2015-03-12 17:54:21 ***** ERROR ***** #2 SqlElement->getDataType called at [/scratch/localwebs/projeqtor/model/persistence/SqlElement.php:1484]
2015-03-12 17:54:21 ***** ERROR ***** #3 SqlElement->getSqlElementsFromCriteria called at [/scratch/localwebs/projeqtor/tool/loginCheck.php:61]
2015-03-12 17:54:21 ***** ERROR ***** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2015-03-12 17:54:21 ***** ERROR ***** For query : select * from user where user.name='admin' and user.isUser = '1'
2015-03-12 17:54:21 ***** ERROR ***** Strack trace :
2015-03-12 17:54:21 ***** ERROR ***** #0 Sql->query called at [/scratch/localwebs/projeqtor/model/persistence/SqlElement.php:1517]
2015-03-12 17:54:21 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/scratch/localwebs/projeqtor/tool/loginCheck.php:61]
2015-03-12 17:54:21 ===== TRACE ===== Login error for user 'admin'

Trying again with a different browser gives the same result. I have dbVersion V0.3.0

Perfect! Login accepted.

I do have a few errors from the very beginning of the first run, which I assumed was the system attempting to run, then catching the error, and setting up the db. Some errors below are repeated, the log continues to trace the db creation, updating for each version (up to 4.5.6), then rewriting parameters.php

Let me know if having the whole log file is of help to you.

Thanks for the help.


2015-03-12 17:30:36 ***** ERROR ***** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2015-03-12 17:30:36 ***** ERROR ***** For query : select * from parameter where (idUser is null and idProject is null)
2015-03-12 17:30:36 ***** ERROR ***** Strack trace :
2015-03-12 17:30:36 ***** ERROR ***** #0 Sql->query called at [/scratch/localwebs/projeqtor/model/persistence/SqlElement.php:1517]
2015-03-12 17:30:36 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/scratch/localwebs/projeqtor/model/Parameter.php:572]
2015-03-12 17:30:36 ***** ERROR ***** #2 Parameter->getGlobalParameter called at [/scratch/localwebs/projeqtor/view/login.php:55]
2015-03-12 17:30:36 ***** ERROR ***** #3 include called at [/scratch/localwebs/projeqtor/tool/projeqtor.php:162]
2015-03-12 17:30:36 ***** ERROR ***** #4 require_once called at [/scratch/localwebs/projeqtor/view/main.php:36]
2015-03-12 17:31:18 ***** ERROR ***** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.resource' doesn't exist
2015-03-12 17:31:18 ***** ERROR ***** For query : desc resource
2015-03-12 17:31:18 ***** ERROR ***** Strack trace :
2015-03-12 17:31:18 ***** ERROR ***** #0 Sql->query called at [/scratch/localwebs/projeqtor/model/persistence/SqlElement.php:2195]
2015-03-12 17:31:18 ***** ERROR ***** #1 SqlElement->getFormatList called at [/scratch/localwebs/projeqtor/model/persistence/SqlElement.php:1952]
2015-03-12 17:31:18 ***** ERROR ***** #2 SqlElement->getDataType called at [/scratch/localwebs/projeqtor/model/persistence/SqlElement.php:1484]
2015-03-12 17:31:18 ***** ERROR ***** #3 SqlElement->getSqlElementsFromCriteria called at [/scratch/localwebs/projeqtor/model/persistence/SqlElement.php:1658]
2015-03-12 17:31:18 ***** ERROR ***** #4 SqlElement->getSingleSqlElementFromCriteria called at [/scratch/localwebs/projeqtor/tool/getHash.php:39]
2015-03-12 17:31:18 ***** ERROR ***** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.resource' doesn't exist
2015-03-12 17:31:18 ***** ERROR ***** For query : select * from resource where resource.name='admin' and resource.isUser = '1'
2015-03-12 17:31:18 ***** ERROR ***** Strack trace :
2015-03-12 17:31:18 ***** ERROR ***** #0 Sql->query called at [/scratch/localwebs/projeqtor/model/persistence/SqlElement.php:1517]
2015-03-12 17:31:18 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/scratch/localwebs/projeqtor/model/persistence/SqlElement.php:1658]
2015-03-12 17:31:18 ***** ERROR ***** #2 SqlElement->getSingleSqlElementFromCriteria called at [/scratch/localwebs/projeqtor/tool/getHash.php:39]
2015-03-12 17:31:18 ===== TRACE =====
2015-03-12 17:31:18 ===== TRACE ===== =====================================
2015-03-12 17:31:18 ===== TRACE =====
2015-03-12 17:31:18 ===== TRACE ===== DataBase actual Version =
2015-03-12 17:31:18 ===== TRACE ===== ProjeQtOr actual Version = V4.5.6
2015-03-12 17:31:18 ===== TRACE =====
2015-03-12 17:31:18 ===== TRACE ===== =====================================
2015-03-12 17:31:18 ===== TRACE =====
2015-03-12 17:31:18 ===== TRACE ===== VERSION V0.3.0
2015-03-12 17:31:18 ===== TRACE =====
2015-03-12 17:31:18 ===== TRACE ===== Table "accessprofile" created.
2015-03-12 17:31:18 ===== TRACE ===== 9 lines inserted into table "accessprofile".
...