Allowed Memory Error on viewing Time Tracking

avatar jlackey Pro Nov 12. 2010. 11:33 pm
Hello,
I'm getting the following error when trying to use the Time Tracking module outside of a project (from the main navigation). The error seems to happen on different files when refreshing the page...

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 43 bytes) in /home/zunadm/public_html/projects/activecollab/angie/classes/datetime/DateTimeValue.class.php on line 124


Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 46 bytes) in /home/zunadm/public_html/projects/activecollab/angie/functions/general.php on line 82

My memory_limit is set to 64mb.

Any and all help is greatly appreciated!

-Jon
avatar jlackey Pro Nov 13. 2010. 2:59 am
I think I've figured out the problem.

Not sure if this was being picked up from a session variable or if it is the default selection, but the Time view was trying to load the "Total" report. We've been using aC for a long time and have a TON of time entries so the errors were being thrown when trying to load all the entries. I changed memory_limit to 128mb and it loaded—took a long time, but it worked. Then I changed the report to "Last month" and it loaded almost instantly.

Is there a default selection of the Time view? (on the global view, not a project view)

Thanks,
Jon
avatar Nirav M. Dev Nov 13. 2010. 5:30 am
Hi Jon,

I have seen this on a few clients as well - their default time report is an all inclusive report and that causes memory issues. Changing the default report - or its settings is a quick fix.

But if you still want to access the lengthy report - you will continue to receive the error. So the solution is to increase RAM available.

And you may actually find a surprising solution to this via our Time Reports Plus module. It significantly reduces database queries and memory requirements, and gives much enhanced time reports.

:Nirav
Discover a new high in team productivity with our Best Selling & Most Loved activeCollab Extensions
avatar jlackey Pro Nov 14. 2010. 7:20 pm
Thanks Nirav!

I actually tried your Time Reports Plus module first. Unfortunately I still have the problem when trying to run a global "Total" report. But I love the module and am using it now.

-Jon
avatar jlackey Pro Nov 14. 2010. 7:48 pm
One more thing, Nirav, you mention changing the default report could be a quick fix. I've looked and must be missing where this would be set.

Thanks again!
Jon
avatar Nirav M. Dev Nov 15. 2010. 8:46 am
Hi Jon,

There is no way to make a report as default from activeCollab frontend. You can do it by updating rows in the "acx_time_reports" table though.

An easier option will be to simply edit the Total report that you have, rename it / adjust its parameters. Then create another report for Total.

If you are still getting memory limit errors, you must be having a *lot* of time records! :-)

:Nirav
Discover a new high in team productivity with our Best Selling & Most Loved activeCollab Extensions
avatar lethia Pro Jan 13. 2011. 6:44 am
Hi Jon,

I am experiencing a similar issue and my hosting provider limits my memory on the server to 30mb so ActiveCollab no longer works on a lot of screens.

I have two questions for you and anyone else who can help.

1) Are there any other work arounds to the memory limits?

2) What hosting providers are you using that give you greater than 30mb memory limits?
avatar Ilija Studen Staff Jan 13. 2011. 10:42 am
Hello,

There are no way around memory limits - PHP is pretty strict about them. What you can do is:

1. If you are hitting memory limits with thumbnail creation, you can configure activeCollab to create thumbnails for small files only or completely turn off thumbnail creation. More info here.
2. If you are experiencing problems with reports, set them up so they narrow results they return.
avatar lethia Pro Jan 13. 2011. 4:44 pm
What steps would I take to begin the process of moving my AC to a new location? I will have to sign up for hosting with a new company because the current host provider http://1and1.com can not support AC.

Once my hosting account is setup, how do I begin moving my content over?
avatar Ilija Studen Staff Jan 13. 2011. 5:42 pm
Hello,

Have you double checked with your hosting whether you can check memory limit value for folder where activeCollab is running? Most hosts offer that as an option, and we had nobody complaining about 1and1 (there are many customers who host activeCollab there).

Try activeCollab free for 30 days, No credit card required!

Instant access to activeCollab, no installation needed.

.tryactivecollab.com

If you are already a user of activeCollab, you can log in here.