View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Not able to make changes to dates or modify description - 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)

  

 

 

Not able to make changes to dates or modify description

More
12 Déc 2015 05:55 #1 by iconic
Not able to make changes to dates or modify description was created by iconic
Every time I try change the Validate or Request Dates or try to modify any field of an activity I received this error "
SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction"

Please Connexion or Create an account to join the conversation.

More
12 Déc 2015 15:12 #2 by babynus
Replied by babynus on topic Not able to make changes to dates or modify description
Check your MySql configuration.
ProjeQtOr need tranactional updates.
This is only possible with InnoDb engine.
If your MySql is configured to use only MyIsam files, ProjeQtOr won't work correctly.
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
18 Déc 2015 00:22 #3 by iconic
Replied by iconic on topic Not able to make changes to dates or modify description
Our Web Engineer has checked and he has confirmed that all tables are InnoDB only.
So there must be another problem.

What can we do now?

Please Connexion or Create an account to join the conversation.

More
18 Déc 2015 12:30 - 18 Déc 2015 12:30 #4 by babynus
Replied by babynus on topic Not able to make changes to dates or modify description
It is clerly a MySql configuration or runtime issue.

Many threads can be found on the subject.
stackoverflow.com/questions/6000336/how-...ait-timeout-exceeded
stackoverflow.com/questions/5836623/gett...ction-even-though-im

Summary of advises :

1) Change lock_wait_tieout in my.ini
[mysqld]
innodb_lock_wait_timeout=120
Not a very good idea IMO, but worth a try

2) Kill any sleeping thread on the database

3) Maybe a clean restart of database could help removing exiting locks
Babynus
Administrator of ProjeQtOr web site
Last edit: 18 Déc 2015 12:30 by babynus.

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.036 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.

Login Form