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
151 09/06/2022 03:11:30 pm
Re: Sales group query error in mysql 8 (7 replies, posted in Report Bugs here)
152 09/06/2022 12:39:55 pm
Re: Sales group query error in mysql 8 (7 replies, posted in Report Bugs here)
@bradlanier
You are of course also welcome to test this. Please replace the files on your server and report back. Thanks in advance.
Joe
153 09/06/2022 08:56:22 am
Re: Sales group query error in mysql 8 (7 replies, posted in Report Bugs here)
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
154 09/06/2022 06:28:57 am
Re: Sales group query error in mysql 8 (7 replies, posted in Report Bugs here)
We will have to backtick the group's table in SQL statements, I guess. Let me have a look at this.
Joe
155 08/15/2022 07:13:26 am
Re: Upcoming Purchase Invoices - in Dashboard (4 replies, posted in Wish List)
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
156 08/13/2022 03:04:18 pm
Re: Upcoming Purchase Invoices - in Dashboard (4 replies, posted in Wish List)
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
157 07/28/2022 09:28:25 am
Re: "credit this" from customer transactions screen leads to blank page (4 replies, posted in Accounts Receivable)
$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
158 07/27/2022 09:02:55 pm
Re: "credit this" from customer transactions screen leads to blank page (4 replies, posted in Accounts Receivable)
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
159 07/26/2022 09:02:59 pm
Re: "credit this" from customer transactions screen leads to blank page (4 replies, posted in Accounts Receivable)
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
160 07/22/2022 10:24:40 pm
Re: checkboxes not available on Reconcile page (9 replies, posted in Banking and General Ledger)
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
161 07/22/2022 10:02:16 pm
Re: cannot generate recurring invoices after upgrade to 2.4.12 (3 replies, posted in Accounts Receivable)
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
162 07/22/2022 04:19:35 pm
Re: cannot generate recurring invoices after upgrade to 2.4.12 (3 replies, posted in Accounts Receivable)
I will look at this asap.
Joe
163 07/22/2022 04:16:39 pm
Re: checkboxes not available on Reconcile page (9 replies, posted in Banking and General Ledger)
I will check this. Thanks.
Joe
164 07/22/2022 05:42:26 am
Re: checkboxes not available on Reconcile page (9 replies, posted in Banking and General Ledger)
Hello,
I can not reproduce this error. Will you try again?
Joe
165 07/22/2022 04:56:57 am
Re: checkboxes not available on Reconcile page (9 replies, posted in Banking and General Ledger)
I will have a look at it.
Joe
166 07/17/2022 10:03:10 am
Re: Invoice not converting from DN due to float bug (5 replies, posted in Report Bugs here)
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
167 07/15/2022 02:23:23 pm
Re: Invoice not converting from DN due to float bug (5 replies, posted in Report Bugs here)
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
168 07/15/2022 06:43:05 am
Re: get_stock_gl_code function called twice in the add_supp_invoice (1 replies, posted in Accounts Payable)
Fixed and committed to stable repo. Thanks.
Joe
169 07/14/2022 02:41:24 pm
Re: [Solved] All journals are closed after move to niew server (2 replies, posted in Installation)
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
170 07/13/2022 06:20:23 am
Topic: Release 2.4.12 (3 replies, posted in Announcements)
Announcement
This is a 2.4.12 release, which is mainly bugfix release, but also contains a couple of improvements and additional security fixes.
A lot of 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.
Please report any bugs/problems found via our Mantis Bugtracker at http://mantis.frontaccounting.com.
Download instructions
In Sourceforge FrontAccounting (http://sourceforge.net/projects/frontaccounting), select
Files -> FrontAccounting 2.4 ->2.4.12.
For Windows users select the zip file. For all other users select the tar.gz file.
Common
Fixed a couple of small bugs in Graphics engine.
Added SECURE_ONLY option in session.inc allowing explicit switching off https only access.
Dashboard Top 10 only show 1 record less than top. Fixed.
Sales Dashboard Aging total translation improvements.
PHP 8 Bug. Deprecated null value in class.graphic.inc parameter.
PHP 8.1 deprecated null parameters and missing file in reports fixed.
PHP 8.1 Deprecated null parameters. Clean UP local months names.
PHP 8.1 bug. Parameter to urlencode cannot be null in reporting.inc. Fixed.
Sales
Bug 5544: Notes from template were not used in recurring invoices.
Add and Manage Customers: contact persons were not removed when deleting customer.
Email invoice always says invoice 0 from company. Fixed.
Invoice Prepaid Orders: Added new payments column for direct review of order invoicing status.
Customer balances reports: fixed balance sums for prepayment invoices.
Fixed Long product Description on Sales Quotation.
Additional bugfixes for prepayment handling in sales reports (Customer Balances, Aged Customer Analysys, Customer Statements and Sales Invoice).
Removed delivery in a batch cannot be voided after the invoice is made. Fixed.
Purchasing
Add and Manage Suppliers: contact persons where not removed when deleting supplier. Fixed.
Typo in translatable string - Purchable Total. Fixed to Purchasable.
Translatable string typo in Purchasing/allocations/supplier_allocate.php fixed.
Feature 5623: added link to new supplier invoice after supplier payment.
Items and Inventory
Missing function 'delete_image' when deleting item. Fixed.
Bug 5599: Generating an EAN-8 Barcode throws an error "Trying to access array offset on value of type bool". Fixed.
Bank and General Ledger
Code cleanup (fixed parameter lists in gl_all_accounts_list_row and calls to subledger__list_cells).
Bank account transfers didn't have GL dimensions.
Journal Entry - Cursor skips through dimension field. Fixed.
Adding Assets Classes fails. Fixed.
Buttons missing on Chart of Accounts page (on some editions). Fixed.
Bug 5571 and 5572. Unable to void/edit transactions in php 8. Due to an error in audit_trail_db.inc. _('None') returns a positive value in php 8 and not a 0 value. Fixed.
171 07/10/2022 10:38:03 pm
Re: Removed delivery in a batch cannot be voided after the invoice is made (1 replies, posted in Report Bugs here)
Thie has been fixed and committed to stable repo. Thanks @advocaat.pollet for reporting this.
A fixed file, /admin/db/voiding_db.inc can be downloaded here.
Joe
172 06/23/2022 08:02:44 am
Re: Void a transaction gives error message (20 replies, posted in Banking and General Ledger)
This has been fixed and committed to stable repo. A fixed file can be downloaded here.
joe.
173 05/26/2022 02:02:59 pm
Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11 (12 replies, posted in Reporting)
174 05/22/2022 05:43:53 am
Re: Email Invoice heading 2.4.11 (11 replies, posted in Reporting)
Yes, this was fixed on Apr 18. Thanks @advocaat.
Joe
175 05/21/2022 03:29:20 pm
Re: Long Description on Sales Quotation not working FrontAccounting 2.4.11 (12 replies, posted in Reporting)
Well, we could implement @harshadmwasule's solution. Will ha a look at this when back in office.
Joe