Jump to content

Recurring invoice bug


jmf421

Recommended Posts

I cannot for the life of me create  a new recurring invoice for a customer. I deleted his old invoice and wanted to setup a new one from a clean slate. Every time I setup the amount, renew date etc. I get the "Ok noe's" error - https://infinit.io/_/35Ji7Zg

 

I have tried this about 10 times with no luck, what will work is if I do not make it recurring, the invoice is created with a success message, as soon as I check the box for recurring it fails. I have about 20 other customers on a recurring invoice and it works fine so I am not sure whats wrong with this one. Is there a log I can look at to see what is happening?

Link to comment
Share on other sites

I don't encounter that issue myself on 4.0.0-b5, but the error you receive is very generic, shown when no known error is available. This means there is a wide range of possible reasons for the error, from server or web server configuration, php configuration, htaccess configuration, to custom code that may interfere with the it.

It would be useful to know exactly what information you're using to create the recurring invoice, what URL you are sent to on error, what version of Blesta you're using, if you have any custom code/plugins in your installation, and what versions of php, MySQL, web server, and OS you're using.

Link to comment
Share on other sites

37 minutes ago, Paul said:

You can also enable error reporting to see if any more information is displayed:

To enable error reporting, edit /config/blesta.php and change
 
Configure::errorReporting(0);

to
 
Configure::errorReporting(-1);

Awesome, thanks for the help. I turned on error reporting and it's now giving more info: https://infinit.io/_/37mhUEs

Any idea why I would just randomly start getting this error after creating lots of different invoices?

I am sent to this URL: https://clients.pixelpoynt.com/main/clients/createinvoice/10/

I am also on Blesta version 3.6.2

PHP version 5.5.30

 

Let me know if any additional info would be helpful! Thanks again, this is a huge help!

Link to comment
Share on other sites

18 minutes ago, Paul said:

Is this just a recurring invoice, unattached to a package? Look in the database in the invoice_recur_lines table for the column "taxable". Look at the data, what are the values there for this recurring invoice that you get the error with?

Yes this is just a recurring invoice that is not attached to any package. I looked in the database and there is nothing created for that customer being the error is occurring upon creation of the invoice. For all other customers is "0"

Link to comment
Share on other sites

Yeah up to this point all of my customers have the same type of invoices created with no issues. This customer never had an issue before either.

Whats interesting is if I check the box for "taxable" the invoice is created successfully. Then I go to the database and change the "1" to a "0" in the taxable column. I guess this works for now..

 

Link to comment
Share on other sites

3 hours ago, jmf421 said:

Yeah up to this point all of my customers have the same type of invoices created with no issues. This customer never had an issue before either.

Whats interesting is if I check the box for "taxable" the invoice is created successfully. Then I go to the database and change the "1" to a "0" in the taxable column. I guess this works for now..

 

That solved it for this customer? Or you have to check the box, and modify the database each time for this customer?

Link to comment
Share on other sites

17 minutes ago, jmf421 said:

Looks like its now happening for another customer so this may be the process moving forward. Not sure what happened recently but hopefully there is a fix.

It looks like Tyson created a task, CORE-2337 to look at this. If you have STRICT_TRANS_TABLES you may try disabling that to see if it makes any difference.

Link to comment
Share on other sites

13 minutes ago, Paul said:

It looks like Tyson created a task, CORE-2337 to look at this. If you have STRICT_TRANS_TABLES you may try disabling that to see if it makes any difference.

Ok that worked! I just updated the code in my.cnf and then restarted the mysql server. Then tested two separate customers and it seems to be working fine now. Thanks a ton!

Link to comment
Share on other sites

Not sure if this is related or not but I just had a customer try to pay an invoice and he get this error: The code its referring to on line 380 is 

<img src="https://secure.gravatar.com/avatar/<?php echo md5(strtolower(trim($contact->email))); ?>?d=mm" alt="avatar"> <i class="fa fa-angle-down"></i>

IMG_8192.thumb.PNG.bbcc94ea054a4c43b62c5bc3e0e9d8a9.PNG

Link to comment
Share on other sites

18 hours ago, jmf421 said:

Not sure if this is related or not but I just had a customer try to pay an invoice and he get this error: The code its referring to on line 380 is 


<img src="https://secure.gravatar.com/avatar/<?php echo md5(strtolower(trim($contact->email))); ?>?d=mm" alt="avatar"> <i class="fa fa-angle-down"></i>

IMG_8192.thumb.PNG.bbcc94ea054a4c43b62c5bc3e0e9d8a9.PNG

 

That error is unrelated to Blesta source. The error refers to a file that Blesta doesn't come with. The variable $contact is used when not set.

Link to comment
Share on other sites

On 2/17/2017 at 1:14 AM, jmf421 said:

Not sure if this is related or not but I just had a customer try to pay an invoice and he get this error: The code its referring to on line 380 is 


<img src="https://secure.gravatar.com/avatar/<?php echo md5(strtolower(trim($contact->email))); ?>?d=mm" alt="avatar"> <i class="fa fa-angle-down"></i>

 

change your code to

<img src="https://secure.gravatar.com/avatar/<?php echo md5(strtolower(trim($this->Html->ifSet($contact->email)))); ?>?d=mm" alt="avatar"> <i class="fa fa-angle-down"></i>

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...