Hello
I updated my projeqtor version (8.6.6) to the new version.
After admin login, the update was completed successfully.
The login screen is displayed and I fill in the same login and same password, but this time the application ask me to change the password. I indicate the two textboxes the same new password and I validate and again the same screen that is displayed I cannot go further.
I attach you the logs which indicate that the password has expired.
2020-12-23 20:49:04.273 ===== TRACE =====
2020-12-23 20:49:04.274 ===== TRACE ===== =====================================
2020-12-23 20:49:04.274 ===== TRACE =====
2020-12-23 20:49:04.274 ===== TRACE ===== DataBase actual Version = V8.6.4
2020-12-23 20:49:04.274 ===== TRACE ===== ProjeQtOr actual Version = V9.0.0
2020-12-23 20:49:04.274 ===== TRACE =====
2020-12-23 20:49:04.275 ===== TRACE ===== =====================================
2020-12-23 20:49:04.275 ===== TRACE =====
2020-12-23 20:49:04.275 ===== TRACE ===== VERSION V8.6.5
2020-12-23 20:49:04.276 ===== TRACE =====
2020-12-23 20:49:04.292 ===== TRACE ===== 0 lines updated into table "resource".
2020-12-23 20:49:04.304 ===== TRACE ===== 4 lines updated into table "notifiable".
2020-12-23 20:49:04.305 ===== TRACE =====
2020-12-23 20:49:04.305 ===== TRACE ===== DATABASE UPDATED
2020-12-23 20:49:04.305 ===== TRACE ===== WITH NO ERROR
2020-12-23 20:49:04.305 ===== TRACE =====
2020-12-23 20:49:04.305 ===== TRACE ===== =====================================
2020-12-23 20:49:04.305 ===== TRACE =====
2020-12-23 20:49:04.305 ===== TRACE ===== VERSION V9.0.0
2020-12-23 20:49:04.305 ===== TRACE =====
2020-12-23 20:49:04.345 ===== TRACE ===== Table "navigation" created.
2020-12-23 20:49:04.363 ===== TRACE ===== 283 lines inserted into table "navigation".
2020-12-23 20:49:04.382 ===== TRACE ===== 10 lines updated into table "navigation".
2020-12-23 20:49:04.449 ===== TRACE ===== Table "menucustom" altered.
2020-12-23 20:49:04.452 ===== TRACE ===== 1 lines inserted into table "parameter".
2020-12-23 20:49:04.456 ===== TRACE ===== 22 lines inserted into table "parameter".
2020-12-23 20:49:04.514 ===== TRACE ===== Table "notification" altered.
2020-12-23 20:49:04.523 ===== TRACE ===== 2 lines updated into table "habilitationother".
2020-12-23 20:49:04.530 ===== TRACE ===== 1 lines inserted into table "originable".
2020-12-23 20:49:04.635 ===== TRACE ===== Table "milestone" altered.
2020-12-23 20:49:04.635 ===== TRACE =====
2020-12-23 20:49:04.635 ===== TRACE ===== DATABASE UPDATED
2020-12-23 20:49:04.636 ===== TRACE ===== WITH NO ERROR
2020-12-23 20:49:04.636 ===== TRACE =====
2020-12-23 20:49:06.063 ===== TRACE ===== =====================================
2020-12-23 20:49:06.063 ===== TRACE =====
2020-12-23 20:49:06.064 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V9.0.0
2020-12-23 20:49:06.064 ===== TRACE =====
2020-12-23 20:49:06.064 ===== TRACE ===== =====================================
2020-12-23 20:49:06.064 ===== TRACE =====
2020-12-23 20:49:12.187 ===== TRACE ===== NEW CONNECTED USER 'admin'
2020-12-23 20:49:12.418 ===== TRACE ===== password expired for user 'admin'
2020-12-23 20:49:12.544 ===== TRACE ===== password expired for user 'admin'
I installed a new v9 instance and this time I can connect
logs
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: version in C:wamp64wwwprojeqtorindex.php on line 68
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:wamp64wwwprojeqtorindex.php:0
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: build in C:wamp64wwwprojeqtorindex.php on line 68
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:wamp64wwwprojeqtorindex.php:0
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: version in C:wamp64wwwprojeqtorindex.php on line 69
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:wamp64wwwprojeqtorindex.php:0
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: build in C:wamp64wwwprojeqtorindex.php on line 69
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:wamp64wwwprojeqtorindex.php:0
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: firstColor in C:wamp64wwwprojeqtorindex.php on line 105
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:wamp64wwwprojeqtorindex.php:0
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: version in C:wamp64wwwprojeqtorviewindex.php on line 64
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:wamp64wwwprojeqtorviewindex.php:0
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: build in C:wamp64wwwprojeqtorviewindex.php on line 64
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:wamp64wwwprojeqtorviewindex.php:0
[23-Dec-2020 20:17:53 UTC] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:wamp64wwwprojectboxtoolprojeqtor.php on line 1634
[23-Dec-2020 20:17:53 UTC] PHP Stack trace:
[23-Dec-2020 20:17:53 UTC] PHP 1. {main}() C:wamp64wwwprojectboxviewmain.php:0
[23-Dec-2020 20:17:53 UTC] PHP 2. require_once() C:wamp64wwwprojectboxviewmain.php:37
[23-Dec-2020 20:17:53 UTC] PHP 3. session_start() C:wamp64wwwprojectboxtoolprojeqtor.php:44
[23-Dec-2020 20:17:53 UTC] PHP 4. spl_autoload_call() C:wamp64wwwprojectboxtoolprojeqtor.php:44
[23-Dec-2020 20:17:53 UTC] PHP 5. projeqtorAutoload() C:wamp64wwwprojectboxtoolprojeqtor.php:44
Hi,
It seems you have expired password : you activated the feature to request password change, and something went wrong when updating password.
We'll analyse that point.
Second log show "old" errors we'll also analyse.
Tickets #5129 and #5130 recorded
To fix the password issue, manually change passwordChangeDate in table resource for user admin
You can do this manually (with phpMyAdmin) of with query
update resource set passwordChangeDate = '2020-12-24' where name='admin';
Hello
It is ok now. thank you
Do i need to update the whole table?
Best regards