151

(18 replies, posted in Announcements)

Announcement

This is a 2.4.13 release, which is mainly a seriously bugfix release, but also contains an improvement and additional security fixes.

More php 8 problems has been fixed. This release should now be PHP 8 compatible. The following versions has been tested: 8.0.0, 8.0.7, 8.0.12 and 8.1.6. In Mysql 8, groups is a reserved word and was fixed by adding Backticks. Was only a problem when no table prefixes was used.

Please report any bugs/problems found via our Mantis Bugtracker at [size=5]http://mantis.frontaccounting.com.

Download instructions

In Sourceforge FrontAccounting (http://sourceforge.net/projects/frontaccounting), select
Files -> FrontAccounting 2.4 ->2.4.13.

For Windows users select the zip file. For all other users select the tar.gz file.

Common

  • php8: strpos(): Passing null to parameter #1 ($haystack) of type string in date_functions.inc is deprecated. Fixed.

  • php8: error. class.mail.inc. line 149. #5 parameter cannot be null.

  • Feature. Show also Upcoming Purchase Invoices in Dashboard.

  • FA should not be used via unsecure http protocol. If you really need this - change SECURE_ONLY constant in session.inc (comment in the file added).

Sales

  • Invoice not converting from Delivery Note due to PHP 8 floating bug (dec in units).

  • php8: cannot generate recurring invoices. Fixed.

  • Customer Credit note could be posted without customer selected when search customer List is enabled in Company Setup. Fixed.

  • php8: array bool error in customer-payments.php fixed.

Purchasing

  • get_stock_gl_code function called twice in the add_supp_invoice. Fixed.

  • Supplier Invoice and Credit Note can be posted without supplier selected when search supplier List is enabled in Company Setup. Fixed.

Bank and General Ledger

  • Incorrect Journal Balance (from sales invoice) when many decimals in tax and price. Fixed.

_________________________

This has been fixed both on Customer and supplier side. Committed to stable repo.

/Joe

I will have a look.

Joe

The problem has now been solved. In certain cases you will get an extra line with a rounding error, when this happens.

This way the journal vouchers will always balance.

It has been committed to stable repo.

You can download the fixed /gl/includes/db/gl_db_trans.inc from here,

Joe

Hello again @DrCard,

Yes, I can reproduce your error.

Something has been changed internal that has caused this rounding error. We will investigate and fix this asap.

Joe

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 have now installed Mysql 8.0.27 and tested and everything works fine with the two fixed files. Both without table pref and with.

I will now push the files to stable repository

/Joe

@bradlanier

You are of course also welcome to test this. Please replace the files on your server and report back. Thanks in advance.

Joe

Hello again.

@barbarian

I have tried to fix this with backticks where ever the table is included in an sql statement.
It is ok on a table prefix, I have tested.
But what about without table prefix.

Will you replace the two downloaded files /sales/includes/db/sales_groups_db.inc and /includes/ui/ui_lists.inc and see if it works in Mysql 8 without table prefix.

Thanks in advance.

/Joe

We will have to backtick the group's table in SQL statements, I guess. Let me have a look at this.

Joe

This has now been fixed and committed to stable repo.

A file for replacement on yr server (/includes/dashboard.inc) can be downloaded here.

Joe

Good Idea. Will have a look into this.

Maybe we could change the header to 'Unpaid Invoices' and then show the overdue items in overdue color.

Joe

$bobloblian has now solved the problems. The side errors in response theme and the class.mail.inc file has been resulved and pushed into repo.
@bobloblian reported this as a bug 5625 on Mantis where the problems can be followed.

Joe

Hello all!

$bobloblian has a problem showing the credit note. As told I can not reproduce the error. Do any of you have this error, then please report it. Or if you have had the problem and found a resolution.

Joe

Hello @bobloblian,

I am sorry, but I cannot reproduce this. I am using php 8.1.6, FA 2.4.12. Wamp Apache 2.4.46.
Also tried PHP 8.0.0. No problems. $go_debug = 2.

Any messages from Apache log?

/Joe

Hello,
If the date.timezone is not set then we set the date.timezoen to Europe/Berlin.
Normally the date.timezone is set in the PHP.INI file or you can set it to a suitable value.

I have checked for this error in the apache log, but can not reproduce this.

The problem with recurrent invoices has now been resolved. Look in that topic.

But please investigate further. Thanks.

Joe

This has now been fixed. The problem was a php 8 error. Committed to stable repo.

The fixed file can be downloaded here and replaced on yr server.

Joe

I will look at this asap.

Joe

I will check this. Thanks.

Joe

Hello,

I can not reproduce this error. Will you try again?

Joe

I will have a look at it.

Joe

Hello again,

I found the problem. It was not inside function check_num, but from function check_quantities in customer_invoice.php and customer_delivery.php.
Inside these functions the $max value was calculated and due to a floating bug in PHP got a very small overlay.
This has been fixed in these two functions, check_quantities.

/sales/customer_delivery.php can be downloaded here.
/sales/customer_invoice.php can be downloaded here.

Joe

Hello @dz.
Yes I will be glad to assist, had I have a clue about this. We are working otherwise with a DELTA value in current_user.inc (about line 540), can this be used?
Does any expert on this have a good solution?

Joe

Fixed and committed to stable repo. Thanks.

Joe

I would recommend an upgrade to Frontaccounting release 2.4.12 that has just been released on Sourceforge.net.
Most PHP 8 problems have been fixed.

Joe