@apmuthu
So how can this be optimized?
now my database contain more data and it is slower it takes 9s at first load of the page and 3s at second.
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by DrCard
@apmuthu
So how can this be optimized?
now my database contain more data and it is slower it takes 9s at first load of the page and 3s at second.
@apmuthu
Did you have any chance to check.
Does doesn't solve the issue
see it live with this video
https://limewire.com/d/8sVmD#7dwHq2I31A
it takes 6.66s
BTW we are using nginx
Hi,
I'm facing slowdowns with the Direct Invoice page it might be because my database contain a lot of customers and dimensions so how can we improved to be faster.
When I open it first time after I logged in it took ~6.66s but when my session is still active and not logged out and I visit the page again it took ~1.32s.
P.S. sample database sent to @apmuthu for debugging purposes
Thank you @apmuthu your solution works.
@apmuthu
I sent you a database backup as requested in PM.
We only use SimpleAPI extension.
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.
What is best way to do custom modern theming frontaccounting where style and even layout could be changed for specific pages to have pixel-perfect look similar to other systems and themes like https://puzzle.io/ and https://themeforest.net/item/vuexy-vuejs-html-laravel-admin-dashboard-template/23328599 .
Is it using the frontaccounting theming functionality or by creating APIs to create alternative frontend using modern web framework such as laravel or by modifying the core of frontaccounting?
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.
Can pagination be implemented with this page?
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.
Yes, How can i get a report that shows this.
If i want to Lock the reconciled transactions in FA 2.4 How can i do it.
Regards and thank you very much for your reply
I need both ways. Some items are output and inputs.
For example, I have 100 strawberries. I will use 60 strawberries to make juice and 40 strawberries to make milkshakes.
The milkshake will require both the strawberry juice made from the 60 strawberries and the remaining 40 strawberries to be produced.
How can I lock reconciled transactions after reconciling them so no body can edit after reconciling them just like that video shows:
https://www.youtube.com/watch?v=BNGMn9Muai0
We have a manufacturing business.
is there a report that show how many Products that I can Manufacture from the current inventory based on the BOM. And If I need to produce a given amount of an item, how many more BOM Stocks I would need.
Example:
So, to Produce Item A, it would need 2 Item B and 1 Item C. So, at the moment I have 3 from Item B and I have 2 From Item C. So I need a report shows me that I can Produce 1 Item A.
Also, lets say i needed to produce 100 Item A, it would tell me that I need 197 Item B more (3 in inventory so in total 200) And 98 from Item C (2 in inventory so in total 100).
Any updates guys?
this video in attachment demonstrate the issue and the temporary fix while using default theme without select2
It seems you are using the select2 feature in every drop down. It's not core of FA. You you might modified the version of it.
So when you choose certain customers. The drop down or the items list might be directly connected to the sales price.
Or there can be the custom query which is failed to get results..
Or if any drop down or the list might be oversized. And it fails to load.
Or may be timeout. Increase the time if it.
Looks like you are a developer to modify the theme..So check those perspective.
Try something more on that to elaborate the error
Theme seems to be unrelated I tried disabling and it doesn't solve the issue.
Temporary solution is to use customer not affected by this issue and then switch to effected one and then I'm able to proceed.
Compare the DB structures of the good and erroneous instances.
Compare the file and folder permissions of the web facing files.
Try to make the unset command into two separate commands, one for each variable, preferably after checking if it exists.
Compare the php.ini files across both installations.In the file sales/sales_order_entry.php, at line 603, the unset appears as:
unset($_POST['_stock_id_edit'], $_POST['stock_id']);
Wonder what the subsequent page_modified() does after the above statement that causes the error.
I tried separating unset without any success also when this issue happen page_modified() is not reached it stuck and unset and that's it.
This image in the attachment
For some customers mostly but not always customers with many transactions I can't add new item to the direct invoice and receive only
warning triangle without response to the request and leave no logs or footprint in php logs or nginx or php-fpm
https://i.ibb.co/vcWQknV/ibba.png
after debugging the issue seems to appear in the line containing
unset($_POST['_stock_id_edit'], $_POST['stock_id']);
in the function handle_new_item() while the $_POST['_stock_id_edit'], $_POST['stock_id'] are defined and I could print them with
display_error and such and also this unset() call work on some customers and didn't work on others
I tried to change my php version from 8.2 to 7.4 and it worked for while but then it stopped and never worked even when I clear the cache
I'm using nginx and php 8.2 in rocky linux 8
do anyone face same issue?
None of them until now are talking about slim 4 update
Will there be any update for Slim 4 integration with front accounting apis ?
As our servers are running with php 8.
With
https://github.com/andresamayadiaz/FrontAccountingSimpleAPI
Currently we are using 1 api package that is built with slim 2 and that is not compatible with php 8.
I am trying use this with front accounting 2.14.4.
Any solution for this.
Or alternatives
I think this bug was fixed short after the 2.4.12 release.
We have fixed some more PHP 8 bugs as well.
Vi are planning a minor release next week so hopefully you will be satisfied then.
Joe
I'm running Version 2.4.12 Build 27.08.2022
and its not fixed
I'm still facing the same problem
you can duplicate the transaction and setting that are in the pictures, you will get the same result
ill will check the next release
thanks Joe
FrontAccounting forum → Posts by DrCard
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.