Post by chrisgwynne » Fri Oct 13, 2017 2:22 am

Hey guys.... opencart 2.3.0.2

I'm continually running into errors paying by paypal. it's been working fine for a week, no source code has been touched, then a customer got in touch saying it's not working for them, so i went to try and its stalling for me. so i enabled a different paypal plugin and got these errors...

Code: Select all

[12-Oct-2017 18:16:13 UTC] PHP Fatal error:  Uncaught exception 'Exception' with message 'Error: Duplicate entry '3362' for key 'PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_paypal_payflow_iframe_order` SET `order_id` = '3362', `secure_token_id` = '05073e9871384fc52603a155890bfba8'' in /home/xxxx/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/xxxx/public_html/system/library/db.php(16): DB\MySQLi->query('INSERT INTO `oc...', Array)
#1 /home/xxxx/public_html/catalog/model/extension/payment/pp_payflow_iframe.php(45): DB->query('INSERT INTO `oc...')
#2 [internal function]: ModelExtensionPaymentPPPayflowIframe->addOrder('3362', '05073e9871384fc...')
#3 /home/xxxx/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/xxxx/public_html/catalog/controller/extension/payment/pp_payflow_iframe in /home/xxxx/public_html/system/library/db/mysqli.php on line 40
[12-Oct-2017 18:16:17 UTC] PHP Fatal error:  Uncaught exception 'Exception' with message 'Error: Duplicate entry '3362' for key 'PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_paypal_payflow_iframe_order` SET `order_id` = '3362', `secure_token_id` = '217d59256ff807bbfc3b99bd544cad1a'' in /home/xxxx/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/xxxx/public_html/system/library/db.php(16): DB\MySQLi->query('INSERT INTO `oc...', Array)
#1 /home/xxxx/public_html/catalog/model/extension/payment/pp_payflow_iframe.php(45): DB->query('INSERT INTO `oc...')
#2 [internal function]: ModelExtensionPaymentPPPayflowIframe->addOrder('3362', '217d59256ff807b...')
#3 /home/xxxx/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/xxxx/public_html/catalog/controller/extension/payment/pp_payflow_iframe in /home/xxxx/public_html/system/library/db/mysqli.php on line 40
[12-Oct-2017 18:16:50 UTC] PHP Fatal error:  Uncaught exception 'Exception' with message 'Error: Duplicate entry '3362' for key 'PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_paypal_payflow_iframe_order` SET `order_id` = '3362', `secure_token_id` = '869aff3c37a08f8c2bc2be7d2af1418a'' in /home/xxxx/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/xxxx/public_html/system/library/db.php(16): DB\MySQLi->query('INSERT INTO `oc...', Array)
#1 /home/xxxx/public_html/catalog/model/extension/payment/pp_payflow_iframe.php(45): DB->query('INSERT INTO `oc...')
#2 [internal function]: ModelExtensionPaymentPPPayflowIframe->addOrder('3362', '869aff3c37a08f8...')
#3 /home/xxxx/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/xxxx/public_html/catalog/controller/extension/payment/pp_payflow_iframe in /home/xxxx/public_html/system/library/db/mysqli.php on line 40

New member

Posts

Joined
Fri Nov 11, 2016 7:33 am

Post by chrisgwynne » Mon Oct 16, 2017 4:56 am

Anyone have any idea?

New member

Posts

Joined
Fri Nov 11, 2016 7:33 am

Post by ocdev » Wed Oct 18, 2017 11:05 pm

Hello,
I am using that module with 2.3.0.2 without problems - my only issue is the module does not show any notifications to the customer when the transaction is declined.
I would log into github and make sure you have the latest version for 2.3.0.2 (i need to check myself).
Steve

New member

Posts

Joined
Wed Sep 11, 2013 3:53 am
Location - Texas

Post by chrisgwynne » Thu Oct 19, 2017 6:30 pm

Hi

Thanks for this. I did try... however I still get errors. I'm not sure if it's because I'm using a one page check out modification or not. Just stumped!

New member

Posts

Joined
Fri Nov 11, 2016 7:33 am

Post by chrisgwynne » Thu Oct 19, 2017 7:28 pm

2017-10-19 10:23:19 - PHP Notice: Undefined index: code in /home/xxx/public_html/catalog/controller/extension/payment/pp_payflow_iframe.php on line 37
2017-10-19 10:23:19 - PHP Notice: Undefined index: code in /home/xxx/public_html/catalog/controller/extension/payment/pp_payflow_iframe.php on line 46

New member

Posts

Joined
Fri Nov 11, 2016 7:33 am

Post by ocdev » Thu Oct 19, 2017 8:34 pm

Turning off that one page checkout module would be a good test - I have used those in the past and I find the stock checkout module works pretty good.... It seems every time I add a new extensions, troubleshooting conflicts is becoming a nightmare.

New member

Posts

Joined
Wed Sep 11, 2013 3:53 am
Location - Texas

Post by ocdev » Thu Oct 19, 2017 8:39 pm

is this one of the offending lines of code:
'BILLTOSTATE' => $payment_zone['code'],

if so, then your cart module may not be setting the payment zone.
why don't you post both lines of code that are showing in your error
Steve

New member

Posts

Joined
Wed Sep 11, 2013 3:53 am
Location - Texas

Post by chrisgwynne » Tue Nov 07, 2017 6:20 pm

Notice: Undefined index: code in /home/melodyjane/public_html/catalog/controller/extension/payment/pp_payflow_iframe.php on line 37
Notice: Undefined index: code in /home/melodyjane/public_html/catalog/controller/extension/payment/pp_payflow_iframe.php on line 46

37 - 'BILLTOSTATE' => $payment_zone['code'],
46 - $url_params['SHIPTOSTATE'] = $shipping_zone['code'];


Using one page checkout and Opencart 2.3.0.2

New member

Posts

Joined
Fri Nov 11, 2016 7:33 am
Who is online

Users browsing this forum: No registered users and 3 guests