| Author |
 Topic Search  Topic Options
|
javi712 
Senior Member
Joined: 22 May 2003
Location: United States
Status: Offline
Points: 488
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Server Error
Posted: 21 March 2006 at 6:56pm |
|
Hi Borg, Sorry for reposting this, but I guess I had made my previous post in the wrong place. I used the migration tool to upgrade from 7.x to 8.0 using access. Upon completion, it said the migration was successful but with an error. Once I set up the converted db to run with the forum, I get the following 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_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 Ideas what this could be?
Thanks in advance!
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 March 2006 at 7:06pm |
|
It looks like the upgrade tool has not worked and some of the new fields have not been created.
Go back to your original backed up database and use a copy of that to run the upgrade tool again.
If you get an error again, let me know what the error is so that I can look into this issue.
|
|
javi712
Senior Member
Joined: 22 May 2003
Location: United States
Status: Offline
Points: 488
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 March 2006 at 7:15pm |
|
Thanks for your response Borg.
Below is the error I receive when upgrading the database:
Database Updated Started
Stage 1: Database Connection..... Complete
Stage 2: Creating New Database Tables and Fields.....
Error Updating the Table tblTopic
Field 'Hide' already exists in table 'tblTopic'.
Error Update the Table tblThread
Field 'Hide' already exists in table 'tblThread'.
Error Updating the Table tblPermissions
Field 'Display_post' already exists in table 'tblPermissions'.
Complete
Stage 3: Entering default values for new fields..... Complete
Stage 4: Populating Database with Default Forum Permissions (this may take some time to complete).....
Permissions are reset to original defaults, you may need to update them once the upgrade is complete.
Complete
Stage 5: Populating Database with Forum Statistics (this may take some time to complete).....Complete
Stage 6: Populating Database with Topic Statistics (this may take some time to complete)..... Complete
Error Discription: No value given for one or more required parameters.
Access database is updated, but with Error!
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 March 2006 at 11:29am |
|
If you are getting an these error is suggests that you are not updating a version 7.x database.
Get your original 7.x database and run the upgrade tool, only once on that database.
If you get an error let me know, and make sure you keep an original copy of your database.
Running the upgrade tool on a database that is already update will screw the database up.
|
|
javi712
Senior Member
Joined: 22 May 2003
Location: United States
Status: Offline
Points: 488
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 March 2006 at 11:53am |
|
Hi Borg,
I am currently running version 7.9 of the forum. And it is the original database that I am using.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 March 2006 at 11:58am |
|
Yes I know that.
But you are having a problem with upgrading, please follow my suggestions in my previous post and try the upgrade process again on your version 7.x database, NOT one you have already tried to upgrade.
|
|
javi712
Senior Member
Joined: 22 May 2003
Location: United States
Status: Offline
Points: 488
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 March 2006 at 2:07pm |
|
Hi Borg, I appreicate your patience!
These are the steps I took to upgrade the database:
1) Downloaded a copy to my local machine to keep as a back-up.
2) Uploaded a copy of that db to my database folder in the new forum directory i created with WWF 8.0.
3) I ran acces_update.asp and pointed the script to database/wwForum.mdb (i renamed the uploaded db to wwForum.mdb)
4) The script still produced the same error.
I never ran any of the beta sites, so there is no way I could have updated the database already and I am not getting any error when running the db I copied from on my live site.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 March 2006 at 2:10pm |
|
Could you let me have a copy of your original version 7.x database so that I can run some tests on it and find the exact course of the issue?
This way hopefully I can refine the upgrade tool so no-one else gets this issue.
|
|
