Page 1 of 1

PayPal Pro Iframe

Posted: Thu Nov 30, 2017 11:17 pm
by chrisgwynne
Not sure if it's just me with these problems with this module :laugh:

Tried reusing today as PayPal are forcing PCI compliance upon me! Anyway, using 2.3.0.2. I'm using a one page checkout extension.

Code: Select all

Stack trace:
#0 /home/xxx/public_html/system/library/db.php(16): DB\MySQLi->query('INSERT INTO `oc...', Array)
#1 /home/xxx/public_html/catalog/model/extension/payment/pp_pro_iframe.php(33): DB->query('INSERT INTO `oc...')
#2 [internal function]: ModelExtensionPaymentPPProIframe->addOrder(Array)
#3 /home/xxx/public_html/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(189): call_user_func_array(Array, Array)
#4 [internal function]: Loader->{closure}(Array, Array)
#5 /home/xxx/public_html/system/engine/proxy.php(25): call_user_func_array(Object(Closure), Arra in /home/xxx/public_html/system/library/db/mysqli.php on line 40
[30-Nov-2017 11:41:54 UTC] PHP Fatal error:  Uncaught exception 'Exception' with message 'Error: Unknown column 'date_added' in 'field list'<br />Error No: 1054<br />INSERT INTO `oc_paypal_iframe_order` SET `order_id` = '3814', `date_added` = NOW(), `date_modified` = NOW(), `capture_status` = 'Complete', `currency_code` = 'GBP', `total` = '-0.63', `authorization_id` = '8EV3857859168252A'' in /home/xxx/public_html/system/library/db/mysqli.php:40
Any help is appreciated. Orders are coming through as Cancelled every time.

Re: PayPal Pro Iframe

Posted: Thu Nov 30, 2017 11:53 pm
by straightlight
[30-Nov-2017 11:41:54 UTC] PHP Fatal error: Uncaught exception 'Exception' with message 'Error: Unknown column 'date_added' in 'field list'<br />Error No: 1054<br />INSERT INTO `oc_paypal_iframe_order`
The date_added field is missing in your oc_paypal_iframe_order database table.