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