Database Trouble after moving ProductCart

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

   Hi,

I have moved my store to a VPS server, after migrating I get the following error.

"Source: Microsoft SQL Server Native Client 10.0
Description: Invalid object name 'pcCatPromotions'.
query=SELECT POrder FROM categories_products WHERE idCategory=5;"

The control panel is working fine. The domain DNS is updated to the new server and is effective.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply Topic: Database Trouble after moving ProductCart Posted: 27-April-2013 at 8:39am
	Hi, I have moved my store to a VPS server, after migrating I get the following error. "Source: Microsoft SQL Server Native Client 10.0 Description: Invalid object name 'pcCatPromotions'. query=SELECT POrder FROM categories_products WHERE idCategory=5;" The control panel is working fine. The domain DNS is updated to the new server and is effective.
	www.austcoldindustries.com.au

austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 9:12am
	Turns out there are some issues in the control panel, can view orders no problem, but cant access general setting page or edit product page. I created the database and restored it using a backup file from the old server database. It is connecting to the database and displaying orders etc.
	www.austcoldindustries.com.au

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 1:00pm
	it seems that you will need someone to go look at the site and the database. I can't think of how I, for example, might even begin to overcome this simply via the forum.

austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 6:15pm
	Hi Greg, Would you just require FTP access at this stage or access to the Plesk Parallels control panel as well? I would like you to attend to this for me. I am confused as why this issue persists as I followed instructions for moving product cart. You can email direct via grant@austcoldindustries.com.au
	www.austcoldindustries.com.au

Matt Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 20-July-2006 Location: United States Status: Offline Points: 73	Post Options Post Reply Quote Matt Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 6:35pm
	Invalid object name 'pcCatPromotions'. means that your connection string points to a database missing that entire table. Seems like the database you restored was an old database.

austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 6:40pm
	Hi Matt, No it is the correct database, I have backed up from old server , created new one in new server and restored it using the file twice. Same result. It is showing the correct orders to date in the control panel. Grant.
	www.austcoldindustries.com.au

Matt Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 20-July-2006 Location: United States Status: Offline Points: 73	Post Options Post Reply Quote Matt Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 6:46pm
	The error you are showing means it needs a table that is not in your database. If the database is the same, then you must be using newer files without running a database update. If you tell me the files are the same, then I would say that this error must have been there before you moved.

austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 6:54pm
	Should all be the same, I used FileZilla to FTP all files to my pc and then FTP them to the new server. Used the backup feature in the control panel to backup and download database. Then created new database with same name and restored using the backup. Grant
	www.austcoldindustries.com.au

austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 6:56pm
	However when it restored I got an error advising, "The database was restored successfully but some users require your attention."
	www.austcoldindustries.com.au

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 7:37pm
	Grant, I replied to you by e-mail. Perhaps Matt is going to be able to help. If not, get me the details I discussed in my e-mail.