Problem moving database to a new server |
Post Reply |
Author | |
redbeetstudio
Newbie Joined: 06-August-2008 Status: Offline Points: 0 |
Post Options
Thanks(0)
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
|
|
redbeetstudio
Newbie Joined: 06-August-2008 Status: Offline Points: 0 |
Post Options
Thanks(0)
|
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
|
|
Greg Dinger
Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238 |
Post Options
Thanks(0)
|
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.
|
|
redbeetstudio
Newbie Joined: 06-August-2008 Status: Offline Points: 0 |
Post Options
Thanks(0)
|
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
|
|
Greg Dinger
Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238 |
Post Options
Thanks(0)
|
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.
|
|
redbeetstudio
Newbie Joined: 06-August-2008 Status: Offline Points: 0 |
Post Options
Thanks(0)
|
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
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |