modeoscommerce Posted December 16, 2011 Posted December 16, 2011 can someone pls help i was trying to copy the databse sql file so first i needed to clear the customers and orders so i can export it. after accidentally doing that to a functional site, when i try to create an account, and click continue i get this error: 1062 - Duplicate entry '8' for key 'PRIMARY' insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('8', '0', now()) [TEP STOP]
♥Monika in Germany Posted December 16, 2011 Posted December 16, 2011 you most probably emptied tables in your phpmyadmin? your customer data is held in more than the customers table ... and you most probably only emptied customers and orders. there are many more: customers_info address_book orders_status_history orders_products orders_products_attributes customers_basket customers_basket_attributes ... :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...
modeoscommerce Posted December 16, 2011 Author Posted December 16, 2011 oops..so..what do i do now? customers cant even create an account
♥Monika in Germany Posted December 16, 2011 Posted December 16, 2011 you need to go back into your database and finish up your cleaning job from before ... :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...
♥Monika in Germany Posted December 16, 2011 Posted December 16, 2011 will you promise me to get a book on mysql? :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...
modeoscommerce Posted December 16, 2011 Author Posted December 16, 2011 hehe. thats long overdue.. ill do that !
modeoscommerce Posted December 17, 2011 Author Posted December 17, 2011 one more issue with this... now when customers checkout and complete payment, the order is coming in the order section in doubles... did i leave something out? any help will be appreciated. thanks.
♥Monika in Germany Posted December 17, 2011 Posted December 17, 2011 you mean in your admin you see 2 rows of orders? identical? in that case, you may have messed up something in the php code of your site. hard to pinpoint from here. :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.