Order confirmation

[Guest]

Hi all,

 

I have a problem with the PAYPAL IPN Ver 2.6a on script build MS2.

 

I have the module installed for paymeny by Cheque or Mony Order.

 

If a user selects this opion for payment and then clicks on the order confirmation button it runs the script checkout_success.php. This is where I am getting an error.

 

1146 - Table 'db83706533.PAYPALIPN_TXN' doesn't exist

 

select o.orders_status,p.* from orders o LEFT JOIN PAYPALIPN_TXN p on p.item_number = o.orders_id AND o.customers_id = '2' order by o.date_purchased desc limit 1

 

I have checked that the table PAYPALIPN_TXN is there, and it is.

 

Can anyone help with this.

 

Kind regards

 

 

Dereck