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"
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.
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?
It is clerly a MySql configuration or runtime issue.
Many threads can be found on the subject.
http://stackoverflow.com/questions/6000336/how-to-debug-lock-wait-timeout-exceeded
http://stackoverflow.com/questions/5836623/getting-lock-wait-timeout-exceeded-try-restarting-transaction-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