Post by reflexweb » Thu Jul 24, 2014 6:28 pm

HI Everyone

I have v1.5.6 installed and working just great using the 'PayPal Payments Standard' gateway.

We have just upgraded to 'PayPal Payments Pro' and activated the PayPal Payments Pro (UK) module

When testing LIVE the order shows ok in orders as complete :) yet the error log shows the followig which i think means a db table is missing?

copy from log

2014-07-24 9:36:03 - PHP Notice: Error: Table 'mysite_ocar176.oc_paypal_order_transaction' doesn't exist<br />Error No: 1146<br />SELECT * FROM `oc_paypal_order_transaction` `pt` LEFT JOIN `oc_paypal_order` `po` ON `pt`.`paypal_order_id` = `po`.`paypal_order_id` WHERE `pt`.`transaction_id` = '7Y649506M98597336' LIMIT 1 in /home/mysite/public_html/store/system/database/mysql.php on line 50

Can anyone shed any light on this ? Thanks all

New member

Posts

Joined
Thu Jun 28, 2012 8:06 pm

Post by paulfeakins » Thu Jul 24, 2014 10:06 pm

I managed to fix this for the OP.

The problem was that unless you have previously installed the PayPal Express extension, the table to store transactions doesn't exist.

So the fix is to click install on the PayPal Express payment module, even if you don't use it, and then PayPal Pro will work as expected.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Legendary Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom
Who is online

Users browsing this forum: Bing [Bot] and 19 guests