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 (
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?