Web Wiz Support and Community Forums : upgrade tool - error - https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 04:00:26 +0000 Wed, 25 Jul 2007 11:21:06 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22795 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[upgrade tool - error - : The upgrade tool has:-Physical...]]> https://forums.webwiz.net/upgrade-tool-error_topic22795_post125397.html#125397 Author: WebWiz-Bruce
Subject: 22795
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/
]]> Wed, 25 Jul 2007 11:21:06 +0000 https://forums.webwiz.net/upgrade-tool-error_topic22795_post125397.html#125397 <![CDATA[upgrade tool - error - : Yes it is access. I would also...]]> https://forums.webwiz.net/upgrade-tool-error_topic22795_post125395.html#125395 Author: Wrightwood
Subject: 22795
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!
]]> Wed, 25 Jul 2007 10:43:49 +0000 https://forums.webwiz.net/upgrade-tool-error_topic22795_post125395.html#125395 <![CDATA[upgrade tool - error - : You haven&#039;t mentioned the...]]> https://forums.webwiz.net/upgrade-tool-error_topic22795_post125375.html#125375 Author: WebWiz-Bruce
Subject: 22795
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
]]> Wed, 25 Jul 2007 07:33:11 +0000 https://forums.webwiz.net/upgrade-tool-error_topic22795_post125375.html#125375 <![CDATA[upgrade tool - error - : I hope there are no stupid questions?...]]> https://forums.webwiz.net/upgrade-tool-error_topic22795_post125360.html#125360 Author: Wrightwood
Subject: 22795
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.
]]> Tue, 24 Jul 2007 22:02:02 +0000 https://forums.webwiz.net/upgrade-tool-error_topic22795_post125360.html#125360 <![CDATA[upgrade tool - error - : I think the problem here is that...]]> https://forums.webwiz.net/upgrade-tool-error_topic22795_post124153.html#124153 Author: WebWiz-Bruce
Subject: 22795
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.
]]> Fri, 29 Jun 2007 14:15:44 +0000 https://forums.webwiz.net/upgrade-tool-error_topic22795_post124153.html#124153 <![CDATA[upgrade tool - error - : okay, excellent. Here is what...]]> https://forums.webwiz.net/upgrade-tool-error_topic22795_post124150.html#124150 Author: wolfman
Subject: 22795
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'.

]]> Fri, 29 Jun 2007 13:21:31 +0000 https://forums.webwiz.net/upgrade-tool-error_topic22795_post124150.html#124150 <![CDATA[upgrade tool - error - : Version 7 will not work witha...]]> https://forums.webwiz.net/upgrade-tool-error_topic22795_post124148.html#124148 Author: WebWiz-Bruce
Subject: 22795
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.
]]> Fri, 29 Jun 2007 13:13:02 +0000 https://forums.webwiz.net/upgrade-tool-error_topic22795_post124148.html#124148 <![CDATA[upgrade tool - error - : maybe I am not leaving important...]]> https://forums.webwiz.net/upgrade-tool-error_topic22795_post124145.html#124145 Author: wolfman
Subject: 22795
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?
]]> Fri, 29 Jun 2007 12:15:52 +0000 https://forums.webwiz.net/upgrade-tool-error_topic22795_post124145.html#124145 <![CDATA[upgrade tool - error - : Upgrading from Access to SQL is...]]> https://forums.webwiz.net/upgrade-tool-error_topic22795_post124141.html#124141 Author: WebWiz-Bruce
Subject: 22795
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.
]]> Fri, 29 Jun 2007 10:32:21 +0000 https://forums.webwiz.net/upgrade-tool-error_topic22795_post124141.html#124141 <![CDATA[upgrade tool - error - : I have had a horrible time of...]]> https://forums.webwiz.net/upgrade-tool-error_topic22795_post124129.html#124129 Author: wolfman
Subject: 22795
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

Thank you

Wolf



Edited by wolfman - 28 June 2007 at 7:58pm]]> Thu, 28 Jun 2007 19:57:28 +0000 https://forums.webwiz.net/upgrade-tool-error_topic22795_post124129.html#124129