Error with Paypal Pro

Code: Select all

[29-Sep-2017 14:32:23 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` = '3244', `date_added` = NOW(), `date_modified` = NOW(), `capture_status` = 'Complete', `currency_code` = 'GBP', `total` = '-6.49', `authorization_id` = '91M06009JX247351D'' in /home/xxx/public_html/system/library/db/mysqli.php:40
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/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), Array)
#6 /home/melod in /home/xxx/public_html/system/library/db/mysqli.php on line 40
[29-Sep-2017 14:32:51 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` = '3246', `date_added` = NOW(), `date_modified` = NOW(), `capture_status` = 'Complete', `currency_code` = 'GBP', `total` = '-6.49', `authorization_id` = '4VP83976SP985673A'' in /home/xxx/public_html/system/library/db/mysqli.php:40
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/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), Array)
#6 /home/melod in /home/xxx/public_html/system/library/db/mysqli.php on line 40
[29-Sep-2017 14:33:27 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` = '3246', `date_added` = NOW(), `date_modified` = NOW(), `capture_status` = 'Complete', `currency_code` = 'GBP', `total` = '6.49', `authorization_id` = '4Y402900B8044590A'' in /home/xxx/public_html/system/library/db/mysqli.php:40
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/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), Array)
#6 /home/melody in /home/xxx/public_html/system/library/db/mysqli.php on line 40

Code: Select all

ALTER TABLE `oc_paypal_iframe_order` ADD `date_added` DATETIME NULL

Code: Select all

[01-Oct-2017 15:20:13 UTC] PHP Fatal error:  Uncaught exception 'Exception' with message 'Error: Unknown column 'date_modified' in 'field list'<br />Error No: 1054<br />INSERT INTO `oc_paypal_iframe_order` SET `order_id` = '3265', `date_added` = NOW(), `date_modified` = NOW(), `capture_status` = 'Complete', `currency_code` = 'GBP', `total` = '11.99', `authorization_id` = '4L509492LK650864B'' in /home/xxx/public_html/system/library/db/mysqli.php:40
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/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), Array)
#6 /home/me in /home/xxx/public_html/system/library/db/mysqli.php on line 40
[01-Oct-2017 16:02:55 UTC] PHP Fatal error:  Uncaught exception 'Exception' with message 'Error: Unknown column 'date_modified' in 'field list'<br />Error No: 1054<br />INSERT INTO `oc_paypal_iframe_order` SET `order_id` = '3265', `date_added` = NOW(), `date_modified` = NOW(), `capture_status` = 'Complete', `currency_code` = 'GBP', `total` = '11.99', `authorization_id` = '4L509492LK650864B'' in /home/xxx/public_html/system/library/db/mysqli.php:40
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/system/storage/modification/system/engine/loader.php(189): call_user_func_array(Array, Array)
#4 [internal function]: Loader->{closure}(Array, Array)
#5 /home/xxxx/public_html/system/engine/proxy.php(25): call_user_func_array(Object(Closure), Array)
#6 /home/me in /home/xxx/public_html/system/library/db/mysqli.php on line 40

Code: Select all

ALTER TABLE `oc_paypal_iframe_order` ADD `date_modified` DATETIME NULL