makotoshoto Posted April 18, 2008 Share Posted April 18, 2008 So I was deleting an empty old folder in the catalog as I have done before and *bam* the entire catalog (300+ products, and reviews) are completely gone. Anyone have any obvious solutions that I have overlooked? I'd rather not sit here all weekend inserting all the products one-by-one again (plus, this is a rather busy storefront, and the company owner may not be too thrilled with losing a weekend of sales). Before anyone says "should have backed it up, n00b", I did. But restoring backed up files has not brought the catalog magically back. Everything but products and reviews are still there, and nothing of this sort has occured to me before, despite my knack for "oh, crap" moments. Thanks in advance for any help and/or consolation. Link to comment Share on other sites More sharing options...
Jan Zonjee Posted April 18, 2008 Share Posted April 18, 2008 So I was deleting an empty old folder in the catalog as I have done before and *bam* the entire catalog (300+ products, and reviews) are completely gone. Anyone have any obvious solutions that I have overlooked? This is a rather nasty bug that has been in osC for a long time apparently. I think it is gone in RC2a but I haven't tried it myself. Having a backup of the database would be your only resource for products and reviews. The hosting provider doesn't make one once in a while? Link to comment Share on other sites More sharing options...
MJP Posted April 18, 2008 Share Posted April 18, 2008 This is a rather nasty bug that has been in osC for a long time apparently. I think it is gone in RC2a but I haven't tried it myself. Having a backup of the database would be your only resource for products and reviews. The hosting provider doesn't make one once in a while? a bug? what would the name of this "empty" folder be so I can watch for it. Link to comment Share on other sites More sharing options...
makotoshoto Posted April 18, 2008 Author Share Posted April 18, 2008 Having a backup of the database would be your only resource for products and reviews. The hosting provider doesn't make one once in a while? I restored the database backup from 2 weeks ago, and it didn't change a thing. in phpmyadmin, "products" is now empty. Link to comment Share on other sites More sharing options...
Jan Zonjee Posted April 18, 2008 Share Posted April 18, 2008 I restored the database backup from 2 weeks ago, and it didn't change a thing. in phpmyadmin, "products" is now empty. What can I say? I could think of three things: - the database did not have any products in it two weeks ago - the backup of two weeks ago does not contain the data for products - the restore of the backup didn't work well (interrupted perhaps?) A mysql backup is a basically a text file so you can find out a lot by opening it in a text editor. Link to comment Share on other sites More sharing options...
makotoshoto Posted April 18, 2008 Author Share Posted April 18, 2008 What can I say? I could think of three things: - the database did not have any products in it two weeks ago - the backup of two weeks ago does not contain the data for products - the restore of the backup didn't work well (interrupted perhaps?) A mysql backup is a basically a text file so you can find out a lot by opening it in a text editor. Thanks, Jan! The catalog has had many products in it for a couple years, and the backup file has all the info in it, but for some reason restoring it, no matter how many times I try, does not affect anything. Oh well, I fear overwriting the customer info/order history. I'll just use the info I have in the text file to re-insert everything. Thanks for your help! :) Link to comment Share on other sites More sharing options...
Jan Zonjee Posted April 19, 2008 Share Posted April 19, 2008 The catalog has had many products in it for a couple years, and the backup file has all the info in it, but for some reason restoring it, no matter how many times I try, does not affect anything. Oh well, I fear overwriting the customer info/order history. I'll just use the info I have in the text file to re-insert everything. Because it is just a text file, you could try to extract the portion for the table products, products_to_categories etc. one by one with a text editor (starts with drop table if ... then create table .... then (sometimes many times) insert into...) and save them to separate sql files. Link to comment Share on other sites More sharing options...
Guest Posted April 20, 2008 Share Posted April 20, 2008 Depending on how the backup was taken, it may not have the "drop table" in it. If I recall correctly, phpMyAdmin does not do this by default, though it provides this as a checkbox option. My suggestion: back up the following current tables, then drop them in phpMyAdmin, then restore JUST THOSE TABLES: - products - categories I don't recall if you need the following three or not, but if they're blank (or close to it) then you probably need to restore them: - products_to_categories - products_descriptions - categories_descriptions if you're using attributes, then you may also need to drop and restore (I dunno -- I have only run into this issue on stores that were not using attributes): - products_attributes - products_attributes_download - products_options - products_options_values - products_options_values_to_products_options -jared Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.