Print Page | Close Window

Problem moving database to a new server

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Getting Started
Forum Description: Installing, activating, and getting started with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=3410
Printed Date: 08-July-2024 at 1:52pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com


Topic: Problem moving database to a new server
Posted By: redbeetstudio
Subject: Problem moving database to a new server
Date 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



Replies:
Posted By: redbeetstudio
Date 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


Posted By: Greg Dinger
Date 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.


-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |


Posted By: redbeetstudio
Date 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


Posted By: Greg Dinger
Date 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.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |


Posted By: redbeetstudio
Date 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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.04 - http://www.webwizforums.com
Copyright ©2001-2021 Web Wiz Ltd. - https://www.webwiz.net