Hello!
I have a project which contains 3 activities, every which contains about 85 activities and every last which contains 21 activities and 13 milestones.
I try to delete it.
When I do this on a test server, it's all good (to tell the truth, it takes about 40 minutes). But when I try to do this on a remote server, I'll got errors.
Php and mySQL configs are same on both servers. The test server is running on Apache, the remote server is running on IIS.
Maybe, should I edit additional settings/configuration for correct work?
Thank You in advance
You may have reached Time limit Timeout.
Try and configure max_execution_time.
Of maybe you are in safe mode, which forbids to overwrite max_execution_time dynamically.
Of course, deleting more than 11300 items at a time may be very long.
Maybe you can do this deleting first sub-activities to split the deletion in several operations.
this deleting first sub-activities to split the deletion in several operations
Yes, I can, but it will be more useful to delete in a one click. And when I try to delete a part of the project - an activity which contains 45 activities every which contains 21 activities and 13 milestones - Projeqtor could not delete it. But if I delete an activity which contains only 30 activities every which contains 21 activities and 13 milestones, Projeqtor will return same errors (the screenshot is in a previous message) and if after that I update page, activity is deleted.
Of maybe you are in safe mode, which forbids to overwrite max_execution_time dynamically.
In "php.ini" sql.safe_mode is off. Or did You tell about other safe mode?
Try and configure max_execution_time.
max_execution_time is 3600 in both servers' settings.
You may have reached Time limit Timeout.
I changed innodb_lock_timeout from 50 to 500 in "my.ini" and after that I got error again. Maybe do You mean other timeout? (work_timeout is 60)
It's not big deal to spent many time, while Projeqtor delete items, but it is very important, what it delete items without any errors.
Once again, it is not normal use case to delete more than 11000 items at a time.
It you created so many item, why delete them ?
It should not be everyday use, so deleting step by step should not be an issue.
Try and change max_execution_time to very high value (10000 for instance)
It you created so many item, why delete them ?
Because I have few same subprojects, and for faster work of planning (Gannt) I have deleted a subproject, which is already done. So work is more comfortable to me.
Try and change max_execution_time to very high value (10000 for instance)
It did not help, unfortunately.
Thank You for help. I'll research this question further
If your project is done, you should not delete it, but just close it (set to status closed).
It will be hidden, but you'll be able to retreive it in history when you need it.
Thank You!