Web Wiz Support and Community Forums : Error With Upgrade Tool https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 22:51:36 +0000 Wed, 03 May 2006 11:03:23 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19658 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Error With Upgrade Tool : As you say, weird. I am going...]]> https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post106101.html#106101 Author: Jonathan8146
Subject: 19658
Posted: 03 May 2006 at 11:03am

As you say, weird. I am going to try and get a restore of the author table prior to the weekend and see if it is there.]]> Wed, 03 May 2006 11:03:23 +0000 https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post106101.html#106101 <![CDATA[Error With Upgrade Tool : Thats impossible, the password...]]> https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post106100.html#106100 Author: WebWiz-Bruce
Subject: 19658
Posted: 03 May 2006 at 10:54am

Thats impossible, the password field has been there since version 1 back in 2001, and the salt field was added in version 6 back in 2003

Without these fields then no version would run, so I don't no what's going on with your database, unless you modified it in some way to use a different login system.

The password field stores the password for the user since day 1, and without it no-one can login. The salt field stores the salt value for encrypted passwords, also required so users can login.
]]> Wed, 03 May 2006 10:54:33 +0000 https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post106100.html#106100 <![CDATA[Error With Upgrade Tool : I don&#039;t know, they don&#039;t...]]> https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post106099.html#106099 Author: Jonathan8146
Subject: 19658
Posted: 03 May 2006 at 10:44am

I don't know, they don't appear in the previous version's author table and they aren't added in the update tool.]]> Wed, 03 May 2006 10:44:26 +0000 https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post106099.html#106099 <![CDATA[Error With Upgrade Tool : Why are your password and salt...]]> https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post106086.html#106086 Author: WebWiz-Bruce
Subject: 19658
Posted: 03 May 2006 at 9:54am

Why are your password and salt fields missing??!!

Without these fields, then yes you will get errors in the loginUser() function, which is throwing the error.
]]> Wed, 03 May 2006 09:54:00 +0000 https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post106086.html#106086 <![CDATA[Error With Upgrade Tool : OK, I restored the db tables...]]> https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post106080.html#106080 Author: Jonathan8146
Subject: 19658
Posted: 03 May 2006 at 8:39am

OK, I restored the db tables and successfully ran the update. I loaded the first page OK but when I tried to login got the following error message:

Server Error in Forum Application
An error has occured while executing SQL query on database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_loginUser()_get_USR_login
File Name:- functions_login.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
The requested properties cannot be supported.


I will investigate, but any ideas welcome.

Don't know if this is the cause, but the Author table is missing fields Password and Salt


Edited by Jonathan8146 - 03 May 2006 at 9:25am]]> Wed, 03 May 2006 08:39:27 +0000 https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post106080.html#106080 <![CDATA[Error With Upgrade Tool : Thanks. I found that variable...]]> https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post105982.html#105982 Author: Jonathan8146
Subject: 19658
Posted: 02 May 2006 at 1:25pm

Thanks. I found that variable and edited it but in the end I started from scratch and created new tables, as it is only a test system.

I may try to upgrade the old tables again, but not sure if I'll have the time. If I do I'll let you know how I get on.
]]> Tue, 02 May 2006 13:25:18 +0000 https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post105982.html#105982 <![CDATA[Error With Upgrade Tool : STOP, you are doing it all wrong!!Go...]]> https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post105978.html#105978 Author: WebWiz-Bruce
Subject: 19658
Posted: 02 May 2006 at 1:16pm

STOP, you are doing it all wrong!!

Go back to your original 7.x database that I hoped you backed up as the database table prefix is supported by the upgrade tool.

Edit the upgrade tool with a text editor and replace the following with your table prefix:-

strDbTable = "tbl"

Then run the upgrade tool, when you upload version 8 to your server you will need to edit the file 'includes/setup_options.asp' and put in your database table prefix.


Edited by -boRg- - 02 May 2006 at 1:16pm]]> Tue, 02 May 2006 13:16:21 +0000 https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post105978.html#105978 <![CDATA[Error With Upgrade Tool : I have just run the upgrade...]]> https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post105938.html#105938 Author: Jonathan8146
Subject: 19658
Posted: 02 May 2006 at 11:16am

I have just run the upgrade tool but it failed. When setting up version 7 there is the option of specifiying what prefix to give all tables and stored procedures, in my case I chose to prefix them with "wwf".

The upgrade tool does not search for or ask for this prefix and so failed. I think that it is a fairly simple task to add another form field in the initial page to enter this, or maybe include the "admin/common.asp" file to pick it up.

I am hoping that the upgraded application will use this prefix or else I'm up the creek.

It's a shame, because I like this application very much, and have defended it against rivals.Unhappy

Finally managed to upgrade (I think) and yes, the prefix isn't included, so had to edit "Const strDbTable" in "setup_options_inc.asp" in the includes folder. It seems to be working now, though not done any proper testing.

I wished too soon!

Trying to login, getting invalid column name in tblAuthor, Password and Salt. Created them manually based on the information in the create tables asp and wont't login saying invalid username/password. Tried to create a new user and got

"Item cannot be found in the collection corresponding to the requested name or ordinal.

/scripts/forum/register.asp, line 886"


It just goes from bad to worse!!!



Edited by Jonathan8146 - 02 May 2006 at 12:27pm]]> Tue, 02 May 2006 11:16:24 +0000 https://forums.webwiz.net/error-with-upgrade-tool_topic19658_post105938.html#105938