Error 1062 "Duplicate Entry

[Guest]

Oops! What have I done? I thought I was deleting the categories, just as I had deleted the 'products' table by clicking "Empty" in PHPMyAdmin, but something tells me that the 'category' table is different form the 'products' table, in an important way. What do I do now? re-install everything?

 

Now when I try to use EP to upload my file, it says:

Error 1062 - Duplicate entry '1-1' for key 1 which takes me back to the SQL, but I don't know what I did when I "emptied the category table". Can someone please help me rebuild it? Maybe there is another way to fix this problem?

 

EP just got finished downloading splitting and uploading a file, but I made the mistake of wrong product_model, and went back to empty my databse tables... I still don't see what I could've done?

 

Thanks,

 

Morrie

[Guest]

Yep. You shouldn't have done that. If you're going to delete portions of the database with phpMyAdmin, you'd better know what you're doing.

 

The categories table is referenced by products_to_categories and categories_description. You're best off restoring from backup and doing it properly.

 

-jared