It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Banking and General Ledger → Ajax Time Out in GL Inquiry
When querying one month transactions for a given gl account, the Ajax does not return any record because the number of records are around 300. What could be the solution for this? Can't we have multiple pages in the return of Query?
Is it anything in php.ini or mysql.cnf settings???
300 records does not a problem to query and get in FA time. it ends with bugs from the query results or the server may experience load problem. try take a backup of your database and check it on load free server like localhost or separate vps.
Try enable debuging mode to get errors on FA error.log
I increased the max_execution_time so the problem mitigated but what if the records increases?
How long is it now?
I've seen 600 secs recomended as max, (setting to 0 is unlimited, but maybe other timeouts in http so beware) From my understanding its a security issue.
Does your host allow changes?
This SE post is interesting, can you add a variable based on number of records?
Google is your friend
@boxygen, This is not optimal solution. The actual problem is different. 300 records is not big thing. more than 1 lac records queried and display the results even in shared hosting without changing FA timeout. There is some other issue causing this issue. May be inefficient query is there to consume more RAM to get it expire the time limit.
@kvvaradha whats a lac? Do you mean 100,000?
@kvvaradha, you are right. Thanks alot
I got the problem. One of my customization was basically causing the issue. I must have checked that without customized code.
Regards.
@poncho1234 yes lac is 100,000 in our local language 
@kvvaradha whats a lac? Do you mean 100,000?
Yes its 1,00,000 records.
@kvvaradha, you are right. Thanks alot
I got the problem. One of my customization was basically causing the issue. I must have checked that without customized code.
Regards.
Glad to hear that you found actual reason for the issue. Can you share the details of it?
and it might helpful to someone else knocks with similar issue in future.
I wrote a function to write to a file the sql output for debugging purpose. I forgot to comment that out. That was actually taking too long.
FrontAccounting forum → Banking and General Ledger → Ajax Time Out in GL Inquiry
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.