Moving ProductCart

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

   Hello,
I am working on moveing are store to a new web host and sql host.
I have transfered over all the files and the sql database, the store front shows up as normal, I can log into the control panel as normal.
But so far two problems.
1: I tried to log into a customer account on the storefront and get
"An error has occurred 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 because you will need it to obtain more information about this error or to report the problem to our technical support team."
Would this have to do with the fact that I have not transfered the domain (dns) over to the new host yet?

2: I am checking all bases to make sure the move goes as planned, I attempted an update with the product import wizard, I used the same file I used to update my store with the old host, the new host sees the file, sees the map range, starts to update, takes awhile like normal, but at the end it says the import file is improperly formated, yet, it does look like it updated the products.

Only issue's that pop to mind is the old SQL server is version 2000, the new sql server is 2005, my migration of the sql database was used with "Microsoft SQL Server Management Studio"

Thanks

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
bsnyder Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 18-November-2008 Status: Offline Points: 0	Post Options Post Reply Quote bsnyder Report Post Thanks(0) Quote Reply Topic: Moving ProductCart Posted: 12-February-2009 at 12:45pm
	Hello, I am working on moveing are store to a new web host and sql host. I have transfered over all the files and the sql database, the store front shows up as normal, I can log into the control panel as normal. But so far two problems. 1: I tried to log into a customer account on the storefront and get "An error has occurred 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 because you will need it to obtain more information about this error or to report the problem to our technical support team." Would this have to do with the fact that I have not transfered the domain (dns) over to the new host yet? 2: I am checking all bases to make sure the move goes as planned, I attempted an update with the product import wizard, I used the same file I used to update my store with the old host, the new host sees the file, sees the map range, starts to update, takes awhile like normal, but at the end it says the import file is improperly formated, yet, it does look like it updated the products. Only issue's that pop to mind is the old SQL server is version 2000, the new sql server is 2005, my migration of the sql database was used with "Microsoft SQL Server Management Studio" Thanks

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: 12-February-2009 at 12:53pm
	On #1, your cplogs folder very likely does not have the correct permission. Comment out the line at the top of /includes/opendb.asp so that the actual error appears if setting the correct permissions does not resolve the issue.

bsnyder Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 18-November-2008 Status: Offline Points: 0	Post Options Post Reply Quote bsnyder Report Post Thanks(0) Quote Reply Posted: 12-February-2009 at 1:03pm
	cplogs looks to have read/write/delete as it should. what lind in opendb.asp do you refer to, to comment out?

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: 12-February-2009 at 1:12pm
	Sorry, fingers wer outpacing my thoughts. Look for the first instance of "on error next". Change that to 'on error next

bsnyder Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 18-November-2008 Status: Offline Points: 0	Post Options Post Reply Quote bsnyder Report Post Thanks(0) Quote Reply Posted: 12-February-2009 at 1:17pm
	Ok, thats what i tought, doing that gives an HTTP 500 Internal Server Error after attempting to log in on the store front. So I tried it on some of the other lines that had "On Error Resume Next" No 500 error but same result as before.

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: 12-February-2009 at 2:26pm
	Check your browser setting. Tools / Internet options / Advanced. Look for "show friendly HTTP error messagess". Uncheck that if it is checked. Let us know if that reveals a different error message.

bsnyder Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 18-November-2008 Status: Offline Points: 0	Post Options Post Reply Quote bsnyder Report Post Thanks(0) Quote Reply Posted: 12-February-2009 at 2:54pm
	Here is what I got Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'idDbSession', table 'tekdragon.dbo.pcCustomerSessions'; column does not allow nulls. INSERT fails. /productcart/pc/DBsv.asp, line 61 So that tells me there is an issue with the migration of SQL, will try another method of migrating the SQL database.

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: 12-February-2009 at 3:17pm
	The old host should pull a backup of the db, unless you were able to do so via the hosting account control panel, and the new host should restore it directly via SQL Studio.

bsnyder Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 18-November-2008 Status: Offline Points: 0	Post Options Post Reply Quote bsnyder Report Post Thanks(0) Quote Reply Posted: 12-February-2009 at 3:21pm
	yeah, that was the method I was going to try, just seems the backup/restore it puts directly onto the sql server, new host won't let me copy the backup file into thier backup directory, so guess I have to call them.