Guest Posted May 26, 2004 Share Posted May 26, 2004 1062 - Duplicate entry '0' for key 1 insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values ('12', 'adrian padilla', '', '16 e alex bell rd', '', 'centerville', '45459', 'Ohio', 'United States', '937-439-6324', '[email protected]', '2', 'adrian padilla', '', '16 e alex bell rd', '', 'centerville', '45459', 'Ohio', 'United States', '2', 'adrian padilla', '', '16 e alex bell rd', '', 'centerville', '45459', 'Ohio', 'United States', '2', 'Check/Money Order', '', '', '', '', now(), '1', 'USD', '1.00000000') [TEP STOP] that is the error that i get when my customers get when they try to confirm a order, please please help methis is a live store Link to comment Share on other sites More sharing options...
Guest Posted May 26, 2004 Share Posted May 26, 2004 something may have happened to the table, orders you should look at that, see the properties of orders id Link to comment Share on other sites More sharing options...
♥yesudo Posted May 26, 2004 Share Posted May 26, 2004 is it a specific payment gateway ? are you using a random number contrib ? Your online success is Paramount. Link to comment Share on other sites More sharing options...
volumax Posted May 26, 2004 Share Posted May 26, 2004 HI Adrian, I think Yesudo is on the right track, I had this error when integrating the HSBC payment module and Random order ID contrib. What was happening was the same order ID was atempted to be written twice to the orders table and it din't like it at all. Thats where I'd start looking. Andy Literally, Laterally Thinking! If you cannot get through it, go round it. Link to comment Share on other sites More sharing options...
Guest Posted May 26, 2004 Share Posted May 26, 2004 ok i have a couple of mods done to this store randon order # and ip address on order and that is all i am looking at my table for "order id" what would i be looking for? thank you for your help i thank people who know for helping people who dont........umm well like me Link to comment Share on other sites More sharing options...
bluepony Posted May 26, 2004 Share Posted May 26, 2004 The Random Order Number contribution shows it was just updated yesterday (5/25/04). The note says: "This version deals with the problem of generating duplicate order numbers, which (as far as I know) all the previous versions suffer from." http://www.oscommerce.com/community/contributions,1172 I'd rather be flying! Link to comment Share on other sites More sharing options...
Guest Posted May 26, 2004 Share Posted May 26, 2004 th you thank you Link to comment Share on other sites More sharing options...
Guest Posted May 26, 2004 Share Posted May 26, 2004 Thank you very much for your help. I am able to take order now again and would like to extend my sincerest gratitude t you for helping me Link to comment Share on other sites More sharing options...
♥yesudo Posted May 26, 2004 Share Posted May 26, 2004 "This version deals with the problem of generating duplicate order numbers, which (as far as I know) all the previous versions suffer from." I would like to know how that premise is reached. Your online success is Paramount. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.