Post by chrisgwynne » Fri Sep 29, 2017 10:43 pm

Hello I'm receiving these errors with PayPal Extension

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
Any ideas?? Im lost.

New member

Posts

Joined
Fri Nov 11, 2016 7:33 am

Post by yodapt » Fri Sep 29, 2017 11:04 pm

What's the exact Opencart version?

Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com


User avatar
Active Member

Posts

Joined
Fri Jun 17, 2011 6:39 pm


Post by chrisgwynne » Sat Sep 30, 2017 12:19 am

2.3.0.2

New member

Posts

Joined
Fri Nov 11, 2016 7:33 am

Post by yodapt » Sat Sep 30, 2017 12:26 am

That error shouldnt exist. Try reinstalling it to recover the database tables.

Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com


User avatar
Active Member

Posts

Joined
Fri Jun 17, 2011 6:39 pm


Post by chrisgwynne » Sat Sep 30, 2017 12:55 am

Do I need to remove it entirely? Is there 2.3.0.2 updates to the paypal plugins?

New member

Posts

Joined
Fri Nov 11, 2016 7:33 am

Post by yodapt » Sat Sep 30, 2017 1:08 am

No updates that I know of.

If you have data in there that you dont want to loose, you could try restore the table field that is missing :

Code: Select all

ALTER TABLE `oc_paypal_iframe_order` ADD `date_added` DATETIME NULL

Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com


User avatar
Active Member

Posts

Joined
Fri Jun 17, 2011 6:39 pm


Post by chrisgwynne » Mon Oct 02, 2017 1:30 am

Thanks for that, I ran that query. Still getting errors though...

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

New member

Posts

Joined
Fri Nov 11, 2016 7:33 am

Post by yodapt » Mon Oct 02, 2017 8:37 pm

I dont understand why those fields are missing, looks like something removed them for some reason ..

Run this one :

Code: Select all

ALTER TABLE `oc_paypal_iframe_order` ADD `date_modified` DATETIME NULL

Opencart Developer - My Extension Showcase
Contact me at aeon.yoda@gmail.com


User avatar
Active Member

Posts

Joined
Fri Jun 17, 2011 6:39 pm

Who is online

Users browsing this forum: No registered users and 9 guests