ProductCart Shopping Cart Software Forums : Moving ProductCart https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 10:04:24 +0000 Thu, 12 Feb 2009 15:21:10 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=2479 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Moving ProductCart : yeah, that was the method I was...]]> https://forum.productcart.com/moving-productcart_topic2479_post8916.html#8916 Author: bsnyder
Subject: 2479
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.]]> Thu, 12 Feb 2009 15:21:10 +0000 https://forum.productcart.com/moving-productcart_topic2479_post8916.html#8916 <![CDATA[Moving ProductCart : The old host should pull a backup...]]> https://forum.productcart.com/moving-productcart_topic2479_post8915.html#8915 Author: Greg Dinger
Subject: 2479
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.]]> Thu, 12 Feb 2009 15:17:28 +0000 https://forum.productcart.com/moving-productcart_topic2479_post8915.html#8915 <![CDATA[Moving ProductCart : Here is what I got Microsoft...]]> https://forum.productcart.com/moving-productcart_topic2479_post8912.html#8912 Author: bsnyder
Subject: 2479
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.
]]> Thu, 12 Feb 2009 14:54:09 +0000 https://forum.productcart.com/moving-productcart_topic2479_post8912.html#8912 <![CDATA[Moving ProductCart : Check your browser setting. Tools...]]> https://forum.productcart.com/moving-productcart_topic2479_post8910.html#8910 Author: Greg Dinger
Subject: 2479
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.
]]> Thu, 12 Feb 2009 14:26:51 +0000 https://forum.productcart.com/moving-productcart_topic2479_post8910.html#8910 <![CDATA[Moving ProductCart : Ok, thats what i tought, doing...]]> https://forum.productcart.com/moving-productcart_topic2479_post8908.html#8908 Author: bsnyder
Subject: 2479
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.
]]> Thu, 12 Feb 2009 13:17:58 +0000 https://forum.productcart.com/moving-productcart_topic2479_post8908.html#8908 <![CDATA[Moving ProductCart : Sorry, fingers wer outpacing my...]]> https://forum.productcart.com/moving-productcart_topic2479_post8906.html#8906 Author: Greg Dinger
Subject: 2479
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
]]> Thu, 12 Feb 2009 13:12:03 +0000 https://forum.productcart.com/moving-productcart_topic2479_post8906.html#8906 <![CDATA[Moving ProductCart : cplogs looks to have read/write/delete...]]> https://forum.productcart.com/moving-productcart_topic2479_post8904.html#8904 Author: bsnyder
Subject: 2479
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?
]]> Thu, 12 Feb 2009 13:03:33 +0000 https://forum.productcart.com/moving-productcart_topic2479_post8904.html#8904 <![CDATA[Moving ProductCart : On #1, your cplogs folder very...]]> https://forum.productcart.com/moving-productcart_topic2479_post8902.html#8902 Author: Greg Dinger
Subject: 2479
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.
 
 
]]> Thu, 12 Feb 2009 12:53:02 +0000 https://forum.productcart.com/moving-productcart_topic2479_post8902.html#8902 <![CDATA[Moving ProductCart : Hello, I am working on moveing...]]> https://forum.productcart.com/moving-productcart_topic2479_post8901.html#8901 Author: bsnyder
Subject: 2479
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
]]> Thu, 12 Feb 2009 12:45:00 +0000 https://forum.productcart.com/moving-productcart_topic2479_post8901.html#8901