Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - upgrade tool - error -
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

upgrade tool - error -
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
wolfman View Drop Down
Groupie
Groupie


Joined: 04 August 2004
Location: United States
Status: Offline
Points: 51 		Post Options Post Options   Thanks (0) Thanks(0)   Quote wolfman Quote  Post ReplyReply Direct Link To This Post 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'.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Wrightwood View Drop Down
Newbie
Newbie


Joined: 09 November 2005
Status: Offline
Points: 23 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Wrightwood Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Wrightwood View Drop Down
Newbie
Newbie


Joined: 09 November 2005
Status: Offline
Points: 23 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Wrightwood Quote  Post ReplyReply Direct Link To This Post 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!
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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/
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.