andrzejdlugosz Posted January 8, 2015 Share Posted January 8, 2015 When testing website using sanbox paypal account I am getting error: Fatal error: Uncaught Duplicate entry '4' for key 'PRIMARY'<br /><br /><pre> INSERT INTO `ps_paypal_order` (`id_order`, `id_transaction`, `id_invoice`, `currency`, `total_paid`, `shipping`, `capture`, `payment_date`, `payment_method`, `payment_status`) VALUES (4, '7LT72664C89710719', '', 'GBP', '1120', '120', '0', '2015-01-08T00:28:27Z', '1', 'Completed')</pre> thrown in /home/gbs2/public_html/prestashop/classes/db/Db.php on line 635 Can anyone help? Thank you Link to comment Share on other sites More sharing options...
andrzejdlugosz Posted January 8, 2015 Author Share Posted January 8, 2015 Truncate the table solved issue Link to comment Share on other sites More sharing options...
Christian Alias Posted June 13, 2016 Share Posted June 13, 2016 Truncate the table solved issue Do you mean to delete all the table or just the row with the error shown ? Link to comment Share on other sites More sharing options...
andrzejdlugosz Posted June 13, 2016 Author Share Posted June 13, 2016 As I was testing the payment I emptied the table. Link to comment Share on other sites More sharing options...
Christian Alias Posted June 13, 2016 Share Posted June 13, 2016 (edited) but didn't you break the other payment modules functionality by deleting that table ? Sorry I missunderstood, my problem is with ps_module_currency table thanks anyway Edited June 13, 2016 by Christian Alias (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now