Magento SQL Error when processing a payment

Must be an Expert in MySQL as well as Magento and the ability to do a Paypal transaction through the site to test.

When I go through the entire process to complete a transaction (All methods, credit card, paypal express etc, on the last screen after coming back from paypal to review order, once you click place order it says:

“Unable to Place order” or “There was an error processing your order. Please try again later”

[url removed, login to view]

Then Magento sends an email to the administrator that says:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘14-14’ for key 2

Unable to accept any payments on the site via Paypal. I have attached screen shots:

I am using Joomla / Magento linked with Magebridge. I have tested on both environments and all methods and all result in an error.

Magento 1.7

PHP 5.2.4

I have Flushed Magento Cache automatically / disable all cache types

and flushed cache manually from FTP var/cache and var/session deleting entries in those folders. I also tried deleting all entries in the database phpmyadmin log entries (i.e. log_* excluding the log_summary one)

I have contacted Paypal and they suggested clearing cache (already done as far as I know and if there is something else I should clear please let me know)

I have cleared the browser cache and tried making a transaction on various computers / browsers.

I also ran the Magento Database Repair tool.

Tried another Paypal API

I hired a guy from India to help but could not figure it out. He installed an express Paypal button somewhere on the store and managed to complete one transaction, however using the existing buttons in the store result in a duplicate order that results in unable to complete the order.

This is the final step when coming back from Paypal and reviewing your order. Then you must click “place order” anf that is when it will result in an error

Still not working. Everything I have triied is posted here:

[url removed, login to view]

Here is what I know the solution will involve.

You will have to see what the detailed logged error is in system logs and pin point what table in the SQL database is causing the duplicate error. Then recreate that table or alter the code in Magento to stop creating a duplicate key.

Will only pay if this problem gets fixed. i.e. The buttons on the site are used to make the transaction.

Some helpful tips on the issue:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

Taidot: Magento, MySQL

Näytä lisää: paypal transaction pending, paypal pending review, paypal pending credit card payment, paypal payment says pending, paypal credit card payment pending, order express, linked in log in, joomla expert help from india, joomla back button, issue payment, code review tool, click a test, what is a pending transaction, what is a paypal email, paypal payment methods, paypal make a payment, magento inc, india inc, Sql code, Sql 2012, repair guy, processing, paypal api issue, order processing, mysql to sql

Tietoa työnantajasta:
( 5 arvostelua ) Calgary, Canada

Projektin tunnus: #1688895

Myönnetty käyttäjälle:


Hello, We are ready to start working on the project. Please check your inbox for more details, thanks!

$200 CAD 3 päivässä
(146 Arvostelua)

5 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


We have all the required designer and developer you are looking for and can allocate dedicated resources for your project. You will be very happy and satisfied of our services.

$250 CAD 7 päivässä
(66 arvostelua)

Hello, please check my private message. THank you

$1000 CAD 4 päivässä
(20 arvostelua)

Hello, I have read your project requirement carefully and would like to give our services. I have 4 years of Magento experience and i can do any kind of Magento task. I can start project right now. Please s Lisää

$200 CAD 5 päivässä
(9 arvostelua)

Custom Software Development - <b><i>Removed by Admin</i></b>

$250 CAD 1 päivässä
(0 arvostelua)

i have understand your problems in payment [login to view URL] i have solved your issue.

$250 CAD 5 päivässä
(0 arvostelua)