Recuring invoice : still problem with 1.5.4

Support
#1

Hi,

Since IP 1.5.3 (if I remember), my recurring invoices are stop working well.
In fact, there are not working at all :smiley:
Instead, each day, after the cron is launched, an old recurring invoice is created on IP and I have to remove it by hand.
And the legitimate recurring invoices are not created.

I though an update to 1.5.4 solve the issue, but no :frowning:

Here my last invoiceplane log : https://pb.spheerys.fr/?9ccb3198a4ef7ca2#DdAeFGpBbz6h3grKw4GYyaMxS0el+h1fc0/dzfN2u3g=

The apache log is not significant during cronjob :

163.bb.aa.xx - - [13/Sep/2017:22:24:24 +0200] "GET /invoices/cron/recur/tDFl**QIkjH7**UvkoR3 HTTP/1.0" 200 802 "-" "Wget/1.15 (linux-gnu)"

The cronjob is running at 00:10 each day
Iā€™m running IP on Ubuntu Trusty (14.04 LTS) with PHP 5.6.31

I have read almost all topic on this recurring invoice problem, without finding issueā€¦
I can give you any more information if needed, or I can try any tip missed on another topicā€¦

#2

Try php 7. This is the recommended version.

#3

Last line of your error log:

ERROR - 2017-09-13 22:24:24 --> Wrong cron key provided!

#4

It was a test at 22:24, not the result of the cronjob which has the right key.
I also had regenerate the key.

Iā€™ll see if I can upgrade to PHP 7.0.

Iā€™ll come back if the problem is still occurs :slight_smile:

#5

OK done !
There is good news : the ā€œgostā€ recurring invoices disappears after upgrade to PHP 7 (I had to remove them manually before) !
But now I have to confirm than regular recurring invoices appearing well on the right date.

I will keep it touch :slight_smile:

#6

Okay, if itā€™s working with PHP7 itā€™s related to the issue that was posted in the release thread: InvoicePlane 1.5.4 released

#7

The latest version only works fine with PHP 7

#8

So itā€™s not solved now.

Here the log during the cron call :

DEBUG - 2017-09-15 11:25:09 --> UTF-8 Support Enabled
DEBUG - 2017-09-15 11:25:09 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2017-09-15 11:25:09 --> Cron MX_Controller Initialized
DEBUG - 2017-09-15 11:25:09 --> Config file loaded: /home/me/web/invoiceplane.domain.tld/public_html/application/config/invoice_plane.php
DEBUG - 2017-09-15 11:25:09 --> Encryption: Auto-configured driver 'openssl'.
DEBUG - 2017-09-15 11:25:09 --> File loaded: /home/me/web/invoiceplane.domain.tld/public_html/application/modules/settings/models/Mdl_settings.php
DEBUG - 2017-09-15 11:25:09 --> File loaded: /home/me/web/invoiceplane.domain.tld/public_html/application/controllers/../modules/layout/controllers/Layout.php
DEBUG - 2017-09-15 11:25:09 --> Layout MX_Controller Initialized
DEBUG - 2017-09-15 11:25:09 --> File loaded: /home/me/web/invoiceplane.domain.tld/public_html/application/modules/invoices/models/Mdl_invoices_recurring.php
DEBUG - 2017-09-15 11:25:09 --> File loaded: /home/me/web/invoiceplane.domain.tld/public_html/application/modules/invoices/models/Mdl_invoices.php
DEBUG - 2017-09-15 11:25:09 --> File loaded: /home/me/web/invoiceplane.domain.tld/public_html/application/modules/invoice_groups/models/Mdl_invoice_groups.php
DEBUG - 2017-09-15 11:25:09 --> File loaded: /home/me/web/invoiceplane.domain.tld/public_html/application/modules/invoices/models/Mdl_items.php
ERROR - 2017-09-15 11:25:09 --> Severity: Notice --> Undefined property: CI::$mdl_invoice_tax_rates /home/me/web/invoiceplane.domain.tld/public_html/vendor/codeigniter/framework/system/core/Model.php 77
ERROR - 2017-09-15 11:25:09 --> Severity: error --> Exception: Call to a member function where() on null /home/me/web/invoiceplane.domain.tld/public_html/application/modules/invoices/models/Mdl_invoices.php 252
#9

No idea about this error ?

#10

Could you post more information what tax rates are set for this particular invoice? Which ones are used and which settings are enabled?

#11

I donā€™t use at all the tax systemā€¦ Everything is disabled on the system settingsā€¦

#12

Near the line 77 of vendor/codeigniter/framework/system/core/Model.php there is this comment :

            // Debugging note:
            //      If you're here because you're getting an error message
            //      saying 'Undefined Property: system/core/Model.php', it's
            //      most likely a typo in your model code.

What do you mean by ā€œa typo in your model codeā€ ?

#13

This does not directly apply for InvoicePlane.

I will check this later. Either itā€™s a typo or somehow the property $mdl_invoice_tax_rates is not available at this time.

#14

ok thanks :slight_smile:

#15

Any news ? Because this bug is a little bit annoying : my recurring invoices doesnā€™t work for a long time now :frowning:

#16

Sorry but I have no time to work on InvoicePlane lately.

@Developers or @Contributors could anyone take a look at this?

Corresponding ticket is IP-577

#17

I have exact the same issue.

PHP7, just updated to 1.5.4 to see if the issue is there - unfortunately it is :frowning:

When calling the cron directly in the browser i get the same error as @Spheerys:
Message: Undefined property: CI::$mdl_invoice_tax_rates

And every time the cron runs a empty invoice is generated for a recurring invoice i already deletedā€¦

Regards,
Andreas

PS: i tried renaming the tax rate in preferences, because of ā€œ%ā€-character. This was mentioned in the Ticket IP-577. But the problem persists.

#18

Iā€™m happy to see Iā€™m not alone with this issue !
If you find a workaround before the official resolution, Iā€™m interested :slight_smile:

#19

I have the same issue, ANY UPDATES?

#20

This issue because the field ip_invoice_items.item_is_recurring is null when create invoice, I changed it manually to 1 in database and the recurring working OK.

How to set this field when creating an invoice?

1 Like