Errors logging in after migrating to 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=3434
Printed Date: 14-May-2024 at 7:07pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Errors logging in after migrating to new server...
Posted By: SCM
Subject: Errors logging in after migrating to new server...
Date Posted: 15-February-2010 at 10:42am
|
All seemd to go well after migrating to a new server - able to browse pages, categories, add productst to cart - EXCEPT for when trying to login:
On the main cart login <SERVER>productcart/pc/Checkout.asp?cmode=1
... after attempting to login, this message appears:
--------------------------------------------------------------------------------------------
An error has occured in this store. We apologize for the inconvenience.
--------------------------------------------------------------------------------------------
...and the query string show:
<SERVER>productcart/pc/techErr.asp?error=Error+in+DBsv+3%3A+
-AND-
On the Control Panel login <SERVER>productcart/admin/login_1.asp
...shows the ProductCart End User License Agreement with the checkbox and "Submit" button. Ticking checkbox and clicking the "Submit" returns to the same login page with end user agreement.
I believe I've followed all the 'moving to a new server' instructions from the wiki - i.e. Step 2 of the Product Activation Wizard show success with Enabled Parent Paths, Folder permissions and Database connection string, etc...
There is obviously some amiss however.
Using ProductCart v3.03
Any advice, suggestions greatly appreciated.
SCM
|
Replies:
Posted By: Greg Dinger
Date Posted: 15-February-2010 at 10:50am
Posted By: SCM
Date Posted: 15-February-2010 at 10:56am
| Yes, confimed - ProductCart v3.03 |
Posted By: Greg Dinger
Date Posted: 15-February-2010 at 11:03am
Posted By: SCM
Date Posted: 15-February-2010 at 11:43am
| I very much appreciate the assistance... however, I do not see any folder named "CPlogs" in my productcart directory. |
Posted By: Greg Dinger
Date Posted: 15-February-2010 at 11:48am
Posted By: SCM
Date Posted: 15-February-2010 at 12:03pm
|
Currently, I have a fully functioning PC cart on a server that will be disabled in the near future. Neither this functioning PC cart. or the new server PC cart (with the errors) contain the folder "CPlogs". Both folders are identical on each server mentioned above, and as follows: ProductCart\mgcsadmin\
images\
importlogs\
licenses\
newslists\
productWizard\
uploadresize\
Thanks again for the help...
SCM
|
Posted By: Guests
Date Posted: 15-February-2010 at 12:06pm
|
I have a similar issue on a 4.0 SP3 site after renaming the pcadmin folder. After renaming that folder I get the issue with the checkbox when attempting to get to the cp login. I get this on FireFox on two computers, on IE 6 on one, but not in IE 8 on the other. My client, however, doesn't have any issue at all here.
Just for good measure, I followed Greg's observation here and have comfirmed that the CPLogs folder has modify permissions.
|
Posted By: Greg Dinger
Date Posted: 15-February-2010 at 12:09pm
Posted By: Greg Dinger
Date Posted: 15-February-2010 at 12:26pm
Posted By: SCM
Date Posted: 15-February-2010 at 12:32pm
|
I very much appreciate your assistance with my problem, and will continue to experiment with the permissions. If I still cannot find success, I will contact Early Impact as suggested.
SCM
|
Posted By: SCM
Date 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
|
Posted By: SCM
Date 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
|
Posted By: Guests
Date 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.
|
Posted By: Greg Dinger
Date Posted: 15-February-2010 at 1:47pm
Posted By: Greg Dinger
Date Posted: 15-February-2010 at 1:48pm
Posted By: SCM
Date 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.
|
Posted By: Guests
Date Posted: 15-February-2010 at 2:12pm
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?
|
SCM wrote:Posted By: SCM
Date 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
|
Posted By: Greg Dinger
Date Posted: 15-February-2010 at 2:53pm
Posted By: SCM
Date 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
|