ProjeQtOr free project management software - INVALID LOGIN PARAMETERS (LOG FILE) - ProjeQtOr
 

INVALID LOGIN PARAMETERS (LOG FILE)

More
06 Jan 2015 18:19 #1 by eyededji
Hello everyone
First Happy New Year 2015, both for this year.
I return to my invalid connection problem.
I have attached the log file for you to help me.
I think the database is outdated why?


2015-01-06 17:38:38 ***** ERROR ***** Error on SqlElement to get 'loginTry' for Class 'User' : field 'loginTry' not found in Database.
2015-01-06 17:38:38 ***** ERROR ***** Error on SqlElement to get 'apiKey' for Class 'User' : field 'apiKey' not found in Database.
2015-01-06 17:38:38 ***** ERROR ***** Error on SqlElement to get 'dontReceiveTeamMails' for Class 'User' : field 'dontReceiveTeamMails' not found in Database.
2015-01-06 17:38:38 ***** ERROR ***** Error on SqlElement to get 'salt' for Class 'User' : field 'salt' not found in Database.
2015-01-06 17:38:38 ***** ERROR ***** Error on SqlElement to get 'crypto' for Class 'User' : field 'crypto' not found in Database.
2015-01-06 17:38:38 ***** ERROR ***** Error on SqlElement to get 'cookieHash' for Class 'User' : field 'cookieHash' not found in Database.
2015-01-06 17:38:38 ***** ERROR ***** Error on SqlElement to get 'passwordChangeDate' for Class 'User' : field 'passwordChangeDate' not found in Database.
2015-01-06 17:38:38 ***** ERROR ***** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2015-01-06 17:38:38 ***** ERROR ***** For query : desc user
2015-01-06 17:38:38 ***** ERROR ***** Strack trace :
2015-01-06 17:38:38 ***** ERROR ***** #0 Sql->query called at [C:\wamp_BON\www\projeqtor\model\persistence\SqlElement.php:2107]
2015-01-06 17:38:38 ***** ERROR ***** #1 SqlElement->getFormatList called at [C:\wamp_BON\www\projeqtor\model\persistence\SqlElement.php:1875]
2015-01-06 17:38:38 ***** ERROR ***** #2 SqlElement->getDataType called at [C:\wamp_BON\www\projeqtor\model\persistence\SqlElement.php:1412]
2015-01-06 17:38:38 ***** ERROR ***** #3 SqlElement->getSqlElementsFromCriteria called at [C:\wamp_BON\www\projeqtor\tool\loginCheck.php:36]
2015-01-06 17:38:38 ***** ERROR ***** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2015-01-06 17:38:38 ***** ERROR ***** For query : select * from user where user.name='admin' and user.isUser = '1'
2015-01-06 17:38:38 ***** ERROR ***** Strack trace :
2015-01-06 17:38:38 ***** ERROR ***** #0 Sql->query called at [C:\wamp_BON\www\projeqtor\model\persistence\SqlElement.php:1445]
2015-01-06 17:38:38 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [C:\wamp_BON\www\projeqtor\tool\loginCheck.php:36]
2015-01-06 17:38:38 ===== TRACE ===== Login error for user 'admin'


File Attachment:

File Name: projeqtor_...06-2.txt
File Size:2 KB
Attachments:
The topic has been locked.
More
06 Jan 2015 18:48 #2 by babynus
Hi,

Very strange.

First lines (up tu "For query : desc user") seem to show that you run new version on a relatively old and not migrated database.
(fileds that are said to be missing were introduced in V4.0.0.

Last error (\loginCheck.php:36") clearly indicated that you are running V4.4 or below, and not latest V4.5.

The last query error ("select * from user where user.name='admin' and user.isUser = '1'") clearly indicated that current DB version is lower than V3.0.0.
(code run line 32 of loginCheck.php)

So :
1) first, try to clean browser cache and try again : most migration issues are du to copying new code while still connected.
2) also try to clean PHP cache (session files in the temp directory of PHP)
3) if none works, check version of code in /tool/projeqtor.php (content of line $version="V...") and version of database (content of parameterValue for line with parameterCode='dbVersion'). Post both versions here.

Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
Moderators: babynusprotion
Time to create page: 0.031 seconds