Using ProductCart - Upgrading 3.051 to 3.11 db error

Print Page | Close Window

Upgrading 3.051 to 3.11 db error

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=2467
Printed Date: 06-October-2024 at 12:20pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Upgrading 3.051 to 3.11 db error

Posted By: BrianRoden
Subject: Upgrading 3.051 to 3.11 db error
Date Posted: 10-February-2009 at 1:08pm

We're working on upgrading our site from 3.051 to 3.11, then to 3.5. As soon as I copy the files from the update ZIP to the server, and try to log in to the control panel to run the database upgrade, I get the dbError.asp page saying that it can't connect to the SQL DB.

storeconstants.asp still has the correct connection string. If I copy the files from my pre-upgrade backup back to the server, I can again log in, still at the old version.

Is there something else the new control panel files are looking for that if not present was cause an erroneous DB error?

Replies:

Posted By: katharina
Date Posted: 10-February-2009 at 1:11pm

I had a similar problem using IE. Switching to FF solved it. Otherwise open a ticket with IE, they are usually fast finding and fixing issues.
Katharina

Posted By: ProductCart
Date Posted: 10-February-2009 at 1:12pm

This could be a "red herring" type of error. Please check and reset the permissions on the 'pcadmin/CPLogs' folder. Make sure the permissions are set to read/write/modify (sometimes called "delete"). Once the permissions are reset, try accessing the control panel again.

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

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

Posted By: BrianRoden
Date Posted: 10-February-2009 at 2:47pm

I've done what both replies suggested, and neither fixed it.

I gave Modify rights on cplogs to the Network Service and Internet Guest Account the site runs under. Is there another account I should be looking at?

Posted By: BrianRoden
Date Posted: 11-February-2009 at 10:10am

I looked at the TXT files in the cpLogs folder, and entries are being made, so the server has the proper permissions to write to this folder.

I've twice restored my backup of the 3.051 cart, and re-tried the 3.11 upgrade install, and still get this DB error.

Update: I just followed the suggestion in the Database Connection Problem error page to try running the setup/default.asp to test the connection string, and the connection string tests fine.

Is there anything I should look for in the SQL DB tables themselves? It's on SQL 2005, and I have full management studio access to the DB.

Posted By: JoltDigital
Date Posted: 11-February-2009 at 7:43pm

As stated the reported db error is not the issue. Comment out the on error code in the page (and includes) that is throwing the error and turn off friendly errors in your browser. You should get a good error message at that point.

In the past when I have seen this error it is due to a missing file/directory or a permission problem.

-------------
http://www.joltdigital.com/host_pc.asp - JoltDigital Inc.
1-888-785-5658
Premium ProductCart Hosting

Posted By: intour
Date Posted: 15-February-2009 at 8:44am

Check your settings.asp file in the includes folder and make sure it is showing the correct version.

I have had a couple of upgrade instances where and this also causes the error even when permissionjs are correctly set.

Nigel

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

Posted By: BrianRoden
Date Posted: 19-February-2009 at 9:39am

Turns out it was the menu.asp file including the adovbs.inc while another ASP app on the same web server also used those constants. A duplicate constant definition was occurring. Temporarily commenting out the "ON ERROR RESUME NEXT" lines in a couple of files let me see the real error message.

Posted By: intour
Date Posted: 19-February-2009 at 10:10am

Just goes to show how many different things can give a similar error message.

No wonder I lost my hair !

Nigel

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