Hi
I've just installed ProjQtor.
When I fill login admin and password admin on the login page, I get the message " Invalid login parameters".
I've found these lines in the logs :
2015-01-12 14:11:17 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2015-01-12 14:11:17 ** ERROR ** For query : desc user
2015-01-12 14:11:17 ** ERROR ** Strack trace :
2015-01-12 14:11:17 ** ERROR ** #0 Sql->query called at [C:inetpubwwwrootPROJEQTORmodelpersistenceSqlElement.php:2146]
2015-01-12 14:11:17 ** ERROR ** #1 SqlElement->getFormatList called at [C:inetpubwwwrootPROJEQTORmodelpersistenceSqlElement.php:1908]
2015-01-12 14:11:17 ** ERROR ** #2 SqlElement->getDataType called at [C:inetpubwwwrootPROJEQTORmodelpersistenceSqlElement.php:1440]
2015-01-12 14:11:17 ** ERROR ** #3 SqlElement->getSqlElementsFromCriteria called at [C:inetpubwwwrootPROJEQTORtoolloginCheck.php:61]
2015-01-12 14:11:17 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2015-01-12 14:11:17 ** ERROR ** For query : select * from user where user.name='admin' and user.isUser = '1'
2015-01-12 14:11:17 ** ERROR ** Strack trace :
2015-01-12 14:11:17 ** ERROR ** #0 Sql->query called at [C:inetpubwwwrootPROJEQTORmodelpersistenceSqlElement.php:1473]
2015-01-12 14:11:17 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [C:inetpubwwwrootPROJEQTORtoolloginCheck.php:61]
2015-01-12 14:11:17 ===== TRACE ===== Login error for user 'admin'
Thanks for your help.
MB
Try and clean browser cache and try again.
Tell us about the result.
Thanks.
Thanks for your answer :
I cleaned the cache of the browser and retried, but the result is the same : "Invalid login parameters".
I've tried in other browsers too, and I get the same sesult.
Hi all,
reading the log file, I saw it didn't find user db. May be database is not set up properly.
Klaus
Which version did you install ?
On which on ?
What is version in /tool/projeqtor.php ? ($version, line 35)
What is version in database ? (value of column parameterValue in table parameter, line with parameterCode='dbVersion')
Try and clean browser cache and try again.
Which version did you install ?
On which on ?
What is version in /tool/projeqtor.php ? ($version, line 35) I found this in projeqtor.php :"$version="V4.2.2"];
What is version in database ? (value of column parameterValue in table parameter, line with parameterCode='dbVersion') I found this for the DB version : dbVersion V0.3.0
Thanks for your help
Hi,
You really have a big issue on your Database.
Setup was really uncomplete, and database schema does not fit code version.
For information you should have same version on projeqtor.php and database.
What is very strange is that database is in version 0.3.0.
It means only the first update script was run. But if you had had an error, database version should not have been set at all (it is the last ting that is done) and it is set from code version.
All appears as if you installed old V0.3.0 and then try to run V4.2.2 code... :silly:
Best for you is to start from scratch : delete your database and try again.
This time, ensure you have all required scripts in /db folder, with correct access rights.
Regards.
Ok, thanks : I will restard from scratch.
Other hints :
- before starting reinstall, clean your log file (delete it) and post whole file directly in forum for analysis
- check that your php is not is safe mode : it would prevent set_time_limit from working and could lead to unexpected end.
- try and install latest stable release : V4.5.4
Ok, I've taken the last version.
Where is the log file (in which directory) please ?
in /files/logs (by default).
This can be changed on setup, but for first install keep it there (you'll be able to move it afterwards).
I've re-installed and got the same problem : "Invalid login parameters" with login / pwd admin / admin.
The version in projeqtor.php is 4.5.4.
There are 128 tables in the db, and the db version in table parameter / dbversion is 3.0.
I got it thnaks ot the log file :woohoo:
It appears you are using IIS as PHP serveur.
And there seems to be an issue with IIS : $_SERVER['SCRIPT_FILENAME'] is not set.
I will investigate on this side (Ticket #1641 recorded)
On your side, database upgrade seems correct, except for db version.
Try and update version in database (to fit code version) and try again.