View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] [v9.2.2] Login takes at least 30 seconds for admins - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

[SOLVED] [v9.2.2] Login takes at least 30 seconds for admins

More
19 Aoû 2021 15:51 #1 by Dr-Shadow
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]

Please Connexion or Create an account to join the conversation.

More
19 Aoû 2021 16:31 #2 by Dr-Shadow
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

Please Connexion or Create an account to join the conversation.

More
24 Aoû 2021 17:39 #3 by babynus
You can disable this feature on Global Parameters to avoid this issue

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.034 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.