Lines 416 and 481 have both parameters in admin/db/maintenance_db.inc
Also in the CoA sql/en_US-new.sql we have SET NAMES latin1; and it may be utf8 for other language CoAs.
Please list the changes you have made.
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 apmuthu
Lines 416 and 481 have both parameters in admin/db/maintenance_db.inc
Also in the CoA sql/en_US-new.sql we have SET NAMES latin1; and it may be utf8 for other language CoAs.
Please list the changes you have made.
FA has some fixes for PHP 8 and deployment notes from users on PHP 8.3 would be welcome.
SCOTT WHEELER, President, NOVERHEAD SOFTWARE, LLC, 132 Woodcrest Dr Loveland, OH, 45140-7756 United States/
In 2011: 6971 TICONDEROGA TRAIL EDEN PRAIRIE OH 55346
https://www.cartspan.com/
513-708-1317
https://frontaccounting.com/punbb/viewtopic.php?pid=43386#p43386
CartSpan itself is a Microsoft Windows based application that resides on your local desktop. CartSpan will communicate with its own standard PHP script (ionCube encoded) to accomplish the integration work.
Zip and attach herein and send to @joe.
Fork and send pull request to the unofficial Extensions repo as well.
Also it should state the version of WP it was tested on and whether PHP8 constructs undermine legacy PHP versions of FA in usage.
There are 2 tables - stock_category and stock_master - that have the field mb_flag in FA default installation. The former has it as dflt_mb_flag.
There are a total of 53 files with the field mb_flag in them in the core FA.
mb_flag values:
F => Fixed Asset
B =>Purchased - Default in the tables, used only in reports rep3*.php as item.mb_flag='B' OR item.mb_flag='M'
M => Manufactured
D =>Service (S old flag)
Which file has mb_flag='A' ?
@joe: Should this be included?
Try to create another item of inventory type for the old one without inventory and proceed thereafter and see if you can back enter the old ones in the latter and then edit the invoices, salesorders and others that affect inventory thereafter
Those in EU will have time for this only when the Ukraine war is over and everyone feels safe there.
When re-ordering the arguments to functions, the appropriate function definitions should also be aligned accordingly.
Make the choice in the form for the said report. See attachment.
Deprecated is just a warning and can be suppressed in the php,ini.
Solution : Rename your function name emailcomm() to __construct()
Explanation: In previous versions of PHP, if PHP cannot find a __construct() function for a given class, it will search for the old-style constructor function, by the name of the class, but now old style constructors are DEPRECATED in PHP 7.0, and will be removed in a future version. You should always use __construct() in new code. Read php manual
function __construct() {
// copy your old constructor function codehttps://stackoverflow.com/questions/47549783/php-deprecated-methods-with-the-same-name-as-their-class-will-not-be-constructo
https://frontaccounting.com/fawiki/uploads/Help/Rep304_Inventory_Sales_Report.png
Item Categories and Items
The removal of & in &Items can be automated as well as long as & is not used anywhere else.
It can also be a php script as part of FA just like:
https://github.com/apmuthu/frontac24/blob/master/FA24Mods/make_coa.php
Inventory => Inventory Sales Report => rep304
Try to make the settings to http instead of https and make appropriate changes in includes/session.inc
Which platform are you on - linux/mac or windows?
Troubleshoot by putting in the extensions one by one and checking if the anomaly still exists.
Which extensions have you loaded and activated for each company?
Check the error logs.
Try with PHP 5.5 / 5.6 and see if it persists.
Use an older version like v6 for best performance if using PHP 5.6 or earlier.
Searching for "FrontAccounting 2.4.18 Login" yields quite a few FA 2.4.18 deployment sites like:
https://fhri.smarttools.systems
https://byzantia.capital
https://fncacctg.com/pasig2
http://34.101.78.123/--testing
https://www.royalqamis.co.ke
https://invoice.btiw.in
https://akankshaonline.com
https://varakiyu.com
https://mahs66.com/fa
https://tuckeroptimistclub.org/fa
https://www.ms.ly
https://townlinkhardware.comScript Installers for FA 2.4.18 are available for:
Azure
Softaculous
Hence for obscurity, change the Title of the login page.
Identify the inquiry page to display and then cull out the necessary fields and the computations needed and make a generic SQL SELECT query and execute it in any MySQL client and then make a php script for it.
Quick Entries or Recurring JVs
Alternatively, direct computed SQL statements extracted from existing entries.
By 2025, e-Invoicing is to come into effect fully in Malaysia.
https://www.complyance.io/malaysia-blog/e-invoicing-malaysia-guide
There are some guides for eCommerce in general at:
https://www.frontaccounting.com/fawiki/index.php?n=Help.SquareConnector
https://github.com/braathwaate/FA24extensions/tree/master/Extensions/square
https://frontaccounting.com/punbb/viewtopic.php?pid=43386#p43386
https://www.frontaccounting.com/punbb/viewtopic.php?id=2096
If there any solutions for FA do contact LC Chen of the Sita Group - +60-3-375-8888.
Is @TCLim still around - if so, what is the new website for his FA connectors?
https://stackoverflow.com/questions/168736/how-do-you-set-a-default-value-for-a-mysql-datetime-column
https://stackoverflow.com/questions/54007824/how-to-set-sql-mode-in-my-cnf-in-mysql-8
Also check the parameter for legacy dates in my.cnf
[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTIONHave a look at reporting/includes/header2.inc
Also refer the wiki and look for "Header2.php file in Watermarking and background of reports"
"Arabic in FA" in https://frontaccounting.com/fawiki/index.php?n=Help.InstallUpdateLanugages
Create a new company with the en_US-demo.sql Chart of Accounts.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.