Web Wiz Support and Community Forums : v8 vs v9 database differences... https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 17:27:09 +0000 Mon, 03 Sep 2007 17:33:01 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24004 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[v8 vs v9 database differences... : If you log into the admin area...]]> https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post127137.html#127137 Author: WebWiz-Bruce
Subject: 24004
Posted: 03 September 2007 at 5:33pm

If you log into the admin area you should be able to select one of the built in skins from their. Once you select and apply the skin it should update the server forum cache and render the pages using it.]]> Mon, 03 Sep 2007 17:33:01 +0000 https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post127137.html#127137 <![CDATA[v8 vs v9 database differences... : I&#039;ve managed to update the...]]> https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post127136.html#127136 Author: dazler
Subject: 24004
Posted: 03 September 2007 at 5:23pm

I've managed to update the database OK with the new fields, and it works without problems, but I have a problem with the forum default stylesheet, I guess I should not have tested the new blank webwiz forum before I sorted out the new updated database with populated data?
 
The default stylesheet is disabled from the new application [it does not find the right folder name for the file it needs default.css], some security feature I guess. On a shared host I do not have access to ISS so Its not possible to authenticate myself as unique. If I set all the permissions for myself to change the database then anybody else can to the same if you can see what I mean, nice comments though?
 
I will try to extract the data only via enterprise manager into a blank structure copy of the new database and use that, and run that first with the new asp files, it should work.
 
Best regards,
 
David.
]]> Mon, 03 Sep 2007 17:23:50 +0000 https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post127136.html#127136 <![CDATA[v8 vs v9 database differences... : All good web hosts have a special...]]> https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post127133.html#127133 Author: WebWiz-Bruce
Subject: 24004
Posted: 03 September 2007 at 2:51pm

All good web hosts have a special folder for your Access database, we do the same with our hosting, so this is not a problem for the upgrade tool.

With the upgrade tool all you need to do is type in either the path from the upgrade tool to your database, or type in the physical server path to the database folder, which your host can give you.

If you want to use the first approach and your database folder is called 'db' located above the root of your web site you would use ../ to move up a directory. eg:-

../db/wwForum.mdb

The second approach using a physical path would be in the format of:-

D:/website/yourwebsite/db/wwForum.mdb
]]> Mon, 03 Sep 2007 14:51:11 +0000 https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post127133.html#127133 <![CDATA[v8 vs v9 database differences... : I&#039;m sure the upgrade tool...]]> https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post127132.html#127132 Author: dazler
Subject: 24004
Posted: 03 September 2007 at 2:41pm

I'm sure the upgrade tool works fine, however I cannot use it to run asp scripts on because my webhost has a special folder for holding and securing databases with, it has restrictions on shared hosts. I also cannot run the upgrade script for access from my local pc, the downloadbox always appears, so I am forced to try the manual approach, its a pain to do this?
 
My only option now is to compare the tables and fields in the MSAccess 8.4 version with the current 9.3 access version and add the new fields. Any existing fields that have been modified will certainly pose a problem [relationships and data integrity], a simple list of changes published would be most useful, not a long version application history list though, but a specific update list for the database.
 
Best Regards,
 
David.
]]> Mon, 03 Sep 2007 14:41:23 +0000 https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post127132.html#127132 <![CDATA[v8 vs v9 database differences... : This means that you have done...]]> https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post125992.html#125992 Author: WebWiz-Bruce
Subject: 24004
Posted: 03 August 2007 at 9:10am

This means that you have done it wrong.

You should use the upgrade tool, if you get a read-only error it means that the permissions are incorrect and you need to have read, write, and modify permissions on the database for the IUSR account.
]]> Fri, 03 Aug 2007 09:10:41 +0000 https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post125992.html#125992 <![CDATA[v8 vs v9 database differences... : Borg, I backed up my database...]]> https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post125967.html#125967 Author: markradaba
Subject: 24004
Posted: 02 August 2007 at 10:22pm

Borg,
 
I backed up my database and did the modifications to it by hand, since I can't get the database upgrade tool to work (it keeps reporting the database as read only)...
 
However, once I test out the database, I get the following error:
 
Server Error in Forum Application
An error has occurred while reading user data from the database.
Please contact the forum administrator.

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

Error details:-
Microsoft JET Database Engine
No value given for one or more required parameters.
 
Any idea what I did wrong?
 
]]> Thu, 02 Aug 2007 22:22:07 +0000 https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post125967.html#125967 <![CDATA[v8 vs v9 database differences... : In the Version History file that...]]> https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post125797.html#125797 Author: WebWiz-Bruce
Subject: 24004
Posted: 31 July 2007 at 8:45am

In the Version History file that comes with the download, all new fields are listed.

There isn't very many so shouldn't take long.
]]> Tue, 31 Jul 2007 08:45:27 +0000 https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post125797.html#125797 <![CDATA[v8 vs v9 database differences... : Borg, Is there a list of what...]]> https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post125791.html#125791 Author: markradaba
Subject: 24004
Posted: 31 July 2007 at 7:07am

Borg,
 
Is there a list of what changes have been made to the database between v8 and v9, specifically the MS Access version?
 
I can't get the upgrade utility to work, so I'm figuring I could probably try upgrading the database manually.
 
Thanks!
 
 
]]> Tue, 31 Jul 2007 07:07:57 +0000 https://forums.webwiz.net/v8-vs-v9-database-differences_topic24004_post125791.html#125791