toddhacker Posted January 27, 2009 Share Posted January 27, 2009 Hello, I am moving my store from one server to another and noticed that my products_notifications table was not installed on the new server during the move of the old database. When I try to export that table from the old server I am given an error that I cannot open the file. Now my store is throwing an error that the table doesn't exist when someone views a product. So my question are. 1. Is this something I can just reconstruct on the new server via an SQL command. 2. If I can, does anyone know the SQL instruction to rebuild that table. 3. Would that have contained any product info that I may have lost due to the bad file? I am running osCommerce 2.2-MS2 Any help would be appreciated. Thank you. Link to comment Share on other sites More sharing options...
♥kymation Posted January 27, 2009 Share Posted January 27, 2009 1. Yes. 2. Take the products_notifications table SQL from your latest good backup and use that to rebuild the table. Just search the file for products_notifications to find the right section. 3. Yes, it contains your customer notifications, so your customers will not get any update notices that they have subscribed to. I don't know how much this may effect your future business. Regards Jim See my profile for a list of my addons and ways to get support. 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.