| Author |
 Topic Search  Topic Options
|
markradaba 
Newbie
Joined: 02 September 2005
Location: United States
Status: Offline
Points: 39
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: v8 vs v9 database differences...
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!
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
markradaba
Newbie
Joined: 02 September 2005
Location: United States
Status: Offline
Points: 39
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
dazler
Newbie
Joined: 03 November 2004
Location: United Kingdom
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
dazler
Newbie
Joined: 03 November 2004
Location: United Kingdom
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
