Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 V33: BUG+FIX config.asp errors		  Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

gor
Retired Admin

Netherlands
5511 Posts
Posted - 26 July 2001 :  03:11:16  Show Profile  Visit gor's Homepage
The config.asp file of Version 3.3. fails to detect errors in the connection to the database.
So if the strConnString isn't set correctly you get this error when you run setup.asp:

Microsoft VBScript runtime error '800a01a8' 
 
Object required: 'rsConfig' 
 
/private/testforum/config.asp, line 159


I've modified config.asp and uploaded it to SourceForce, you can download it here: download link removed, use the one in the next reply...
If you replace the existing config.asp with this file it should tell you that it couldn't open the database (when that is the case) instead of this error.


Pierre
Join a Snitz Mailinglist

gor
Retired Admin

Netherlands
5511 Posts
Posted - 26 July 2001 :  08:22:18  Show Profile  Visit gor's Homepage
There is/was a second bug in config.asp which caused it to think you were upgrading a database instead of installing a new SQL-Server of MySql database.

A quick workaround was to use setup.asp?RC=5 instead.

I updated the config.asp so it now fixes both errors.
Get it here: http://prdownloads.sourceforge.net/sf2k/config_v3302.zip

Pierre
Join a Snitz Mailinglist
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 26 July 2001 :  20:01:53  Show Profile  Visit HuwR's Homepage
I just noticed a third.


this code

				strSql = "SELECT " & strTablePrefix & "CONFIG.C_STRVERSION, "
				strSql = strSql & strTablePrefix & "CONFIG.C_STRSENDER "
				strSql = strSql & " FROM " & strTablePrefix & "CONFIG "

				set rsInfo = my_Conn.Execute (StrSql)


Needs replacing with

				strSql = "SELECT " & strTablePrefix & "CONFIG_NEW.C_VALUE "
				strSql = strSql & " FROM " & strTablePrefix & "CONFIG_NEW "
				strSql = strSql & " WHERE " & strTablePrefix & "CONFIG_NEW.C_VARIABLE='strVersion'"
				set rsInfo = my_Conn.Execute (StrSql)
				strVersion = rsInfo("C_VALUE")
				rsInfo.Close

				strSql = "SELECT " & strTablePrefix & "CONFIG_NEW.C_VALUE "
				strSql = strSql & " FROM " & strTablePrefix & "CONFIG_NEW "
				strSql = strSql & " WHERE " & strTablePrefix & "CONFIG_NEW.C_VARIABLE='strSender'"
				set rsInfo = my_Conn.Execute (StrSql)
				strSender = rsInfo("C_VALUE")
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts
Posted - 27 July 2001 :  01:20:50  Show Profile  Visit gor's Homepage
quote:

I just noticed a third.


this code

				strSql = "SELECT " & strTablePrefix & "CONFIG.C_STRVERSION, "
				strSql = strSql & strTablePrefix & "CONFIG.C_STRSENDER "
				strSql = strSql & " FROM " & strTablePrefix & "CONFIG "

				set rsInfo = my_Conn.Execute (StrSql)


Needs replacing with

				strSql = "SELECT " & strTablePrefix & "CONFIG_NEW.C_VALUE "
				strSql = strSql & " FROM " & strTablePrefix & "CONFIG_NEW "
				strSql = strSql & " WHERE " & strTablePrefix & "CONFIG_NEW.C_VARIABLE='strVersion'"
				set rsInfo = my_Conn.Execute (StrSql)
				strVersion = rsInfo("C_VALUE")
				rsInfo.Close

				strSql = "SELECT " & strTablePrefix & "CONFIG_NEW.C_VALUE "
				strSql = strSql & " FROM " & strTablePrefix & "CONFIG_NEW "
				strSql = strSql & " WHERE " & strTablePrefix & "CONFIG_NEW.C_VARIABLE='strSender'"
				set rsInfo = my_Conn.Execute (StrSql)
				strSender = rsInfo("C_VALUE")




Well...actually we would "need" both, since before upgrading the CONFIG_NEW table isn't there yet.
So I combined the checks:

				strSql = "SELECT " & strTablePrefix & "CONFIG.C_STRVERSION, "
				strSql = strSql & strTablePrefix & "CONFIG.C_STRSENDER "
				strSql = strSql & " FROM " & strTablePrefix & "CONFIG "

				set rsInfo = my_Conn.Execute (StrSql)
				strVersion = rsInfo("C_STRVERSION")
				strSender = rsInfo("C_STRSENDER")
		
				rsInfo.Close
				set rsInfo = nothing

				if strVersion = "" then

					strSql = "SELECT " & strTablePrefix & "CONFIG_NEW.C_VALUE "
					strSql = strSql & " FROM " & strTablePrefix & "CONFIG_NEW "
					strSql = strSql & " WHERE " & strTablePrefix & "CONFIG_NEW.C_VARIABLE='strVersion'"
					set rsInfo = my_Conn.Execute (StrSql)
					strVersion = rsInfo("C_VALUE")
					rsInfo.Close
					set rsInfo = nothing

 					strSql = "SELECT " & strTablePrefix & "CONFIG_NEW.C_VALUE "
					strSql = strSql & " FROM " & strTablePrefix & "CONFIG_NEW "
					strSql = strSql & " WHERE " & strTablePrefix & "CONFIG_NEW.C_VARIABLE='strSender'"
					set rsInfo = my_Conn.Execute (StrSql)
					strSender = rsInfo("C_VALUE")
					rsInfo.Close
					set rsInfo = nothing
 
				end if
 
				my_Conn.Close
				set my_Conn = nothing



Pierre
Join a Snitz Mailinglist
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 31 July 2001 :  09:51:57  Show Profile  Visit HuwR's Homepage
good idea, needs adding to the list of fixes
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts
Posted - 07 November 2001 :  22:51:19  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
was this already fixed?

---------------
-Da_Stimulator
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 08 November 2001 :  03:13:47  Show Profile  Visit HuwR's Homepage
The third error was not fixed I think, I will check when I am ding the setup.asp
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 09 March 2002 :  01:44:32  Show Profile
this has been fixed in v3.4
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.4 seconds. Powered By: Snitz Forums 2000 Version 3.4.07