Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Hello,
Since I updated projeqtor to v9.2.2, it takes at least 30 seconds for admins to login.
For normal users, the login is as fast as it was previously.
I don't know if that's related but we are getting this in the logs with mariadb -> 10.5.11 :
2021-08-18 16:59:28.745 ** ERROR ** [V9.2.2] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by ticket.idResource, workelement.refId, ticket.doneDateTime' at line 6
2021-08-18 16:59:28.746 ** ERROR ** [V9.2.2] For query : SELECT DISTINCT ticket.idResource as idresource,
workelement.refId as idticket,
workelement.realwork as realwork,
workelement.leftWork as leftwork,
workelement.plannedWork as plannedwork,
ticket.doneDateTime as date FROM ticket,workelement WHERE ticket.id = workelement.refId and workelement.refType='Ticket' AND ticket.idProject in (0, 1, 3, 4, 5, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 21, 22, 23, 24, 25, 26, 29, 32, 63, 62, 33, 28, 37, 38, 39, 40, 43, 46, 51, 55, 58, 64, 65, 73, 74, 75, 76, 66, 77, 78, 79, 80, 81, 85, 101, 102, 103, 104, 67, 86, 87, 88, 89, 90, 91, 68, 83, 92, 93, 96, 97, 98, 99, 100, 71, 82, 72, 94, 95, 42, 108, 41, 59, 113, 114, 27, 47, 109, 57, 111, 56, 35, 112, 110, 115, 116) AND ticket.idResource = order by ticket.idResource, workelement.refId, ticket.doneDateTime ;
2021-08-18 16:59:28.746 ** ERROR ** [V9.2.2] Strack trace :
2021-08-18 16:59:28.746 ** ERROR ** [V9.2.2] #0 Sql->query called at [/var/www/html/report/performanceIndicator.php:733]
2021-08-18 16:59:28.746 ** ERROR ** [V9.2.2] #1 ticket called at [/var/www/html/report/performanceIndicator.php:163]
Okay it seems to be a network issue, DNS is not reachable from the container.
During login, projeqtor check if a newer version is available for the admins and by doing so it hangs for a few seconds.
The SQL error is unrelated
You can disable this feature on Global Parameters to avoid this issue