Using ProductCart - Slow Login

Slow Login

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=4530
Printed Date: 05-March-2025 at 11:28pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Slow Login

Posted By: rivaldog
Subject: Slow Login
Date Posted: 07-June-2011 at 11:13am

We run ProductCart v3.51b. The size of the MSsql database became too large for the shared database sever so we moved it to our VPS. Now that we moved it, two problems have developed.

We think they're somehow linked since they deal with some kind of latent authorization process.

Problem #1: It takes minutes to login to the admin panel. In fact, we have to wait five minutes or so for the browser page to ultimately time-out then hit our back button twice to begin running the admin console (what a pain).

Problem #2: The Paypal Standard payment option processes about 1 out of 10 orders now. All paypal customers get charged and Paypal sends all the right info back to productcart but only 1 out of 10 orders complete allowing the customer to download their order. The other 9 orders just show incomplete and we have to manually fulfill.

Bot of these issues only appeared when we moved the database and they both seem to be some kind of ProductCart authorization process that's getting hung to the point of timing out. Can anyone help us with this?

thank you!

-------------
Rivaldog

Replies:

Posted By: ProductCart
Date Posted: 07-June-2011 at 3:32pm

Did you only change the database? The issues you are having seem unrelated to the database. Please open a support ticket so that we may investigate things more closely.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: rivaldog
Date Posted: 08-June-2011 at 7:19am

Yes - all we did was move the database - nothing more. The site won't allow me to open a ticket - states that my Productcart license is no longer supported without paying $195.00.

-------------
Rivaldog

Posted By: Hamish
Date Posted: 08-June-2011 at 7:49am

Hi Rivaldog,
The support policy changed back in Sept 2009. Please see http://www.earlyimpact.com/newsletter/09.14.09.htm - http://www.earlyimpact.com/newsletter/09.14.09.htm
We used to charge for major upgrades, but now they are included in the support and updates plan.If you have already purchased the plan and are for some reason still unable to access the support system please send me a PM.

-------------
Editing ProductCart Code?

See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code

Posted By: intour
Date Posted: 08-June-2011 at 12:16pm

Is the database in a different datacenter to your productcart files? That would certainly cause it to slow down.

Nigel

-------------
http://www.innerview.co.uk - Innerview
Productcart Platinum Reseller
Web Design/Hosting/Virtual Tours

Posted By: rivaldog
Date Posted: 09-June-2011 at 11:28am

Ok, so if I were to pay the $195.00, my ProductCart version could be upgraded to the current (stable) version? Also, if I were to do this, would I be able to use the free install and hosting special currently running?

-------------
Rivaldog

Posted By: ProductCart
Date Posted: 09-June-2011 at 11:40am

The Technical Support & Software Updates Plan covers support and software updates/upgrades for a year. You will indeed be able to upgrade your ProductCart store to the latest version.

The free installation and free hosting offer applies only to new ProductCart licenses.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: whizzinpc
Date Posted: 10-June-2011 at 4:10pm

Did you move just the database? If yes, that's definitely what is causing the latency.