• joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Topic: Release 2.3.20

Announcement

This is a 2.3.20 security & bugfix release.

Important Note for release 2.3.20.

Warning:

This version consists crucial security patches, so all FA users running any earlier 2.3.x application version are encouraged to update their installations to version 2.3.20 as soon as possible. This applies especially to all installations which are run in not fully trusted environment like public demos, shared accounts or SAAS installations.

Common

  • Allowing more than one document attachment per number.

  • Voiding an allocated currency invoice doesn't clear Exchange account

  • Fixed a check that company logo exists when using header3.

  • Fixed security issues in file uploads.

  • Gettext template update.

Sales

  • Fixed back link presented when trying to modify fully invoiced Customer Delivery.

  • Link customer payment entry after saving Invoice (if not cash).

Purchasing

  • Supplier Payments: Fixed error during payment allocation in strict MySQL mode.

  • Fixed bug in Supplier Credit Note allocation to Purchase Invoice.

  • Supp credit notes should not be shown in allocable list.

Items and Inventory

  • Fixed inventory valuation bug after voiding foreign supplier GRN leading to negative inventory.

  • Inventory Items Movements always starts with 0 qty. Fixed.

Banking and General Ledger

  • Payments, Deposits: fixed false error when payment is made in customer/supplier currency.

  • Journal Inquiry (bank transaction view): fixed database error on bank transaction view triggered on some buggy MySQL versions.

  • Avoiding redundant passes in Fiscal Year deletion.

  • Supplier info not shown on gl inquiry for bank account.

  • If no memo on GL line in GL account inquiry, the comments for the voucher is shown on the line.

  • From: UK
  • Registered: 10/02/2012
  • Posts: 146

Re: Release 2.3.20

Hi

How do I download Diff files to upgrade me 2.3.19 version.

Thanks

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: Release 2.3.20

@dvarsani

You can just overwrite your existing files with the 2.3.20 tarball. Maybe @apmuthu has diff files for you. I hope he will comment on this.

Joe

4 Reply by apmuthu (edited by apmuthu 03/13/2014 07:37:16 am)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Release 2.3.20

Use WinMerge to get your diffs or install TortoiseGit and load in v2.3.19 and then v2.3.20 and possibly a post 2.3.20 snapshot. Easiest way like Joe said is to overwrite the files or do a fresh install and restore your db.

Will try to make a diff soon. Trying to get my version to sync with the official version first. Been away from the FA scene for a while now and need to check out the various changes done.

apmuthu's Website

5 Reply by apmuthu (edited by apmuthu 03/13/2014 07:35:27 am)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Release 2.3.20

Diff from FA v2.3.19 to v2.3.20 with fixes from official repo till date along with 2 unreleased fixes as well listed in forum posts 4795 and 4796.

Needs the following SQLs to be executed for upgrades (alter the "0_" to suit your company table prefix):

ALTER TABLE `0_debtor_trans` ADD INDEX `order_` (`order_`);
ALTER TABLE `0_users` CHANGE `query_size` `query_size` TINYINT(1) UNSIGNED NOT NULL DEFAULT 10;

The last sql referred to above is also an unreleased fix discussed at 4634 and is included in the sql files in this diff set and the CHANGELOG has been updated accordingly.

The above code is available in my unofficial FA GitHub Repo.

Post's attachments

FA_v2.3.19_to_v2.3.20_2014-03-12.zip 250.2 kb, 10 downloads since 2014-03-13 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

  • From: Indonesia, Japan
  • Registered: 01/08/2014
  • Posts: 190

Re: Release 2.3.20

Thank you. I have hugely modified FA 2.3.19. Is it possible to upgrade to this version? Or I must check manually from diff file and replace it? thank you

  • From: Pakistan, Lahore
  • Registered: 06/25/2013
  • Posts: 26

Re: Release 2.3.20

I have also the same problem, please reply sad

PHPdv's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Release 2.3.20

The attachment in my earlier post are the files that have changed since the previous version besides the SQLs that need to be executed for each company's db tables. These SQLs can be carried out first as they most probably will not have any dependency on your mods and certainly not on the rest of the standard code.

If you have the differences between FA v2.3.19 and you existing modded version, then you can incorporate the differences between the v2.3.19 and v2.3.20 into your modded version. Any extensions you have installed will make the issue a bit more involved just as any table schema changes in your modded version would entail as well.

apmuthu's Website

  • Registered: 12/25/2007
  • Posts: 2,446

Re: Release 2.3.20

If you have made your customization on top of official code repo clone  (either Hg or Git) you should not  have any problems with merging latest fixes. Otherwise you would advise to generate diff file between your code and the version it was made on top of, and apply it to the new FA version.
Janusz

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Release 2.3.20

Post 2.3.20 Changed Files till 2014-04-08.

Post's attachments

FA_Fixes_post_v2.3.20.zip 119.6 kb, 18 downloads since 2014-04-13 

You don't have the permssions to download the attachments of this post.

apmuthu's Website