After update this morning all my recurring invoices started sending

Yesterday I updated my invoice ninja to the latest version and this morning at 8 the recurring invoices started sending my customers invoices while the starting date was not standing on today.

At the moment the starting date for the recurring invoices is e.g. standing on 04-06-2017 while invoice ninja says that the next invoice will be sent on 12-12-2018 (today - next year).

I have searched in the database to check where I can see what the next sending date is to correct these to the start dates, but I cant really find it.

Does anybody have a clue why this could happen and how to prevent this for the future ?

Which version did you update to?

This could happen with v3.9 if you update the code but don’t run the migrations.

ah that’s what happened, since it takes ages to upload all the files to my ftp I uploaded everything yesterday but didn’t visit the site for migration.

is there anything I have to correct now in the database? since the recurring invoices say that they are gonna sent the next on 12-12-2018 instead of the selected start date?

I’d suggest setting the start date for the recurring invoices to the next date they should be sent.

Thanks, I’ll do that :slight_smile:

since it takes ages to upload all the files to my ftp I uploaded everything yesterday but didn’t visit the site for migration.

Why not just upload the zip file and uncompress it remotely? Most shared hosting solutions provide a file manager capable of this and any VPS/Dedicated server would also have this ability. Manually uploading each file via FTP will indeed take a very long time.

Shameless plug, but you could add this script to the root’s crontab on your VPS or dedicated server. When called, it checks the version you have installed against the current version listed at invoiceninja.org. If an update is required, it downloads the zip file, copies everything over, and runs the migrations all on its own.

Edit: Doesn’t necessarily have to be in the crontab, either. You could just have it sitting around (as long as the location is in your PATH listing) and run it manually with su whenever you want.