Facing small problem @ checkout

When i go to cart & then when i click checkout & then in checkout confirm page, i m getting an error like this -- >
Duplicate entry '47' for key 1


I have attached a file.. please look into it ASAP.
Thank You

to help troubleshoot, edit the confirm page


look for all instances of the following code (make sure to use a case sensitive search):

$WA_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());

and change it to:

$WA_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error()."<br />".$WA_Sql);

then look for all instances of (also case sensitive):

$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error());

and change it to:

$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error()."<br />".$WA_sql);

this will add the sql command being executed after the error, post back the results of testing the checkout again.

I changed.. still facing same error.

May be i didnt change the code at proper lines... please tell me which line which it.. Because there are two of them.

you will need to change all instances of the code i posted.

there should be 2 instances of each, all 4 instances need to be edited.

Yes still after that i m facing problem..

ok, well I did not say that changing the code would fix the problem, i said that changing the code would output the SQL that is causing the error to the screen. I asked you to post that SQL back, with this information I can then try to determine the cause of the problem and give you advice on how to fix it.

I made changes i m getting this error-->

Duplicate entry '47' for key 1
insert into orders (OrderUserID,OrderAmount,OrderShipName,OrderShipAddress,OrderShipAddress2,OrderCity,OrderState,OrderZip,OrderCountry,OrderPhone,OrderFax,OrderShipping,OrderTax,OrderEmail,OrderDate) values (1,0.00,'Kumel mohamed','#73, Second Floor, Fathima Manzil,','10th main, B.T.M Layout 1st stage,','Bangalore','','560029','IN','07259104089','',0,0,'mohammed.kumel@gmail.com','2012-02-11 07:11:26')

PLEASE HEP ME ON THIS!! ASAP..

I m not able to understand

i made all the changes..

Now i m getting error like this-->

Query was empty


@noGatewayconfirm.php page..

i have attached the files please look into them

please help me

the code changes to the confirm page are not quite correct;


line 249:

$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error()."<br />".$WA_sql);

should be:

$WA_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error()."<br />".$WA_Sql);

line 259:

$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error()."<br />".$WA_sql);

should be:

$WA_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error()."<br />".$WA_Sql);

line 301:

$WA_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error()."<br />".$WA_Sql);

should be:

$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error()."<br />".$WA_sql);

line 311:

$WA_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error()."<br />".$WA_Sql);

should be:

$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error()."<br />".$WA_sql);