Upgrading 3.051 to 3.11 db error

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
BrianRoden Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 07-September-2007 Status: Offline Points: 0	Post Options Post Reply Quote BrianRoden Report Post Thanks(0) Quote Reply Topic: Upgrading 3.051 to 3.11 db error 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?

katharina Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 25-October-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote katharina Report Post Thanks(0) Quote Reply 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

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply 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 shopping cart software

BrianRoden Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 07-September-2007 Status: Offline Points: 0	Post Options Post Reply Quote BrianRoden Report Post Thanks(0) Quote Reply 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?

BrianRoden Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 07-September-2007 Status: Offline Points: 0	Post Options Post Reply Quote BrianRoden Report Post Thanks(0) Quote Reply 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

JoltDigital Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 26-October-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote JoltDigital Report Post Thanks(0) Quote Reply 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.
	JoltDigital Inc. 1-888-785-5658 Premium ProductCart Hosting

intour Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 30-June-2006 Location: United Kingdom Status: Offline Points: 0	Post Options Post Reply Quote intour Report Post Thanks(0) Quote Reply 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
	Innerview Productcart Platinum Reseller Web Design/Hosting/Virtual Tours

BrianRoden Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 07-September-2007 Status: Offline Points: 0	Post Options Post Reply Quote BrianRoden Report Post Thanks(0) Quote Reply 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.

intour Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 30-June-2006 Location: United Kingdom Status: Offline Points: 0	Post Options Post Reply Quote intour Report Post Thanks(0) Quote Reply 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
	Innerview Productcart Platinum Reseller Web Design/Hosting/Virtual Tours