ProductCart Shopping Cart Software Forums : Errors logging in after migrating to new server... https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 04:50:00 +0000 Mon, 15 Feb 2010 17:19:10 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3434 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Errors logging in after migrating to new server... : I want to thank you,Greg and Sean,...]]> https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13010.html#13010 Author: SCM
Subject: 3434
Posted: 15-February-2010 at 5:19pm

I want to thank you, Greg and Sean, for your expert and timely replies to my problem. Waiting now on the host to deliver a correct/valid backup...
 
Most appreciated...
 
SCM
 
]]> Mon, 15 Feb 2010 17:19:10 +0000 https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13010.html#13010 <![CDATA[Errors logging in after migrating to new server... : Make sure the old host performs...]]> https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13007.html#13007 Author: Greg Dinger
Subject: 3434
Posted: 15-February-2010 at 2:53pm

Make sure the old  host performs a backup via SQL Studio and provides to you a .BAK file.]]> Mon, 15 Feb 2010 14:53:32 +0000 https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13007.html#13007 <![CDATA[Errors logging in after migrating to new server... : Sean... I think you&#039;re right...]]> https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13005.html#13005 Author: SCM
Subject: 3434
Posted: 15-February-2010 at 2:44pm

Sean... I think you're right - I think I'm missing some (all?) PKs.
 
Let me see if I can get a correct backup (... right now, I'm limited to access via SSMS 2005 (... as the previous developer has disappeared, and I don't have access to the backup directory on that server).
 
SCM
 
]]> Mon, 15 Feb 2010 14:44:56 +0000 https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13005.html#13005 <![CDATA[Errors logging in after migrating to new server... : SCM wrote: Commented out the...]]> https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13003.html#13003 Author: Guests
Subject: 3434
Posted: 15-February-2010 at 2:12pm

Originally posted by SCM SCM wrote:

Commented out the first “on error resume next” statement in: includes/opendb.asp
 
There were no “on error resume next” statements in:  pcadmin/adminv.asp 
 
Attempt to login to storefront produced this error (from error logs - storefront produced 500 internal server error):
 
/productcart/pc/login.asp lmode=2|50|80040e2f|Cannot_insert_the_value_NULL_into_column_'idDbSession'__table_'STORE.dbo.pcCustomerSessions';_column_does_not_allow_nulls._INSERT_fails. 80
 
 
Hi SCM, just had a closer look at your error here and there does seem to be something amis with your database transfer. The error here is essentially saying that the db can't create the primary key for the pcCustomerSessions table; however, that value should be auto incremented. Apparently that is the problem -- it's not incrementing, so it therefore has no value, but as the primary key it can't be NULL either.
 
What method did you use to migrate your database?
]]> Mon, 15 Feb 2010 14:12:19 +0000 https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13003.html#13003 <![CDATA[Errors logging in after migrating to new server... : Understood... Current (working):9.0.2050 New...]]> https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13002.html#13002 Author: SCM
Subject: 3434
Posted: 15-February-2010 at 2:11pm

Understood...
 
Current (working): 9.0.2050
New (problems): 9.00.1399.06
 
So, it looks like both are 2005, and the current (working) has SP1.
 
 
]]> Mon, 15 Feb 2010 14:11:12 +0000 https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13002.html#13002 <![CDATA[Errors logging in after migrating to new server... : BTW, by database I mean SQL 2000,...]]> https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13001.html#13001 Author: Greg Dinger
Subject: 3434
Posted: 15-February-2010 at 1:48pm

BTW, by database I mean SQL 2000, 2005 or 2008.]]> Mon, 15 Feb 2010 13:48:01 +0000 https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13001.html#13001 <![CDATA[Errors logging in after migrating to new server... : It sounds like there may be a...]]> https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13000.html#13000 Author: Greg Dinger
Subject: 3434
Posted: 15-February-2010 at 1:47pm

It sounds like there may be a difference in the database between old and new host. 
Before you take any further action could you please determine what database you had at the old host, and what you have now? 
 
Who is the new host?
]]> Mon, 15 Feb 2010 13:47:25 +0000 https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post13000.html#13000 <![CDATA[Errors logging in after migrating to new server... : Hi SCM, If I were in your spot,...]]> https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post12999.html#12999 Author: Guests
Subject: 3434
Posted: 15-February-2010 at 1:31pm

Hi SCM,
 
If I were in your spot, I would proceed with upgrading. That will very likely solve your login issue too.
 
Just a heads up, but if the store you are working on is way back to 3.0.3, then you will have a multi-step upgrade.
 
You should upgrade to at least 3.51 for security concerns alone. Whether you want to go all the way to v4 SP3 or wait until v4.1 is released, I'll leave for you to deliberate.
]]> Mon, 15 Feb 2010 13:31:45 +0000 https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post12999.html#12999 <![CDATA[Errors logging in after migrating to new server... : Commented out the first “on...]]> https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post12998.html#12998 Author: SCM
Subject: 3434
Posted: 15-February-2010 at 1:26pm

Commented out the first “on error resume next” statement in: includes/opendb.asp
 
There were no “on error resume next” statements in:  pcadmin/adminv.asp 
 
Attempt to login to storefront produced this error (from error logs - storefront produced 500 internal server error):
 
/productcart/pc/login.asp lmode=2|50|80040e2f|Cannot_insert_the_value_NULL_into_column_'idDbSession'__table_'STORE.dbo.pcCustomerSessions';_column_does_not_allow_nulls._INSERT_fails. 80
 
]]> Mon, 15 Feb 2010 13:26:33 +0000 https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post12998.html#12998 <![CDATA[Errors logging in after migrating to new server... : Thanks for the update... I will...]]> https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post12997.html#12997 Author: SCM
Subject: 3434
Posted: 15-February-2010 at 1:09pm

Thanks for the update... I will see if I can get more specific errors by making the changes you suggested, and per the wiki.
 
And Yikes indeed! I just took over this project 3 days ago, so I'm rapidly getting up to speed... so, an update is definately in order.
 
I will post the error(s) here as soon as I can reproduce them.
 
SCM
 
]]> Mon, 15 Feb 2010 13:09:11 +0000 https://forum.productcart.com/errors-logging-in-after-migrating-to-new-server_topic3434_post12997.html#12997