Print Page | Close Window

error on deleting members

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


Topic: error on deleting members
Posted By: triggerlock
Subject: error on deleting members
Date Posted: 28 May 2003 at 9:20am

I get an error when trying to delete members from the forums. I can batch delete them, but I cant specificly go in and delete just one member.

Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'tblAuthor'.
/forum/delete_member.asp, line 124

This is the error message I get. Everything else is working fine, just copied it in and it worked. Any ideas as to what I need to do?

I read the http://forums.webwiz.net/forum_posts.asp?TID=2197&KW=delet - previous post on this...but unless doing a batch delete of members would take it out, it hasnt been touched. How would I add that ID 2 back into the guest account?  (I would do it now, but I am not at the server)




Replies:
Posted By: sundaytricky
Date Posted: 28 May 2003 at 1:49pm
hhhmmm, i had a similar error but it cleared up! try this; go in as the administrator, first delete the posts you can find from that member, then try again to delete the member, mine seems ok now (but i am still in my pre-launch stage) good luck


Posted By: WebWiz-Bruce
Date Posted: 29 May 2003 at 2:18am

It looks the error is becuase you have somehow deleted the guest account which should be at position 2 in the tblAuthor table of the database.

Without this account functions like this won't work in the forum.



-------------
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: triggerlock
Date Posted: 30 May 2003 at 10:11am

I did what you mentioned sundaytricky, and it did work, thankfully he only had one post.

-boRg- how do you go about adding this account back in? I dont remember deleteing the guest account, could/would it have been deleted when doing a batch delete on inactive members?



Posted By: WebWiz-Bruce
Date Posted: 30 May 2003 at 11:41am
Once the account is detleted it is almost impossible to get the account back.

-------------
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: triggerlock
Date Posted: 02 June 2003 at 9:53am

Alright, its not a huge forum, so I can manage doing it sundaytricky's way and the batch delete!

Thanks for the help -boRg-




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net