| Author |
 Topic Search  Topic Options
|
NéoK1000 
Newbie
Joined: 19 May 2004
Location: France
Status: Offline
Points: 6
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Problem with post_message.asp
Posted: 19 May 2004 at 1:57pm |
I have a problem when an user not loged wants to write something (new topic or answer).
Sorry error message is in french :
 HTTP 500.100
Microsoft JET Database Engine (0x80040E21)
Vous ne pouvez pas ajouter ou modifier un enregistrement car l'enregistrement associé est requis dans la table 'tblAuthor'.
/archimede/forum/post_message.asp, line 756 |
in english ~ you can't add or modify a record because the associated record is needed by 'tblAuthor' table.
thks !
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 May 2004 at 3:44am |
|
Could be a corrupted file, try reuploading again.
The database could also be corrupted, if using Access, use the compact and repair feature in the admin area.
|
|
|
|
NéoK1000
Newbie
Joined: 19 May 2004
Location: France
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 May 2004 at 5:23am |
Still the same error after re-uploading :
Microsoft JET Database Engine error '80040e21'
You cannot add or change a record because a related record is required in table 'tblAuthor'.
/archimede/forum/post_message.asp, line 756
|
|
NéoK1000
Newbie
Joined: 19 May 2004
Location: France
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 May 2004 at 5:26am |
And after the compact-repair of database, still the same error
Microsoft JET Database Engine error '80040e21'
You cannot add or change a record because a related record is required in table 'tblAuthor'.
/archimede/forum/post_message.asp, line 756 |
|
|
NéoK1000
Newbie
Joined: 19 May 2004
Location: France
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 May 2004 at 5:32am |
I have another problem when I want to delete an author who has posted some messages.
Microsoft JET Database Engine error '80004005'
You cannot add or change a record because a related record is required in table 'tblAuthor'.
/archimede/forum/delete_member.asp, line 124 |
I must delete his message to be able to delete him ...
I think it's linked with the other problem because it's about the same 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: 20 May 2004 at 10:51am |
|
Have you deleted any of the built in accounts like the Admin and Guest accounts that come with the forum?
If so this is the problem.
You will need to start again with an unmodified database with the built
in admin and guest accounts in the tblAuthor table left in place.
Without both of these accounts your forum will not run correctly and you will get errors like you mention.
Looking at the error messages you are getting it does look like you
have deleted the Guest account from your database. This account stores
the posts for unregistered users, this is why they can not post.
Other errors like when you delete a member will also not work and you
may also find that things like permissions will not work and other
errors occuring.
Edited by -boRg-
|
|
|
|
NéoK1000
Newbie
Joined: 19 May 2004
Location: France
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 May 2004 at 8:53am |
I thinks you are right, i'm sorry for my stupid question !
Thank you very much, i'm going to fix my forum thanks to you !
|
|
NéoK1000
Newbie
Joined: 19 May 2004
Location: France
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 23 May 2004 at 7:50am |
|
It's OK !
|
|
