Web Wiz Forums - upgrade tool

Print Page | Close Window

upgrade tool - error -

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=22795
Printed Date: 07 April 2026 at 2:28am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: upgrade tool - error -

Posted By: wolfman
Subject: upgrade tool - error -
Date Posted: 28 February 2007 at 3:43pm

Database Updated Started

Stage 1: Database Connection..... Complete

Stage 2: Creating New Database Tables and Fields.....
Error Update the Table tblThread
Timeout expired

Error Dropping Contraints in Table tblPermissions
The object 'DF__tblPermiss__Read__5AEE82B9' is dependent on column 'Read'.

Complete

Stage 3: Creating Index's on database..... Complete

Stage 4: Entering default values for new fields..... Complete

Stage 5: Populating Database with Default Forum Permissions (this may take some time to complete).....
Permissions are reset to original defaults, you may need to update them once the upgrade is complete.
Complete

Stage 6: Populating Database with Forum Statistics (this may take some time to complete).....Complete

Stage 7: Populating Database with Topic Statistics (this may take some time to complete)..... Complete

Error Discription: The object 'DF__tblPermiss__Read__5AEE82B9' is dependent on column 'Read'.
SQL Server database is set up, but with Error!

Any ideas?

WOLF

Replies:

Posted By: WebWiz-Bruce
Date Posted: 28 February 2007 at 3:52pm

looks like your server timeout.

Probably best to go back to your backup database, delete the field, tblPermisisons -> Read manually, then run the update tool again.

You may also want to do this at a time when the SQL server isn't underload so you don't get the timeout 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: wolfman
Date Posted: 28 February 2007 at 5:53pm

Thanks Borg - I tried this and I received the following error

Also - the server shouldn't time out as there is nothing using the database or SQL server. Any ideas?

Database Updated Started

Stage 1: Database Connection..... Complete

Stage 2: Creating New Database Tables and Fields.....
Error Update the Table tblThread
Timeout expired

Error Dropping Contraints in Table tblPermissions
ALTER TABLE DROP COLUMN failed because column 'Read' does not exist in table 'tblPermissions'.

Complete

Stage 3: Creating Index's on database..... Complete

Stage 4: Entering default values for new fields..... Complete

Stage 5: Populating Database with Default Forum Permissions (this may take some time to complete).....
Permissions are reset to original defaults, you may need to update them once the upgrade is complete.
Complete

Stage 6: Populating Database with Forum Statistics (this may take some time to complete).....Complete

Stage 7: Populating Database with Topic Statistics (this may take some time to complete)..... Complete

Error Discription: ALTER TABLE DROP COLUMN failed because column 'Read' does not exist in table 'tblPermissions'.
SQL Server database is set up, but with Error!

Posted By: wolfman
Date Posted: 08 March 2007 at 1:16pm

When removing the read feild from the table I receive the above error. any ideas from anyone?

thanks!

Posted By: wolfman
Date Posted: 28 June 2007 at 7:57pm

I have had a horrible time of trying to upgrade the SQL version of forums from 7 to 8.

I originally started with ver 7 access and then converted to SQL - now I would greatly like to convert from SQL 7 to SQL 8.

I ran the migration tool several times, receiving the above errors.

I am at my wits end with this and am wondering if there are any wiz/SQL gurus out there that could help. I am willing to pay for the help needed to successfully upgrade the forums to ver 8.06.

Anyone willing to do this, please contact me via PM and we can discuss details. The forums are currently located at http://www.uptempoairforums.com/ - http://www.uptempoairforums.com

Thank you

Wolf

Posted By: WebWiz-Bruce
Date Posted: 29 June 2007 at 10:32am

Upgrading from Access to SQL is probably what's coursed the problem.

The rest of the file should run fine and skip this error. The actual error drops the column 'read' from the table tblPermissions this has been done to make the database compatible with SQL Server.

However, you can either manually remove this field from the database, or just leave it in as it makes no odds as the field isn't used anymore.

-------------
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: wolfman
Date Posted: 29 June 2007 at 12:15pm

maybe I am not leaving important files in the directory structure. The instructions say to remove all version 7 code... What files should I take out to do this? And what files if anything should I leave in?

Posted By: WebWiz-Bruce
Date Posted: 29 June 2007 at 1:13pm

Version 7 will not work witha version 8 database as it will corrupt the database.

When upgrading from version 7 to version 8 the only thing that remains is the database, all other files should be removed except for the upload folder if your users have uploaded their own files.

-------------
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: wolfman
Date Posted: 29 June 2007 at 1:21pm

okay, excellent. Here is what i did in the order i did it

1. Backed up the database.

2. Ran the migration tool.

3. Removed version 7 code from server.

3. Uploaded the fresh ver 8 code to server.

4. Tried running default.asp

I receied this error.

Server Error in Forum Application
An error has occured while reading user data from the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_getUserData()_get_member_data
File Name:- functions_login.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid column name 'No_of_PM'.

Posted By: WebWiz-Bruce
Date Posted: 29 June 2007 at 2:15pm

I think the problem here is that you moved from Access to SQL Server, often moving between database versions produces unstable databases that are no longer compatible.

It would seem that this maybe the case in your instance and you may not be able to upgrade your database to version 8.

-------------
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: Wrightwood
Date Posted: 24 July 2007 at 10:02pm

I hope there are no stupid questions? In the past, mostly by accident I have been able to figure out the Physical Server Path to Database and Path from this application to database but I really don't know how to determine this.

Would someone please explain in laymans detail how you determine what your path to the database is? I have been trying for over an hour to connect to my database and use the migrate tool for 8 to 9.

An example would be: what folder do you start with and what needs to be put into the path in order for it to connect.

Thank you I'm embarassed but don't I want to spend any more time scouring the Internet for the answer.

Posted By: WebWiz-Bruce
Date Posted: 25 July 2007 at 7:33am

You haven't mentioned the database type you are using!! However seeing you mention path, I'm guessing this is Access.

The simplest way to do this is place the upgrade tool file and the Access database in the same folder and then put in the database file name (wwForum.mdb) and put in the path as / as it is in the same folder.

Some other tips, if the folder is above where you are you use ../ to move up a folder.

Have a look at the KB article on securing the access database it should give you some clues:-

http://www.webwiz.net/webwizforums/kb/moving_access_database.asp - http://www.webwiz.net/webwizforums/kb/moving_access_database.asp

-------------
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: Wrightwood
Date Posted: 25 July 2007 at 10:43am

Yes it is access. I would also like to know if I can run a forum directly from localhost on my computer for editing and such.

Thanks for the link. I tried the examples in the database folder provided with no luck. I will try the dots before the slash.

I am confused by the absolute path vs the virtual path.

Thanks again for your attention!

Posted By: WebWiz-Bruce
Date Posted: 25 July 2007 at 11:21am

The upgrade tool has:-

Physical Server Path to Database
Path from this application to database

The physical path would be the path on the server eg. C:\mywebiste\db\

Path from the application will be the relative path from the page you are using, eg if in the same folder you would use / if in a db folder one folder up you would use ../db/

-------------
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