All My Categories & Products Have Been Deleted... HELP!

[DPM]

I was adding new products to the back end and the computer crashed and when i reloaded all my categories and products have been deleted. What can i do?

www.dpmautostyling.co.uk

[fairestcape]

When you say "back end", what do you mean? Were you performing a SQL command to upload data?

[DPM]

I was in the admin backend adding new products.

[Ajeh]

If you look at your database tables for
products
products_description
categories
categories_description
products_to_categories

do you see your data in them?

[DPM]

Where are the data base tables?

When in the admin/backend if you look in the Catalog - Categories/Products section there's nothing there.

[bigbadboy]

Of course, you can always reinstall the database from your last back-up.
You did back-up, right?

[fairestcape]

The database is SEPARATE from the core files.

You will need to login to your host admin account on your server, then use the MySQL function there to access your database.

On a server with C-Panel, this is usually via a program called phpMyAdmin.

[DPM]

Getting this message when trying to fix it...

SQL query:
INSERT INTO `zen_product_types`
VALUES ( 1, 'Product - General', 'product', 1, 'Y', '', '2005-06-14 22:59:11', '2005-06-14 22:59:11' ) , ( 2, 'Product - Music', 'product_music', 1, 'Y', '', '2005-06-14 22:59:11', '2005-06-14 22:59:11' ) , ( 3, 'Document - General', 'document_general', 3, 'N', '', '2005-06-14 22:59:11', '2005-06-14 22:59:11' ) , ( 4, 'Document - Product', 'document_product', 3, 'Y', '', '2005-06-14 22:59:11', '2005-06-14 22:59:11' ) , ( 5, 'Product - Free Shipping', 'product_free_shipping', 1, 'Y', '', '2005-06-14 22:59:11', '2005-06-14 22:59:11' ) ;

MySQL said:
#1062 - Duplicate entry '1' for key 1

Anyone know what it means?

[Steven300]

It means you're trying to insert data which already exists. What are you attempting to do, an entire import? You haven't answered Ajeh's question.

[DJBobble]

Hi! I help out with DPM's site and am trying to sort the problem for...

If you check www.dpmautostyling.co.uk you can the problem - the categories are missing. Apparently DPM was in the middle of updating some stuff in the admin and suffered a crash and that is the result. I thought a simple dbase restore would cure the problem but when trying to restore that sql message is encountered. Drop tables and create table are both present in the sql backup.

@ ajeh - yes those tables are all present and contain data
@ bigbadboy - yes daily updates are in place. The sql used was from the last available backup.


In addition when I checked the dbase several tables were in need of repair. These now all report as being OK.

Hope the extra info helps...