If server has no internet connection to access outside resources, disable curl php module
or set parameter "getVersion" to "NO" (either change value in table parameter or enter new value in parameters.pgp ($getVersion='NO';)
Unfortunately this doesn't help...
Like php.ini --> allow_url_fopen=off the change of "getVersion" to No in the table parmameter just made the errormessage in the news section disapear.
But the left Menu didn't appear.
It is still hidden empty below "Menu search" and it doesn't matter what i click on the left side or if i show/hide the menu.
The links to the favorites are still working, but there i have also no access to the fault log, because i didn't put the administration in my favorites...
Any error in log file ?
Or in browser console ?
Strange behaviour...
I loaded the snapshot with V9.3.1 before the upgrade to V9.3.2 again and discovered that when i logged in (Username replaced with BlaAdmin), that the menu left was already vanished before the upgrade...
The last entry in the log ( 2021-10-15) was when i tested to the gantt issues with the "special user" (see my other post in the forum, userneame in the Log changed to Bla_guest) and then i didn't login again...
So today (2021-10-22) i logged in with the Adminaccount (BlaAdmin) and menu left did not show the content.
I Logged out, and logged in with the user (Bla_guest), this showed the menu, I logged out again, then logged in with the Admin (BlaAdmin) and the menu left was shown again.
After that i loaded an older snapshot with V9.2.2 and directly updgrade to V9.3.2 which was ok (so it has nothing to do with the upgrade process....)
The "recovery process" worked also with the snapshot of V9.3.2 which didn't show the menu left content.
Cookie problem ?!
After i tested this with Firefox i couldn't reproduce it after a certain time (in the beginning i could load different versions and simulate with different versions etc. ) but now when i go back it doesn't appear again.
But with the Edge browser where I had the same issue and did not play and login logout, i still have it (at the same time with Firefox i don't).
Here is the log with V9.3.1 (replaced // with \ in the log, otherwise it complaint of too many links)
2021-10-15 17:22:15.025 ----- DEBUG ----- loginCheck : current db version = 'V9.3.0'
2021-10-15 17:22:15.045 ----- DEBUG ----- User->authenticate('BlaAdmin', '23af4c11bd5b442979e14d2bc2ced6ecc79b62fc2d69b8b71c25c3e019d9b2d3')
2021-10-15 17:22:15.050 ----- DEBUG ----- User->authenticate : sha256 encryption
2021-10-15 17:22:15.050 ----- DEBUG ----- User->authenticate : Successfull login
2021-10-15 17:22:15.063 ===== TRACE =====
2021-10-15 17:22:15.063 ===== TRACE ===== =====================================
2021-10-15 17:22:15.063 ===== TRACE =====
2021-10-15 17:22:15.063 ===== TRACE ===== DataBase actual Version = V9.3.0
2021-10-15 17:22:15.063 ===== TRACE ===== ProjeQtOr actual Version = V9.3.1
2021-10-15 17:22:15.063 ===== TRACE =====
2021-10-15 17:22:15.065 ===== TRACE ===== =====================================
2021-10-15 17:22:15.065 ===== TRACE =====
2021-10-15 17:22:15.065 ===== TRACE ===== VERSION V9.3.1
2021-10-15 17:22:15.065 ===== TRACE =====
2021-10-15 17:22:15.072 ===== TRACE ===== 2 lines updated into table "reportparameter".
2021-10-15 17:22:15.072 ===== TRACE =====
2021-10-15 17:22:15.072 ===== TRACE ===== DATABASE UPDATED
2021-10-15 17:22:15.072 ===== TRACE ===== WITH NO ERROR
2021-10-15 17:22:15.072 ===== TRACE =====
2021-10-15 17:22:17.299 ===== TRACE ===== =====================================
2021-10-15 17:22:17.299 ===== TRACE =====
2021-10-15 17:22:17.299 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V9.3.1
2021-10-15 17:22:17.299 ===== TRACE =====
2021-10-15 17:22:17.299 ===== TRACE ===== =====================================
2021-10-15 17:22:17.299 ===== TRACE =====
2021-10-15 17:22:28.078 ----- DEBUG ----- loginCheck : current db version = 'V9.3.1'
2021-10-15 17:22:28.094 ----- DEBUG ----- User->authenticate('BlaAdmin', 'efd49066e46af061996470b0c30909f768a12a8e0482f8c77a5785ea97ac4965')
2021-10-15 17:22:28.101 ----- DEBUG ----- User->authenticate : sha256 encryption
2021-10-15 17:22:28.101 ----- DEBUG ----- User->authenticate : Successfull login
2021-10-15 17:22:28.378 ===== TRACE ===== NEW CONNECTED USER 'BlaAdmin'
2021-10-15 17:22:29.471 ===== TRACE ===== Cannot check Version at http:\projeqtor.org/admin/getVersion.php
2021-10-15 17:22:29.471 ===== TRACE ===== Maybe allow_url_fopen is Off in php.ini...
2021-10-15 17:23:51.829 ===== TRACE ===== DISCONNECTED USER 'BlaAdmin'
2021-10-15 17:24:02.080 ----- DEBUG ----- loginCheck : current db version = 'V9.3.1'
2021-10-15 17:24:02.097 ----- DEBUG ----- User->authenticate('BlaAdmin', 'b9d2ca2d17afb771fe307ddc0bfb1595ffdd29c83abee9192deed8e97fc5151f')
2021-10-15 17:24:02.102 ----- DEBUG ----- User->authenticate : sha256 encryption
2021-10-15 17:24:02.102 ----- DEBUG ----- User->authenticate : Successfull login
2021-10-15 17:24:02.343 ===== TRACE ===== NEW CONNECTED USER 'BlaAdmin'
2021-10-15 17:24:03.364 ===== TRACE ===== Cannot check Version at http:\projeqtor.org/admin/getVersion.php
2021-10-15 17:24:03.365 ===== TRACE ===== Maybe allow_url_fopen is Off in php.ini...
2021-10-15 17:25:17.919 ** ERROR ** [V9.3.1] ERROR **
2021-10-15 17:25:17.920 ** ERROR ** [V9.3.1] on file '/var/www/projeqtor/view/refreshLastNews.php' at line (62)
2021-10-15 17:25:17.920 ** ERROR ** [V9.3.1] cause = file_get_contents(): php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution
2021-10-15 17:25:29.898 ** ERROR ** [V9.3.1] ERROR **
2021-10-15 17:25:29.898 ** ERROR ** [V9.3.1] on file '/var/www/projeqtor/view/refreshLastNews.php' at line (62)
2021-10-15 17:25:29.898 ** ERROR ** [V9.3.1] cause = file_get_contents(): php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution
2021-10-15 17:47:57.486 ----- DEBUG ----- loginCheck : current db version = 'V9.3.1'
2021-10-15 17:47:57.500 ----- DEBUG ----- User->authenticate('Bla_guest', 'XAH2wY6GaWH9Y2gp+FH29GZWF5Q=')
2021-10-15 17:47:57.505 ----- DEBUG ----- User->authenticate : no encryption
2021-10-15 17:47:57.510 ----- DEBUG ----- User->authenticate : Successfull login
2021-10-15 17:47:57.797 ===== TRACE ===== NEW CONNECTED USER 'Bla_guest'
2021-10-15 17:51:16.427 ===== TRACE ===== DISCONNECTED USER 'Bla_guest'
2021-10-15 17:51:32.179 ----- DEBUG ----- loginCheck : current db version = 'V9.3.1'
2021-10-15 17:51:32.195 ----- DEBUG ----- User->authenticate('Bla_guest', '718d04e04d661fd1c42cbeb304851d5aabdaf6146345381208c604d78012afcd')
2021-10-15 17:51:32.201 ----- DEBUG ----- User->authenticate : sha256 encryption
2021-10-15 17:51:32.201 ----- DEBUG ----- User->authenticate : Successfull login
2021-10-15 17:51:32.211 ===== TRACE ===== NEW CONNECTED USER 'Bla_guest'
2021-10-15 17:55:11.840 ** ERROR ** [V9.3.1] ERROR **
2021-10-15 17:55:11.840 ** ERROR ** [V9.3.1] on file '/var/www/projeqtor/view/refreshLastNews.php' at line (62)
2021-10-15 17:55:11.840 ** ERROR ** [V9.3.1] cause = file_get_contents(): php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution
2021-10-15 17:55:13.042 ** ERROR ** [V9.3.1] ERROR **
2021-10-15 17:55:13.042 ** ERROR ** [V9.3.1] on file '/var/www/projeqtor/view/refreshLastNews.php' at line (62)
2021-10-15 17:55:13.042 ** ERROR ** [V9.3.1] cause = file_get_contents(): php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution
2021-10-15 18:04:35.731 ===== TRACE ===== DISCONNECTED USER 'Bla_guest'
2021-10-15 18:05:07.715 ----- DEBUG ----- loginCheck : current db version = 'V9.3.1'
2021-10-15 18:05:07.734 ----- DEBUG ----- User->authenticate('Bla_guest', '9748d7ccc6c66a6efb71150d39bffb1d2d8078c9cd6d33fd5d49acb835af8da5')
2021-10-15 18:05:07.740 ----- DEBUG ----- User->authenticate : sha256 encryption
2021-10-15 18:05:07.741 ----- DEBUG ----- User->authenticate : Successfull login
2021-10-15 18:05:07.757 ===== TRACE ===== NEW CONNECTED USER 'Bla_guest'
2021-10-15 18:25:32.169 ===== TRACE ===== DISCONNECTED USER 'BlaAdmin'
2021-10-22 12:37:14.719 ----- DEBUG ----- loginCheck : current db version = 'V9.3.1'
2021-10-22 12:37:14.737 ----- DEBUG ----- User->authenticate('BlaAdmin', '206d0d8407e5e5240d503b32dc2668b47686a3b13114c7691922ba7f99aa37ea')
2021-10-22 12:37:14.743 ----- DEBUG ----- User->authenticate : sha256 encryption
2021-10-22 12:37:14.743 ----- DEBUG ----- User->authenticate : Successfull login
2021-10-22 12:37:15.020 ===== TRACE ===== NEW CONNECTED USER 'BlaAdmin'
2021-10-22 12:37:16.239 ===== TRACE ===== Cannot check Version at http:\projeqtor.org/admin/getVersion.php
2021-10-22 12:37:16.239 ===== TRACE ===== Maybe allow_url_fopen is Off in php.ini...
2021-10-22 12:38:02.622 ===== TRACE ===== DISCONNECTED USER 'BlaAdmin'
2021-10-22 12:38:14.083 ----- DEBUG ----- loginCheck : current db version = 'V9.3.1'
2021-10-22 12:38:14.097 ----- DEBUG ----- User->authenticate('Bla_guest', '66360ba95af8e785b5b1ab56df50522fb2f5af90b41b6e5bf872fb0f8102c87b')
2021-10-22 12:38:14.102 ----- DEBUG ----- User->authenticate : sha256 encryption
2021-10-22 12:38:14.102 ----- DEBUG ----- User->authenticate : Successfull login
2021-10-22 12:38:14.115 ===== TRACE ===== NEW CONNECTED USER 'Bla_guest'
2021-10-22 12:38:36.071 ===== TRACE ===== DISCONNECTED USER 'Bla_guest'
2021-10-22 12:38:47.025 ----- DEBUG ----- loginCheck : current db version = 'V9.3.1'
2021-10-22 12:38:47.041 ----- DEBUG ----- User->authenticate('BlaAdmin', 'c73e7f9b33384373efbc0f2f2035e11567cd645b4afd94f765b40870005dfff0')
2021-10-22 12:38:47.047 ----- DEBUG ----- User->authenticate : sha256 encryption
2021-10-22 12:38:47.047 ----- DEBUG ----- User->authenticate : Successfull login
2021-10-22 12:38:47.280 ===== TRACE ===== NEW CONNECTED USER 'BlaAdmin'
2021-10-22 12:38:48.373 ===== TRACE ===== Cannot check Version at http:\projeqtor.org/admin/getVersion.php
2021-10-22 12:38:48.373 ===== TRACE ===== Maybe allow_url_fopen is Off in php.ini...
2021-10-22 12:39:31.165 ===== TRACE ===== DISCONNECTED USER 'BlaAdmin'
2021-10-22 12:39:39.893 ----- DEBUG ----- loginCheck : current db version = 'V9.3.1'
2021-10-22 12:39:39.906 ----- DEBUG ----- User->authenticate('BlaAdmin', '93ef595542b086e6391dab1f5c82b5dbff8c3e6c904e62e7ee7129994763cb5d')
2021-10-22 12:39:39.912 ----- DEBUG ----- User->authenticate : sha256 encryption
2021-10-22 12:39:39.912 ----- DEBUG ----- User->authenticate : Successfull login
2021-10-22 12:39:40.135 ===== TRACE ===== NEW CONNECTED USER 'BlaAdmin'
2021-10-22 12:39:41.166 ===== TRACE ===== Cannot check Version at http:\projeqtor.org/admin/getVersion.php
2021-10-22 12:39:41.166 ===== TRACE ===== Maybe allow_url_fopen is Off in php.ini...
2021-10-22 12:42:46.359 ..... SCRIPT .... 192.168.56.1 =====/projeqtor/tool/dynamicDialog.php
2021-10-22 12:42:46.461 ..... SCRIPT .... 192.168.56.1 Page=dynamicDialog.php
2021-10-22 12:42:46.461 ..... SCRIPT .... 192.168.56.1 refreshParameters()
2021-10-22 12:42:46.565 ..... SCRIPT .... 192.168.56.1 getProfile(objectOrIdProject=Audit #109)
2021-10-22 12:42:46.565 ..... SCRIPT .... 192.168.56.1 getProfile(objectOrIdProject=Audit #109)
2021-10-22 12:42:46.581 ..... SCRIPT .... 192.168.56.1 ->/view/logfiles.php
2021-10-22 12:42:48.348 ..... SCRIPT .... 192.168.56.1 =====/projeqtor/tool/dynamicDialog.php
2021-10-22 12:42:48.442 ..... SCRIPT .... 192.168.56.1 Page=dynamicDialog.php
2021-10-22 12:42:48.442 ..... SCRIPT .... 192.168.56.1 refreshParameters()
2021-10-22 12:42:48.549 ..... SCRIPT .... 192.168.56.1 getProfile(objectOrIdProject=Audit #109)
2021-10-22 12:42:48.549 ..... SCRIPT .... 192.168.56.1 getProfile(objectOrIdProject=Audit #109)
2021-10-22 12:43:01.771 ..... SCRIPT .... 192.168.56.1 =====/projeqtor/tool/storeLogLevel.php
2021-10-22 12:43:01.864 ..... SCRIPT .... 192.168.56.1 Page=storeLogLevel.php
2021-10-22 12:43:01.865 ..... SCRIPT .... 192.168.56.1 refreshParameters()
2021-10-22 12:43:01.971 ..... SCRIPT .... 192.168.56.1 getProfile(objectOrIdProject=Audit #109)
2021-10-22 12:43:01.971 ..... SCRIPT .... 192.168.56.1 getProfile(objectOrIdProject=Audit #109)
2021-10-22 12:43:01.996 ..... SCRIPT .... 192.168.56.1 getProfile(objectOrIdProject=Parameter #1766)
2021-10-22 12:43:01.996 ..... SCRIPT .... 192.168.56.1 getProfile(objectOrIdProject=Parameter #1766)
2021-10-22 12:43:01.996 ..... SCRIPT .... 192.168.56.1 securityGetAccessRightYesNo ( menuName=menuParameter, accessType=update, obj=Parameter #1766, user=User #3)
2021-10-22 12:43:01.997 ..... SCRIPT .... 192.168.56.1 securityGetAccessRight(menuName=menuParameter, accessType=update, obj=Parameter #1766, user=User #3)
2021-10-22 12:43:01.997 ..... SCRIPT .... 192.168.56.1 getAccessControlRights(obj=Parameter #1766)
2021-10-22 12:43:01.997 ..... SCRIPT .... 192.168.56.1 getProfile(objectOrIdProject=Parameter #1766)
2021-10-22 12:43:05.302 ===== TRACE ===== DISCONNECTED USER 'BlaAdmin'
2021-10-22 12:43:13.816 ----- DEBUG ----- loginCheck : current db version = 'V9.3.1'
2021-10-22 12:43:13.832 ----- DEBUG ----- User->authenticate('BlaAdmin', '5377cacb5463bc96ef94cc6e2606bbe64c89394e4fbc50e5ecbf72269e282550')
2021-10-22 12:43:13.837 ----- DEBUG ----- User->authenticate : sha256 encryption
2021-10-22 12:43:13.838 ----- DEBUG ----- User->authenticate : Successfull login
2021-10-22 12:43:14.069 ===== TRACE ===== NEW CONNECTED USER 'BlaAdmin'
2021-10-22 12:43:15.144 ===== TRACE ===== Cannot check Version at http:\projeqtor.org/admin/getVersion.php
2021-10-22 12:43:15.144 ===== TRACE ===== Maybe allow_url_fopen is Off in php.ini...
2021-10-22 12:43:53.150 ===== TRACE ===== DISCONNECTED USER 'BlaAdmin'
2021-10-22 12:43:53.577 ** ERROR ** [V9.3.1] Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '6j5p2g4cfu32l8r12iji0v7adf_20211022124353' for key 'auditSessionId'
2021-10-22 12:43:53.577 ** ERROR ** [V9.3.1] For query : update audit set sessionId='6j5p2g4cfu32l8r12iji0v7adf_20211022124353' , disconnectionDateTime='2021-10-22 12:43:53' , idle='1' where id=111
2021-10-22 12:43:53.577 ** ERROR ** [V9.3.1] Strack trace :
2021-10-22 12:43:53.577 ** ERROR ** [V9.3.1] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1780]
2021-10-22 12:43:53.577 ** ERROR ** [V9.3.1] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1237]
2021-10-22 12:43:53.578 ** ERROR ** [V9.3.1] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:820]
2021-10-22 12:43:53.578 ** ERROR ** [V9.3.1] #3 SqlElement->save called at [/var/www/projeqtor/model/Audit.php:357]
2021-10-22 12:43:53.578 ** ERROR ** [V9.3.1] #4 Audit->save called at [/var/www/projeqtor/model/Audit.php:230]
2021-10-22 12:43:53.578 ** ERROR ** [V9.3.1] #5 Audit->finishSession called at [/var/www/projeqtor/tool/saveDataToSession.php:66]
2021-10-22 12:43:53.601 ===== TRACE ===== DISCONNECTED USER 'BlaAdmin'
2021-10-22 12:44:56.877 ----- DEBUG ----- loginCheck : current db version = 'V9.3.1'
2021-10-22 12:44:56.892 ----- DEBUG ----- User->authenticate('BlaAdmin', '14d99b611d39142048c098fdd9bd0262508fe854b7f1d9f0cc686db45e2027b5')
2021-10-22 12:44:56.897 ----- DEBUG ----- User->authenticate : sha256 encryption
2021-10-22 12:44:56.897 ----- DEBUG ----- User->authenticate : Successfull login
2021-10-22 12:44:57.123 ===== TRACE ===== NEW CONNECTED USER 'BlaAdmin'
2021-10-22 12:44:58.178 ===== TRACE ===== Cannot check Version at http:\projeqtor.org/admin/getVersion.php
2021-10-22 12:44:58.178 ===== TRACE ===== Maybe allow_url_fopen is Off in php.ini...
This can be a cache issue.
After upgrade, make sure to clean your browser cache.
When you change user, also be sure to have a clean disconnection (use disconnect button, not F5)
Thank you, clearing cache helped
Hello
Unfortunately I was a little bit too fast by closing this topic. After the last time I realized that the problem disapered after clearing the cache. Later I found out that this method was only working in the Firefox but not for Chrome/Edge (which is in the meantime also listed as chrome in the audits).
I discovered that project selector also didn't work if it standard (reflecting WBS) is selected, as well as the left menu bar. (including the lower part, which shows parameters, shortcuts, etc).
The result was, after "cron" was started again the page could be loaded correctly..
I simulated the whole setting up again and could circle when it happens and how to solve (here is the fastest way to simulate)
[list=1]
- Menu left disapears
- Project selector in "standard (reflecting WBS structure) doesn't work anymore
- Bell Symbol on top next to "Cron" icon apears with 0 and no notification showed
This happend already on V9.2.2 which was working without any problem until i did the first 4 steps also with Parameter "getVersion" to YES
Before the rights of guest have been reduced to "Reader" the message shown is as expected, but everything worked.
2021-10-29 20:37:39.434 ** ERROR ** [V9.2.2] on file '/var/www/projeqtor/view/refreshLastNews.php' at line (62)
2021-10-29 20:37:39.434 ** ERROR ** [V9.2.2] cause = file_get_contents(): php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution
Maybe there are more things related to this and the screenshot can help you to improve the code (done in Edge)
Hi,
I could not repoduce use case. All works fine for me.
We'll have a look to issue pointed in browser console.
Possibly it is already fixed by some menu issue we fixed on V9.3.3
Hi,
Ok, Iwill have a look as soon V9.3.3 is released

