Recurring invoice bug

[jmf421]

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?

[jmf421]

Anyone?

[Michael]

20 minutes ago, jmf421 said:

Anyone?

Blesta don't work over the weekend mate.

[jmf421]

Is this not a community forum where members help each other out?

[Tyson]

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.

[Paul]

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);

[Michael]

1 hour ago, jmf421 said:

Is this not a community forum where members help each other out?

only if we know why and what  we can't help if we don't know how or what it is lol

[jmf421]

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!

[Paul]

That's a database error. Have you made any manual changes to the database? Do you have taxes configured? You could try re-saving all your tax information.

[jmf421]

11 minutes ago, Paul said:

That's a database error. Have you made any manual changes to the database? Do you have taxes configured? You could try re-saving all your tax information.

I have not made any adjustments to the database and have not setup any tax information.

[Paul]

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?

[jmf421]

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"

[Paul]

Does the customer have  a tax exempt status that is different from customers that work? I'm assuming that recurring invoices for some customers work without error, is that right?

[jmf421]

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..

 

[Paul]

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?

[jmf421]

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.

[Paul]

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.

[jmf421]

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!

[jmf421]

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>

[Tyson]

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>

 

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.

[Blesta Addons]

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>