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'
The table user was renamed as resource to provide PotgreSql compatibility (user is a Pgsql reserved word)
But there is a macanism to manage transition.
Could you please :
- try again with brand new session (clean browser cache, close browser, try again)
- indicate conter of parameter table for line where parameterCode = 'dbVersion'
Thanks.
Trying again with a different browser gives the same result. I have dbVersion V0.3.0
Hi,
Check log file of installation.
If all went right up to the end, just change dbVersion to V4.5.6, this will fix issue.
Otherwise, try and drop all tables and try again (tables will be re-created).
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".
...
Hi,
You're perfectly right, you don't have to bother with first lgged errors (they will be hidden in V5.0 to be more clean).
If you don't have error after forts log of database update, it's perfect.