nonstop Invoice creation & delivery

[Timothin]

I have two invoice deliveries that the date sent didn't get updated so every 5 minutes the clients are being sent the invoice over and over again. The invoice is being generated over and over again as well to be sent.

Any ideas on how to stop this or fix this?

 

Thanks

[Timothin]

I was able to fix this by adding an invoice sent date via mysql. Hopefully this was a onetime thing.

[Blesta Addons]

what is the package term and the date added and date renew ?

[Timothin]

  On 12/17/2017 at 9:32 PM, Blesta Addons said:

what is the package term and the date added and date renew ?

Expand  

Monthly, date renew is dec. 31 2018 for one and jan 14 2018 for the other. The added is dec 15 and dec21 2016.

[Jono]

  On 12/17/2017 at 6:28 PM, Panfilo said:

I have two invoice deliveries that the date sent didn't get updated so every 5 minutes the clients are being sent the invoice over and over again. The invoice is being generated over and over again as well to be sent.

Expand  

Are these being sent by email?  Did  you check the logs under Tools >> Logs >> Email to make sure they are actually being sent?

[Timothin]

  On 12/18/2017 at 6:12 PM, Jono said:

Are these being sent by email?  Did  you check the logs under Tools >> Logs >> Email to make sure they are actually being sent?

Expand  

Yes, they were being sent by email. In the Tools >> Logs >> Invoice Delivery, the Date Sent was blank. So the Tools >> Logs >> Email was full of emails being sent every 5 minutes of the same invoice being created, over and over again. The invoice wasn't being generated every 5 minutes but the email was getting generated every 5 minutes and sent.

[Jono]

  On 12/18/2017 at 8:43 PM, Panfilo said:

So the Tools >> Logs >> Email was full of emails being sent every 5 minutes of the same invoice being created, over and over again.

Expand  

So the email logs have a status of 'Sent'?

[Timothin]

  On 12/18/2017 at 10:14 PM, Jono said:

So the email logs have a status of 'Sent'?

Expand  

Yes, they have status of 'Sent' but in the "Invoice Delivery" no "Date Sent" was ever recorded so it kept looping.

[Timothin]

  On 12/18/2017 at 10:14 PM, Jono said:

So the email logs have a status of 'Sent'?

Expand  

This issue keeps happening every time I create an invoice. Any idea what it could be?

[Tyson]

You mentioned earlier that the emails had no "Date Sent". Are there any errors? When you 're on the Tools > Logs > Emails page, you can click on one of the table rows to expand it and see the email. Below that, and below the "Resend" link at the bottom there would be an error message shown if there was an error. What is the error, if any?

[Timothin]

  On 12/20/2017 at 9:04 PM, Tyson said:

You mentioned earlier that the emails had no "Date Sent". Are there any errors? When you 're on the Tools > Logs > Emails page, you can click on one of the table rows to expand it and see the email. Below that, and below the "Resend" link at the bottom there would be an error message shown if there was an error. What is the error, if any?

Expand  

No errors at all.

[Paul]

I see you are running Blesta 4.1.2. When you upgraded, did you run /admin/upgrade to run the database migrations? Settings > System > General has a logs directory defined. Check the directory for logs, it may contain errors.

[Timothin]

  On 12/21/2017 at 5:00 PM, Paul said:

I see you are running Blesta 4.1.2. When you upgraded, did you run /admin/upgrade to run the database migrations? Settings > System > General has a logs directory defined. Check the directory for logs, it may contain errors.

Expand  

This was a fresh install of 4.1.2. Will be updating to 4.2, hoping issue will be fixed.

[Timothin]

problem persists after 4.2 upgrade. @Paul @Tyson

[Timothin]

  On 12/21/2017 at 5:00 PM, Paul said:

I see you are running Blesta 4.1.2. When you upgraded, did you run /admin/upgrade to run the database migrations? Settings > System > General has a logs directory defined. Check the directory for logs, it may contain errors.

Expand  

@Paul I have the following error in that file leading to the upgrade and after:

[2017-12-26 18:44:00] general.WARNING: E_WARNING: sprintf(): Too few arguments {"code":2,"message":"sprintf(): Too few arguments","file":"blesta/vendors/minphp/language/src/Language.php","line":125} 

[Paul]

  On 12/26/2017 at 7:08 PM, Panfilo said:

@Paul I have the following error in that file leading to the upgrade and after:

[2017-12-26 18:44:00] general.WARNING: E_WARNING: sprintf(): Too few arguments {"code":2,"message":"sprintf(): Too few arguments","file":"blesta/vendors/minphp/language/src/Language.php","line":125} 

Expand  

That line of code has to do with fetching text from the loaded language file. Are you running a custom language file, or a language other than en_us that ships with Blesta? Any modifications to it? There may be an issue with one of your language files.

[Timothin]

  On 12/26/2017 at 7:15 PM, Paul said:

That line of code has to do with fetching text from the loaded language file. Are you running a custom language file, or a language other than en_us that ships with Blesta? Any modifications to it? There may be an issue with one of your language files.

Expand  

Not that I am aware of. Using blesta straight out of the box. Anything I need to double check?

[Paul]

  On 12/26/2017 at 7:17 PM, Panfilo said:

Not that I am aware of. Using blesta straight out of the box. Anything I need to double check?

Expand  

Have you already tried re-uploading Blesta, overwriting existing files? Sometimes FTP programs will change line endings of the files, though this shouldn't really break it, I wonder if something like that may have happened. (Don't delete and upload, you need to keep /config/blesta.php, so maybe back that up first). My guess is this wont matter since you upgraded to 4.2 recently though.

What version of PHP are you running? Do you have multi-php where you can select a different version to test? What version of MySQL/Mariadb?

[Timothin]

  On 12/26/2017 at 7:21 PM, Paul said:

Have you already tried re-uploading Blesta, overwriting existing files? Sometimes FTP programs will change line endings of the files, though this shouldn't really break it, I wonder if something like that may have happened. (Don't delete and upload, you need to keep /config/blesta.php, so maybe back that up first). My guess is this wont matter since you upgraded to 4.2 recently though.

What version of PHP are you running? Do you have multi-php where you can select a different version to test? What version of MySQL/Mariadb?

Expand  

PHP 7.0, mysql: 5.6.38

[Timothin]

@Paul I found the problem... Doesn't seem to be a Blesta problem. 

@Blesta Addons 's html_invoice when selected doesn't update the date_sent so it sends infinitely. All other options work just fine.

  Thanks for everyone's patience

[Paul]

  On 12/26/2017 at 8:12 PM, Panfilo said:

@Paul I found the problem... Doesn't seem to be a Blesta problem. 

@Blesta Addons 's html_invoice when selected doesn't update the date_sent so it sends infinitely. All other options work just fine.

  Thanks for everyone's patience

Expand  

So it's an issue in the 3rd party HTML invoice?

[Timothin]

  On 12/26/2017 at 9:54 PM, Paul said:

So it's an issue in the 3rd party HTML invoice?

Expand  

Yes, believe so.

[Blesta Addons]

  On 12/26/2017 at 8:12 PM, Panfilo said:

@Paul I found the problem... Doesn't seem to be a Blesta problem. 

@Blesta Addons 's html_invoice when selected doesn't update the date_sent so it sends infinitely. All other options work just fine. 

  Thanks for everyone's patience

Expand  

not sure how the html_invoice components has related to this, is only a viewer of the invoice,  he has nothing to do with populating a database fields !!!