Web Wiz Forums - Problem with post

Print Page | Close Window

Problem with post_message.asp

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=10520
Printed Date: 08 April 2026 at 10:42am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Problem with post_message.asp

Posted By: N�oK1000
Subject: Problem with post_message.asp
Date 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 !

Replies:

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

-------------
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: N�oK1000
Date 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

Posted By: N�oK1000
Date 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

Posted By: N�oK1000
Date 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

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

-------------
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: N�oK1000
Date 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 !

Posted By: N�oK1000
Date Posted: 23 May 2004 at 7:50am

It's OK !