ProductCart Shopping Cart Software Forums : Admin Place Order Stopped Working

Admin Place Order Stopped Working : Update. Early Impact has resolved...

Tue, 06 Sep 2011 15:34:35 +0000

Author: odathp
Subject: 4715
Posted: 06-September-2011 at 3:34pm

Update. Early Impact has resolved this issue.

"...it turned out to bean issue related to the encryption/decryption of the customer password, Forsome reason, it didn't like something about the server or license key... so ourdeveloper edited the following files and it is now working:"

pcadmin/adminPlaceOrder.asp
pc/checkout.asp

Not sure if this is related. I did execute the Control Panel "Generate New Encryption Key" sometime before all this started. I don't want to try it again to see what happens for obvious reasons.

Oh, and I was also reminded to change the name of the pcadmin folder. lol.

Thank you Early Impact support!

Jack

Admin Place Order Stopped Working : Yes, 2-3 posts up I identified...

Tue, 06 Sep 2011 13:38:02 +0000

Author: odathp
Subject: 4715
Posted: 06-September-2011 at 1:38pm

Yes, 2-3 posts up I identified the hosting company. Gearhost. They are listed on the Early Impact website as a ProductCart-optimized ecommerce Web host. According to Early Impact, "..they host at least 10 or more ProductCart-powered stores, and are committed to providing an optimal hosting experience for ProductCart merchants".

After to speaking with them on the phone multiples times, I can confirm they are willing to do whatever necessary to resolve this issue.

I submitted a ticket to Early Impact. Everything (including Quickbooks Synchronizer) works on Gearhost with the exception of the Admin Place Order function.

Admin Place Order Stopped Working : I would encourage you to run PC...

Tue, 06 Sep 2011 13:22:38 +0000

Author: Greg Dinger
Subject: 4715
Posted: 06-September-2011 at 1:22pm

I would encourage you to run PC in a dedicated application pool. And while you don't identify who the new host is, this may be another example that points to the value of hosting PC stores with someone who actually knows the application and can provide the appropriate environment. Is this host accustomed to dealing with ProductCart?

Admin Place Order Stopped Working : The hosting company attached the...

Tue, 06 Sep 2011 12:21:34 +0000

Author: odathp
Subject: 4715
Posted: 06-September-2011 at 12:21pm

The hosting company attached the original database and the admin place order function still fails.

Guess I'll open a ticket on this.

Admin Place Order Stopped Working : I setup a sandbox on my local...

Tue, 06 Sep 2011 12:01:31 +0000

Author: odathp
Subject: 4715
Posted: 06-September-2011 at 12:01pm

I setup a sandbox on my local machine with the original database from the old server. The admin place order function tested ok.

I requested the hosting company attach that [original] database. I will then test the admin place order function on their server.

I want find out if their database restore from backup is causing the problem or if it's something else with their server configuration.

By the way, the hosting company is Gearhost. They are one of the recommended hosting companies listed on Early Impact's website .

Admin Place Order Stopped Working : Was wondering if the idDbSession...

Mon, 05 Sep 2011 17:43:13 +0000

Author: odathp
Subject: 4715
Posted: 05-September-2011 at 5:43pm

Was wondering if the idDbSession column should be a PK?

The session is being created, but no data is stored.

Edited by odathp - 05-September-2011 at 5:47pm

Admin Place Order Stopped Working : Hmmm, That seems very odd to me....

Mon, 05 Sep 2011 17:00:50 +0000

Author: Hamish
Subject: 4715
Posted: 05-September-2011 at 5:00pm

Hmmm, That seems very odd to me. Greg, any ideas?

Admin Place Order Stopped Working : Thank you Hamish for the feedback....

Mon, 05 Sep 2011 15:49:46 +0000

Author: odathp
Subject: 4715
Posted: 05-September-2011 at 3:49pm

Thank you Hamish for the feedback. Just so we are on the same page, customers are able to place order with no problems. Only Admin can not place an order.

I've studied the potential causes of a lost session (actually for a few years now).

I don't believe any directories are assigned the own Application Pool since I never instructed them to do so.

I added the code you included and am getting a response of 552044617 every time for every scenario. Customer logged in, customer logged out. Admin logged in/out. Admin place order. It never changes.

The only way I could get the value to change was to clear my browser cookies.

Admin Place Order Stopped Working : Hi Jack, Have you gone through...

Mon, 05 Sep 2011 15:24:29 +0000

Author: Hamish
Subject: 4715
Posted: 05-September-2011 at 3:24pm

Hi Jack,
Have you gone through the potential causes of a lost session? This is almost certainly what is happening :
http://wiki.earlyimpact.com/developers/timeout-issues

Also, make sure thatnone of the "ProductCart" folders (directories) are assigned to their ownApplication Pool (your hosting company can tell you this). If they are, you canexperience lost sessions.

In any case, ProductCart itself does not endthe server session unless the Order is Completed, the customer logs out... or ittimes out (after 20 minutes of non-activity), so it must be something elsethat's causing this. You might want to add the following line of code toyour 'pc/header.asp' file (in a discreet location), which will show theactual Session ID created by the Web server when a customer enters yoursite:

<%response.write session.SessionID %>

Pay attention to the number and then notice exactly whenit changes, which could provide insight into the cause.

Admin Place Order Stopped Working : Thanks Greg. We already took care...

Mon, 05 Sep 2011 15:14:15 +0000

Author: odathp
Subject: 4715
Posted: 05-September-2011 at 3:14pm

Thanks Greg. We already took care of that. When set to True, an order can not be placed at all since it switches to a secured connection during the order process and looses the session. Customers are processing orders fine. Just Admin having the problem. The thing that puzzles me is that I don't know when this started. Before or after the transfer. Before or after all the security updates. Or somewhere in between. Thanks again...