ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Getting Started
  New Posts New Posts RSS Feed - Database Trouble after moving ProductCart
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Database Trouble after moving ProductCart

 Post Reply Post Reply Page  12>
Author
Message
austcold View Drop Down
Groupie
Groupie


Joined: 29-May-2008
Location: Australia
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote austcold Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
austcold View Drop Down
Groupie
Groupie


Joined: 29-May-2008
Location: Australia
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote austcold Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238
Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
austcold View Drop Down
Groupie
Groupie


Joined: 29-May-2008
Location: Australia
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote austcold Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
Matt View Drop Down
Moderator Group
Moderator Group


Joined: 20-July-2006
Location: United States
Status: Offline
Points: 73
Post Options Post Options   Thanks (0) Thanks(0)   Quote Matt Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
austcold View Drop Down
Groupie
Groupie


Joined: 29-May-2008
Location: Australia
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote austcold Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
Matt View Drop Down
Moderator Group
Moderator Group


Joined: 20-July-2006
Location: United States
Status: Offline
Points: 73
Post Options Post Options   Thanks (0) Thanks(0)   Quote Matt Quote  Post ReplyReply Direct Link To This Post 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.  
Back to Top
austcold View Drop Down
Groupie
Groupie


Joined: 29-May-2008
Location: Australia
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote austcold Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
austcold View Drop Down
Groupie
Groupie


Joined: 29-May-2008
Location: Australia
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote austcold Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238
Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply Page  12>
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.064 seconds.