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]