Error With Upgrade Tool
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=19658
Printed Date: 12 April 2026 at 12:27am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Error With Upgrade Tool
Posted By: Jonathan8146
Subject: Error With Upgrade Tool
Date 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.  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!!! |
Replies:
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Jonathan8146
Date 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. |
Posted By: Jonathan8146
Date 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 |
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Jonathan8146
Date 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. |
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Jonathan8146
Date 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. |