ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Getting Started
  New Posts New Posts RSS Feed - Problem moving database to a new server
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Problem moving database to a new server

 Post Reply Post Reply
Author
Message
redbeetstudio View Drop Down
Newbie
Newbie


Joined: 06-August-2008
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote redbeetstudio Quote  Post ReplyReply Direct Link To This Post Topic: Problem moving database to a new server
    Posted: 05-February-2010 at 12:01pm
I have been having problems with my current MSSQL2005 server, so I've decided to move my PC database to a new server. The site files will not be moved, only the database.

I have had server technicians copy the database to the new server so that I can test everything before I make the switch. To test, I have edited the storeconstants.asp file to the reflect the new server connection. I can see that the store is in fact connecting to the new SQL server (I made a simple edit to a product and can see it reflected in the store). I can also navigate the store, add products to the cart, etc. without problems.

But when I try to log into an existing account, either to place an order or view account details, I receive the following error: "An error has occured in this store. We apologize for the inconvenience... The error has been logged in the store database. The reference ID for this error is: . Write it down..." As you can see there is no reference ID, so I cannot look into the specifics of the error.

Is there something else I need to do besides change the connection details in storeconstants.asp? I can see the account in both databases, so I assume that the database has been copied properly. The error also occurs if I try to setup a new account during checkout.
- peter
Back to Top
redbeetstudio View Drop Down
Newbie
Newbie


Joined: 06-August-2008
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote redbeetstudio Quote  Post ReplyReply Direct Link To This Post Posted: 08-February-2010 at 1:00pm
In storeconstants.asp, what is the following variable used for? And does it need to be changed if the dtabase is moved?

private const scCrypPass
- peter
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: 08-February-2010 at 1:23pm
That is your license key.  If changed, encrypted information in your store will become unreadable. 
 
If your database is moved, what you need to change is the db connection string that appears below that.
Back to Top
redbeetstudio View Drop Down
Newbie
Newbie


Joined: 06-August-2008
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote redbeetstudio Quote  Post ReplyReply Direct Link To This Post Posted: 08-February-2010 at 1:30pm
Thanks Greg. I've changed the db string (left scCrypPass alone), but I'm having database problems when attempting to login through front-end. Everything else is working fine. Any idea what might be causing the problem?
- peter
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: 08-February-2010 at 1:37pm
I suggest that you file support ticket with EI.  Something is causing dberror.asp to be displayed.  What that might be cannot be determined without FTP access and physically examining thing.
Back to Top
redbeetstudio View Drop Down
Newbie
Newbie


Joined: 06-August-2008
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote redbeetstudio Quote  Post ReplyReply Direct Link To This Post Posted: 08-February-2010 at 1:57pm
I appreciate the suggestion. Unfortunately, I do not have a support contract with Early Impact and I don't want to pay $200. thanks.

- peter
- peter
Back to Top
 Post Reply Post Reply
  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.078 seconds.