Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Each time I try to change the project on an activity, the system just freezes and I can't do anything else. It keeps saying "Query is ongoing. Please wait".
What I did, was create a new project. Saved the new project details and then went into activities and changed the Project Drop Down field to the one I created.
But each time I do this, the system hangs.
I have to clear my cache and log back into to regain control.
please help.
Cannot reproduce.
Could you please check log file and post reported errors here.
Also check browser console for error and also post hem here.
I have attached the log file from ProjeQtor. no log files for internet explorer. I have the most current IE version.
You're facing lock timeout issue.
Thiis is very strange as I never faced this kind of issue nor was it reported.
So different possibilities :
=> you have some locks that were not removed (some db corruption)
=> you auto -lock your changes : the database do not notice that changes concern same transaction. This can be due to some pessimistic lock strategy defined in MySql.
Please check for this.
Possibly give more hints on configuration : db version, my.ini file, ...
I tried changes in server configuration which makes this error occur, but still problem is not solved. Can you ask Developer of Projeqtor to provide any solution on this?
Which settings do you want to know specifically. If I provide you output of phpinfo would it work or not?
Can you ask Developer of Projeqtor to provide any solution on this?
Difficult to fix without reproducing.
Which settings do you want to know specifically. If I provide you output of phpinfo would it work or not?
phpinfo will not be great help as it is a database issue. Try and provide my.ini, it may help.
Also I tried setting ''innodb_lock_wait_timeout'' value to 30, 300 and 900 but it did not helped so I had revert back config to value 50.
It seems your default engine is MyISAM.
This engine, although quite performant, do not support transactional (ACID) operations.
So, most possibly your lock issue comes from this point.
Check your tables and try and change engine to InnoDb, it should fix the issue.
I have tried to obtain the my.ini file, however our IT staff have said "There is no way to get my.ini from WHM. "
Is there any other way of having this resolved. It still happens with the upgrade to 5.0.3
No, iti is not possible.
ProjeQtOr uses transactional operations. If your MySql is only compatible with MyISAM files, ProjeQtOr won't work.
Maybe some migration (export and reimport fixing default files would work, but I'm really not sure as innoDb is explicitly defined during table creation.
Maybe you may concider upgrading database or use PostgreSql database (always transactionnal capacble)