Guest Posted July 10, 2004 Share Posted July 10, 2004 1062-Duplicate entry '0' for key 1Please call so we can complete this order What is causing this error? I hope that it's nothing serious. He was trying to check out with the Paypal IPN that I installed. Please let me know! Thanks!!!!! Quote Link to comment Share on other sites More sharing options...
The_ancient Posted July 10, 2004 Share Posted July 10, 2004 which table did it say try and complete a test order on your own store Quote Link to comment Share on other sites More sharing options...
Guest Posted July 11, 2004 Share Posted July 11, 2004 which table did it say try and complete a test order on your own store How ingenious of you! Here is the whole error - 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, orders_status, date_purchased, last_modified, currency, currency_value) values ('4', 'Joel Test Gallant', '', '24 Lydia St', '', 'Dieppe', 'E1A4Z5', 'New Brunswick', 'Canada', '506-870-0054', '[email protected]', '1', 'Joel Test Gallant', '', '24 Lydia St', '', 'Dieppe', 'E1A4Z5', 'New Brunswick', 'Canada', '1', 'Joel Test Gallant', '', '24 Lydia St', '', 'Dieppe', 'E1A4Z5', 'New Brunswick', 'Canada', '1', 'PayPal', '', '', '', '', '4', now(), now(), 'CAD', '1.00000000') [TEP STOP] Where did I go wrong? Quote Link to comment Share on other sites More sharing options...
Guest Posted July 11, 2004 Share Posted July 11, 2004 Was order_process.php modified in any way? Can you post it? Quote Link to comment Share on other sites More sharing options...
The_ancient Posted July 11, 2004 Share Posted July 11, 2004 Do you have access to phpmyadmin? if so look at your ID Feild of the Orders Table (should be the Top one) and mack sure "auto_increment" is turned on.... what is happening is order number "0" is tring to be logged but mysql shows there is already and order with that id.. there probally is not since it is "0" but.. and returns the error because the feild is set to not duplicate normally the orders go 1,2,3,4,5,6 etc which mysql automatically generates based on the auto_increment command Quote Link to comment Share on other sites More sharing options...
The_ancient Posted July 11, 2004 Share Posted July 11, 2004 Was order_process.php modified in any way? Can you post it? based on the query posted there is no order id being passed to the mysql server, therefore the error is occuring internally Quote Link to comment Share on other sites More sharing options...
Guest Posted July 11, 2004 Share Posted July 11, 2004 crap... that's it! The order ID # is 0... But I dont' get it. I had another customer purchase something and the order id was # 9. How does that make any sense? I also installed the random order number. Anyone have a suggestion to fix it? Quote Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2004 Share Posted July 13, 2004 Ok, so I installed Random order number & I wasn't supposed to turn on the auto_increment back on, so how am I supposed to fix this error? Quote Link to comment Share on other sites More sharing options...
The_ancient Posted July 14, 2004 Share Posted July 14, 2004 Ok, so I installed Random order number & I wasn't supposed to turn on the auto_increment back on, so how am I supposed to fix this error? not to sould like an ass, but did you install it write? adding the new "order_id" feild to the Intsert query? Quote Link to comment Share on other sites More sharing options...
Guest Posted July 14, 2004 Share Posted July 14, 2004 not sounding like an ass at all... I probably didn't install it properly.... i had no real idea how to create those databases.... So, what do you need from me to help figure this out.... Quote Link to comment Share on other sites More sharing options...
Guest Posted July 14, 2004 Share Posted July 14, 2004 you are better off to uninstall the random order # generator as it is more a pain in the neck than it is worth it. if you have a product customers want and you are a trusty vendor, they dont care what your order numbering system is like. they dont even see the order number until after the order is placed anyway, so what is the use? personally, i uninstall that contribution on any of my customers, else they are on their own. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 14, 2004 Share Posted July 14, 2004 Removed & solved! Thank you so much John! Greatly appreciated! Quote Link to comment Share on other sites More sharing options...
The_ancient Posted July 14, 2004 Share Posted July 14, 2004 you are better off to uninstall the random order # generator as it is more a pain in the neck than it is worth it. if you have a product customers want and you are a trusty vendor, they dont care what your order numbering system is like. they dont even see the order number until after the order is placed anyway, so what is the use?personally, i uninstall that contribution on any of my customers, else they are on their own. yes and no I dont like how the Random Generator work in the Contribution but I also dont like how the Defualt scheme is I will probally come up with my own at some point down the road Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.