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 → GL Inquiry can't show one year of data
When I try query one year using the gl inquiry in my database using one of my accounts which have ~16000 transaction in 2024 the page stuck like what shown in the picture at the attachment and no result given.
How can I let FA give me the result I'm running FA in server with 8GB of ram using RHEL 9 based distro using nginx and php 8.3.
Can pagination be implemented with this page?
Increase the number of max_input_vars in the php.ini apart from max memory size.
I tried to increase the limits as you said and even set the memory limit to something big such as memory_limit = 4G or 6G which I think is way too much what if there is page leaking it might hang my server.
Anyway after increasing the limit I got 10 month to work by 11+ months doesn't work.
Restart webserver if php.ini settings were changed.
Optimise your database and introduce some indexes for certain fields used in the report query.
export out your database and recreate it by importing it into a new structure.
I have a testing server that I can give you access in and you can see and debug the problem could you message me in private to see the issue as the problem is still and not fixed by the configuration that you give me and this face any frontaccounting installation with big data.
A lack of indices on some fields of some tables - that only speeds up processing.
If the output is because of having a single output buffer for a very large amount of data that needs to be streamed, then a file capture of the output can be implemented. @joe: any ideas?
Are you using any extensions?
Just take a full compressed backup (delete the data from the users table in the backup) from within FA and upload it somewhere and send me a PM and indicate it here.
What versions of PHP / MySQL are you using?
@apmuthu
I sent you a database backup as requested in PM.
We only use SimpleAPI extension.
There is the Slim PHP micro framework - v2.64 has been tested.
SimpleAPI extension available at https://github.com/andresamayadiaz/FrontAccountingSimpleAPI ?
https://www.frontaccounting.com/fawiki/index.php?n=Devel.SimpleAPIModule
Is this the one you are using?
Check PM to verify GL data
What steps do you want to verify for size?
Checked out 01-01-2024 to 31-08-2024 in GL Inquiry for 1060 account and it works fine in 10 to 12 seconds.
When we go upto 30-09-2024 (ie., one more month) it times out in 12 seconds.
This did not change with memory_limit from 128M to 4G.
Looks like some script timeout or keepalive or session issue.
Solved. Increases the Ajax timeout to 20 seconds.
Ref: https://frontaccounting.com/punbb/viewtopic.php?pid=5318#p5318
The default is 10 seconds (10000 milliseconds) in js/utils.js lines 36 to 42:
JsHttpRequest.request= function(trigger, form, tout) {
// if (trigger.type=='submit' && !validate(trigger)) return false;
tout = tout || 10000; // default timeout value
document.getElementById('msgbox').innerHTML='';
set_mark(tout>10000 ? 'progressbar.gif' : 'ajax-loader.gif');
JsHttpRequest._request(trigger, form, tout, 0);
};Replacing 10000 to say 20000 or more in the two places above will do the job.
Logout of FA. Close the browser. Clear the cache and then login to get longer ajax queries of inquiry and reports.
This has been Wiki-ed.
@joe / @itronics: can we make this a setting in the config.php?
Thank you @apmuthu your solution works.
FrontAccounting forum → Banking and General Ledger → GL Inquiry can't show one year of data
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.