Issues after restoring MS-SQL Database

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

We are building a new ProductCart BTO store on a new server to replace an older productcart store.
We have exported the SQL DB from the old store, and I imported it into the new store, but
I'm having a few issues.  
For example, whenever I click on any of the category links on the storefront after the restore, I now get errors such as:

“Description: Invalid object name 'pcCatPromotions'.

query=SELECT POrder FROM categories_products WHERE
idCategory=XX;”

 and

“Description: Item cannot be found in the collection corresponding to the requested name or ordinal.
query=SELECT POrder FROM categories_products WHERE idCategory=1;”

I also am now getting a "Page Not Found" when clicking on certain links in the store, which just started happening after the DB restore.
In the PC Control Panel, all the old orders, etc now show up just fine, and the merchant account info transferred over, etc. - but if I click on certain links, such as "Manage Content Pages" (for example), I will get a "Error Loading Content Pages", and if I click on a product to edit in the CP, I get a "Error on modifyProduct in main SQL query"
Any help would be greatly appreciated on this, thank you
-J

Edited by BlackReefDesigns - 06-October-2011 at 4:37am

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
BlackReefDesigns Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 28-May-2008 Location: San Diego, CA Status: Offline Points: 8	Post Options Post Reply Quote BlackReefDesigns Report Post Thanks(0) Quote Reply Topic: Issues after restoring MS-SQL Database Posted: 06-October-2011 at 4:35am
	We are building a new ProductCart BTO store on a new server to replace an older productcart store. We have exported the SQL DB from the old store, and I imported it into the new store, but I'm having a few issues. For example, whenever I click on any of the category links on the storefront after the restore, I now get errors such as: “Description: Invalid object name 'pcCatPromotions'. query=SELECT POrder FROM categories_products WHERE idCategory=XX;” and “Description: Item cannot be found in the collection corresponding to the requested name or ordinal. query=SELECT POrder FROM categories_products WHERE idCategory=1;” I also am now getting a "Page Not Found" when clicking on certain links in the store, which just started happening after the DB restore. In the PC Control Panel, all the old orders, etc now show up just fine, and the merchant account info transferred over, etc. - but if I click on certain links, such as "Manage Content Pages" (for example), I will get a "Error Loading Content Pages", and if I click on a product to edit in the CP, I get a "Error on modifyProduct in main SQL query" Any help would be greatly appreciated on this, thank you -J Edited by BlackReefDesigns - 06-October-2011 at 4:37am
	Joe S. BlackReef.net