Web Wiz Forums - v8 vs v9 database differences...

Print Page | Close Window

v8 vs v9 database differences...

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=24004
Printed Date: 06 April 2026 at 5:24pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: v8 vs v9 database differences...

Posted By: markradaba
Subject: v8 vs v9 database differences...
Date 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!

Replies:

Posted By: WebWiz-Bruce
Date 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.

-------------
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: markradaba
Date 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?

Posted By: WebWiz-Bruce
Date 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.

-------------
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: dazler
Date 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.

Posted By: WebWiz-Bruce
Date 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

-------------
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: dazler
Date 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.

Posted By: WebWiz-Bruce
Date 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.

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