CTE_Shopping Posted November 19, 2006 Posted November 19, 2006 :x I am just sick about this! Everthing was going so well and then... I made this really dumb mistake. I was working with phpMyAdmin 2.7.0-pl2 to try and create a csv file download and accidently deleted a file that was critical to my store. It appears to be an category indexing file located in the languages directory, but since I am still relatively new at this, I don't want to compound the error. I will take any and all suggestions! I get the following error when I try to access my store. ( 1146 - Table 'cteshopp_p_os1.products_description' doesn't exist select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name [TEP STOP] Sharron Mirikitani ([email protected]) Collectible Treasures Emporium There are many failures on the road to success. We stumble over pebbles, not mountains. Never give up!
CTE_Shopping Posted November 19, 2006 Author Posted November 19, 2006 It looks like there is no one out there who wants to tackle this problem and give me any advice. I see no good resolution to deleting a database file unless you have a backup and, alas, I didn't. THE BAD NEW is.... that I have taken my store offline and am creating a brand new data base. THE GOOD NEW IS.... what took me weeks to set up has been done in a few hours. When I set out on this task in October I didn't know that osCommerce, PHP, vDeck, etc. even existed. I learned a lot through trial and error and searching this forum for answers. I have also received some great support here. Now I face the daunting task of re-entering the 800+ products that I had online. #1 rule BACKUP THE DATABASE! There are many failures on the road to success. We stumble over pebbles, not mountains. Never give up!
ComicWisdom Posted November 19, 2006 Posted November 19, 2006 It looks like there is no one out there who wants to tackle this problem and give me any advice. I see no good resolution to deleting a database file unless you have a backup and, alas, I didn't. THE BAD NEW is.... that I have taken my store offline and am creating a brand new data base. THE GOOD NEW IS.... what took me weeks to set up has been done in a few hours. When I set out on this task in October I didn't know that osCommerce, PHP, vDeck, etc. even existed. I learned a lot through trial and error and searching this forum for answers. I have also received some great support here. Now I face the daunting task of re-entering the 800+ products that I had online. #1 rule BACKUP THE DATABASE! Backup/download the database "tables" you have individually. Create a new database by reinstalling oscommerce on your server. Then delete all the tables in the database except the one you deleted before. Upload each table into the new database. You will have to replace only the information in product description that you deleted. I'm not 100% sure that will work, but if you have 800 items to redo, it's worth a try on a few to see if they'll link correctly. Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!! Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience. The quickest way to learn is to forget to BACKUP!
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.