ProductCart Shopping Cart Software Forums : Upgrading 3.051 to 3.11 db error

ProductCart Shopping Cart Software Forums : Upgrading 3.051 to 3.11 db error https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 19:30:07 +0000 Thu, 19 Feb 2009 10:10:09 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=2467 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Upgrading 3.051 to 3.11 db error : Just goes to show how many different...]]> https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post9014.html#9014 Author: intour
Subject: 2467
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

]]> Thu, 19 Feb 2009 10:10:09 +0000 https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post9014.html#9014 <![CDATA[Upgrading 3.051 to 3.11 db error : Turns out it was the menu.asp...]]> https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post9012.html#9012 Author: BrianRoden
Subject: 2467
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.]]> Thu, 19 Feb 2009 09:39:10 +0000 https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post9012.html#9012 <![CDATA[Upgrading 3.051 to 3.11 db error : Check your settings.asp file in...]]> https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8956.html#8956 Author: intour
Subject: 2467
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

]]> Sun, 15 Feb 2009 08:44:16 +0000 https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8956.html#8956 <![CDATA[Upgrading 3.051 to 3.11 db error : As stated the reported db error...]]> https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8892.html#8892 Author: JoltDigital
Subject: 2467
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.

]]> Wed, 11 Feb 2009 19:43:57 +0000 https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8892.html#8892 <![CDATA[Upgrading 3.051 to 3.11 db error : I looked at the TXT files in the...]]> https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8880.html#8880 Author: BrianRoden
Subject: 2467
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.

Edited by BrianRoden - 11-February-2009 at 11:57am]]> Wed, 11 Feb 2009 10:10:48 +0000 https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8880.html#8880 <![CDATA[Upgrading 3.051 to 3.11 db error : I've done what both replies...]]> https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8856.html#8856 Author: BrianRoden
Subject: 2467
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?

]]> Tue, 10 Feb 2009 14:47:10 +0000 https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8856.html#8856 <![CDATA[Upgrading 3.051 to 3.11 db error : This could be a "red herring"...]]> https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8852.html#8852 Author: ProductCart
Subject: 2467
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.]]> Tue, 10 Feb 2009 13:12:17 +0000 https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8852.html#8852 <![CDATA[Upgrading 3.051 to 3.11 db error : I had a similar problem using...]]> https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8851.html#8851 Author: katharina
Subject: 2467
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
]]> Tue, 10 Feb 2009 13:11:53 +0000 https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8851.html#8851 <![CDATA[Upgrading 3.051 to 3.11 db error : We're working on upgrading...]]> https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8850.html#8850 Author: BrianRoden
Subject: 2467
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?

]]> Tue, 10 Feb 2009 13:08:30 +0000 https://forum.productcart.com/upgrading-3-051-to-3-11-db-error_topic2467_post8850.html#8850