View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - SQL Exception on elements updates - Page 2 - ProjeQtOr

Prochaines Sessions

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

SQL Exception on elements updates

More
14 Avr 2014 17:03 #7 by Iaurkano
Yes but, very strange to need to increase this time out, because the current value 50 seconds seems to be huge for an update or one record.

In my case, this appears when i want to update a status in an activity.

thank's,

Please Connexion or Create an account to join the conversation.

More
14 Avr 2014 17:42 #8 by Iaurkano
last information

i restarted the apache server, and the message does not appear any more.

i'm going to migrate to 4.2.2 version and will check if the issue still present.

So it seems it's not a Database issue.....

see you...

Please Connexion or Create an account to join the conversation.

More
14 Avr 2014 19:06 #9 by babynus

i restarted the apache server, and the message does not appear any more.

So possibly you has some existing PHP session with not comitted transaction locking some tables.

So it seems it's not a Database issue.....

Possibly you have some configuration that enables to have very long peristent transaction (no timeout ?)

i'm going to migrate to 4.2.2 version and will check if the issue still present.

Latest version is 4.2.3 ;)

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: Iaurkano

Please Connexion or Create an account to join the conversation.

More
15 Avr 2014 15:10 - 15 Avr 2014 15:10 #10 by Iaurkano
After investigation, i found how to generate the problem :

1- i perform multiple updates, for activity status (at least) .
2- an error occurs during multiple update because a status cannot be changed because of the workflow. In the 3.4.4 version, Projectorria does not indicate any errors, the hourglass stay indefinitely, and i must close firefox to exit projectorria. after reconnection I get the MySQL Error, on the record where the error occurs.

This issue does not appear with 4.2.2, so i m going to migrate ASAP.

Hi all.
Last edit: 15 Avr 2014 15:10 by Iaurkano.
The following user(s) said Thank You: babynus

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.051 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.