Invoice Database Error After Making Payment


v 1.3.1

I’ve been doing some testing, I experiencing the following error after attempting to pay for an invoice via PayPal (sandbox).

A quote was created for a user then converted to an invoice. That user account was access via the client side after which the “Pay Now” button was clicked, I was then directed to PayPal (sandbox) used the credentials to make the payment on the amount.

However after PayPal processed the payment the following error was generated.

A Database Error Occurred

Error Number: 1146

Table ‘dbname.invoice_id’ doesn’t exist

SELECT * FROM (invoice_id) WHERE invoice_id = ‘1’

Filename: \appname\system\database\DB_driver.php

Line Number: 331

Despite the above error the payment was collected and applied to the invoice but it was not marked as paid.

Note: this was the first and only invoice created.

How can this be fixed?

Duplicate of Error changing invoice value to "PAID' after upgrading to v1.3.0
Please search before adding a new thread.