#983 – Components - invoicing

Posted in ‘Support’

This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Wednesday, 03 November 2021 18:52 CET

pinprop

Joomla! version : 3.10.3
PHP version : 7.4.25
AdsManager version : 3.2.14

menu - components, invoicing

page shows

An error has occurred.

1525 Incorrect DATETIME value: '2021'

Return to Control Panel

How do I fix this?

Custom Fields

Joomla Version: 3.10.3
PHP Version: 7.4.25
Product: AdsManager
Product Version: 3.2.14

Friday, 05 November 2021 10:47 CET

loic

Hello,

This is a known issue, in administrator/components/com_invoicng/models/invoices.php, line 463, replace the line :

$condition = "`created_on` > '".date("Y",strtotime('today - 2 months'))."' AND `created_on` < '".date("Y-m-01")."'";

By:

$condition = "`created_on` > '".date("Y-m-01",strtotime('today - 2 months'))."' AND `created_on` < '".date("Y-m-01")."'";

We just add the month and the day to the year.

That fix will be released with the next version.

Best regards.

Tuesday, 23 November 2021 09:04 CET

pinprop

Thanks - now working

This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.