Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

pls help 1062 - Duplicate entry '8' for key 'PRIMARY'


modeoscommerce

Recommended Posts

Posted

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]

Posted

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 ...

Posted

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 ...

Posted

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 ...

Posted

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.

Posted

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 ...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...