This post has what you need. If you need to put it in the db connection script see this post for FA 2.3 and port it accordingly into the mysql/mysqli connect scripts. @braathwaate's instructions were for PHP versions.
2,852 08/08/2017 04:42:37 pm
Re: Fully Editable Purchase Return (1 replies, posted in FA Modifications)
In your Purchase Return file, you will have a copy of the function check_data() where the error emanates. Try to capture the value of the price form field variable and check what rounding off error causes it based on PHP version, MySQL version and Apache version nuances apart from platform dependancies - mention these versions and which version of FA you are using.
2,853 08/07/2017 05:53:57 pm
Re: Tutorial for using barcode class (1 replies, posted in FA Modifications)
https://frontaccounting.com/fawiki/index.php?n=Devel.BarCodeUsage
2,854 08/07/2017 02:01:26 pm
Re: Ajax (Javascript request) Stopped after updating Apache (14 replies, posted in Report Bugs here)
Contact offline - PM.
2,855 08/07/2017 02:00:25 pm
Re: Can't Enter Supplier Invoice (8 replies, posted in Accounts Payable)
Clear all browser cache and try it.
That is the setting that should do it unless it is a scope / visibility issue.
@joe?
2,856 08/07/2017 01:59:01 pm
Re: Error Rounding with Tax (8 replies, posted in Accounts Payable)
https://stackoverflow.com/questions/4921466/php-rounding-error
Try on a 64 bit machine.
Provide details of PHP version number and Apache/mySQL/OS versions.
2,857 08/07/2017 02:11:25 am
Re: Ajax (Javascript request) Stopped after updating Apache (14 replies, posted in Report Bugs here)
What OS and version are you hosting your FA? Is your OS fully updated? Provide Apache/PHP/MySQL versions.
2,858 08/06/2017 05:04:49 pm
Re: Item category and item type (1 replies, posted in Items and Inventory)
Checkout FA v2.4.2 and check and let us know. When a category is set with TaxType (specific to that item) along with ItemType if any, it is a default lookup value that can be changed by the end user for any specific voucher causing the anomaly you allude to. The choice actually determines what default accounts are to be used in the form.
2,859 08/06/2017 04:36:38 pm
Re: Ajax (Javascript request) Stopped after updating Apache (14 replies, posted in Report Bugs here)
Try a new install of FA 2.4 and see if that works.
2,860 08/06/2017 04:35:24 pm
Re: I get warning Message (3 replies, posted in Announcements)
Provide details of your install.
Server OS and versions of PHP/MySQL/Apache ?
What version did you upgrade from and to?
Did you have any extensions loaded (like Fixed Assets) before the upgrade? Fixrd Assets s now part of FA 2.4.x.
If you upgraded your Apache from 2.2 to 2.4 adjust your apache conf file.
If you have PHP 7+ and/or you have MySQL >= 5.7 then you will need to search the forums for fixes.
If you are technically challenged, take professional assistance by posting a bounty in the Job Board topic..
2,861 08/05/2017 05:57:03 pm
Re: Ajax (Javascript request) Stopped after updating Apache (14 replies, posted in Report Bugs here)
Delete the js cache files in <FA webroot>/company/#/js_cache/#/*.js
2,862 08/05/2017 01:27:52 pm
Re: Ajax (Javascript request) Stopped after updating Apache (14 replies, posted in Report Bugs here)
When you changed from Apache 2.2 to 2.4 you will need to change the "allow,deny" directives to "Require all granted" in the apache conf file. See what changes need to be done on such migration. Also see if the file ownership and permissions of the webroot and below are available for the webserver process.
https://serverfault.com/questions/739427/script-to-migrate-apache-2-2-to-2-4-configuration-files
https://www.digitalocean.com/community/tutorials/migrating-your-apache-configuration-from-2-2-to-2-4-syntax
http://httpd.apache.org/docs/current/upgrading.html
2,863 08/05/2017 01:25:01 pm
Re: VAT Not being properly Journalised on Direct Purchase (3 replies, posted in Accounts Payable)
What did you do differently that made it work now?
2,864 08/05/2017 02:18:20 am
Re: How $Ajax->activate works (1 replies, posted in FA Modifications)
The relevant links are:
https://frontaccounting.com/fawiki/index.php?n=Devel.AjaxInFA
https://frontaccounting.com/punbb/viewtopic.php?id=5340
Excerpt from KVCodes Article:
JsHttpRequest – This files helps you to perform the Ajax operations on live. When you select an option from the Drop down select, it will send a request to get all the relevant informations based on the item you selected on the drop down box. Also helps to perform the Live edit and delete as well.
insert.js and util.js – This files helps to fetch the informations for the AJAX Calls.
2,865 08/05/2017 02:12:02 am
Re: VAT Not being properly Journalised on Direct Purchase (3 replies, posted in Accounts Payable)
Screenshot of the transaction's GL Entries onscreen would be useful. By "VAT control account" did you mean "VAT Payable Account" ?
2,866 08/05/2017 02:09:16 am
Re: Ajax (Javascript request) Stopped after updating Apache (14 replies, posted in Report Bugs here)
2,867 07/31/2017 07:08:10 pm
Topic: Default C Language errors (9 replies, posted in Installation)
When no language is chosen for the FA user interface, the fallback language is "C".
Older PHP versions did not have native gettext support or it was not compiled into it or it was not enabled in the php.ini.
For such instances, the fallback was a language translation array that was generated if the <locale>.php file was not compiled after the corresponding .po file.
If the lang/new_language_template/C.php, then it would throw up errors in the tmp/errors.log file.
To mitigate this, in the includes/lang/gettext.inc file, after:
function _load_domain($domain, $path = "./locale")
{
$src_domain = $path . "/$this->_lang_code/LC_MESSAGES/$domain.po";
$php_domain = $path . "/$this->_lang_code/LC_MESSAGES/$domain.php";insert the following:
if ( $this->_lang_code == 'C' ) {
$src_domain = $path . "/new_language_template/LC_MESSAGES/empty.po";
$php_domain = $path . "/new_language_template/LC_MESSAGES/C.php";
}and create the file lang/new_language_template/C.php with the following contents:
<?php
return array();This fix is available in my FA24Mods commit.
2,868 07/31/2017 06:53:12 pm
Topic: Session errors (1 replies, posted in Installation)
If you are getting a lot of errors in tmp/errors.log for logout.php file, it is because of the last 2 lines in it. The error lines would be like:
[31-Jul-2017 13:53:27] 0::logout.php:50:[before upgrade] session_destroy() [<a href='function.session-destroy'>function.session-destroy</a>]: Session object destruction failedThe following links have more info on it:
https://stackoverflow.com/questions/8549757/why-session-object-destruction-failed
https://stackoverflow.com/questions/3538513/detect-if-php-session-exists
https://github.com/yiisoft/yii2/commit/457abe8939b0d1b7b41c33c4c335d7d6b8ae83a6
2,869 07/31/2017 04:20:26 pm
Re: Release file in repository is invalid, or public key is outdated (1 replies, posted in Translations)
Delete the modules\_cache\*.gz files and try again after clearing all browser cache and make sure you have the correct FA.pem file in your FA webroot.
2,870 07/31/2017 04:11:28 pm
Re: Release 2.4.2 (11 replies, posted in Announcements)
The zip of changed files between FA 2.4.1 and 2.4.2 is attached.
2,871 07/31/2017 08:02:04 am
Re: Release 2.4.2 (11 replies, posted in Announcements)
Non default company login after files upgrade results in:
Access to application has been blocked until database upgrade is completed by system administrator.WinXPSP3 / FireFox 37.0.2 / XAMPP 1.7.3 (Apache 2.2 / MySQL 5.0 / PHP 5.3.1.
Default Company login is okay. The Database version shows 2.4.1 in Setup -> Software Upgrade for all companies. Doing a software upgrade on each company does not alleviate the issue.
Since there is no db change in this version, the $db_version variable should have remained '2.4.1'. in version.php. Kindly revert.
2,872 07/30/2017 06:32:36 pm
Re: disable edit (1 replies, posted in Accounts Receivable)
Fine grained permissions like this needs custom modules to be written. Currently not available in FA.
2,873 07/29/2017 07:57:00 am
Re: HR and Payroll Module (66 replies, posted in Modules Add-on's)
"Nomina and Human Resources" ??
Did you mean Spanish "Nomina" to be "Appointment" or "Approval "?
There is no "Approval" system in default FrontAccounting for now.
There is no standard "Payroll / Recruitment (Appointment) / HR" module for FrontAccounting. Some users have created it for themselves and some have put it up for free use. @Farhaj and @kvvaradha have commercial ones. @notrinos has an open source one.
2,874 07/28/2017 01:35:27 pm
Topic: Tabs to 4 space indentation (0 replies, posted in Report Bugs here)
The FA codebase currently has a mixture of tabs and spaces used for indentation. To convert all such tabs into 4 space indentations we use the linux sponge command from moreutils package which does not alter the file permissions / ownerships / possibly timestamps.
cd /var/www/webroot
# Upload the core files
unzip core.zip
mv core core_org
unzip core.zip
apt-get install moreutils
cd core
find ./ -name '*.php' -type f -exec bash -c 'expand -t 4 "$0" | sponge "$0"' \{\} \;
find ./ -name '*.inc' -type f -exec bash -c 'expand -t 4 "$0" | sponge "$0"' \{\} \;
find ./ -name '*.css' -type f -exec bash -c 'expand -t 4 "$0" | sponge "$0"' \{\} \;
find ./ -name '*.js' -type f -exec bash -c 'expand -t 4 "$0" | sponge "$0"' \{\} \;
cd ..
diff -r core_org core > fa24_t2s.diff
tar -czf fa24_t2s.diff.tar.gz fa24_t2s.diff
zip -r core.zip core2,875 07/28/2017 11:53:18 am
Re: Advance Manufacture Stock Status (2 replies, posted in Manufactoring)
As @joe said, there is no need to issue items that are already there in the BoM as they would get issued when manufactured.
FA v2.3.5 was released on 2011-06-09.
The manufacturing/work_order_entry.php file is one of the files that manages your issue and was changed marginally during the release of FA v2.3.14 on 2013-01-18.
On 2014-09-22, there was a commit titled:
Fixed stock quantity checks to block transactions which would result in negative inventory status (if not allowed).
It is possible that other issues in this arena may been subsequently set right.
Kindly upgrade to the final edition of FA v2.3.26+ for best results.
