Web Wiz Forums - Error - Remove member

Print Page | Close Window

Error - Remove member

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=11768
Printed Date: 09 April 2026 at 1:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error - Remove member

Posted By: jola
Subject: Error - Remove member
Date Posted: 12 September 2004 at 4:41am

Hi,
I got some problems when I should delete a member in my forum, I use version 7.01

The error:

Microsoft JET Database Engine error '80004005'
You cannot add or change a record because a related record is required in table 'tblAuthor'.
/forum/delete_member.asp, line 124

Line 124: (120-128 )

'Set all the users posts to the Guest account
  strSQL = "UPDATE " & strDbTable & "Thread SET Author_ID=2 WHERE (Author_ID =" & lngMemberID & ")"

  'Write to database
  adoCon.Execute(strSQL)   <---- Line 124


  'Delete the user from the email notify table
  strSQL = "DELETE FROM " & strDbTable & "EmailNotify WHERE (Author_ID =" & lngMemberID & ")"

Anyone that know my problems here ?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 13 September 2004 at 10:54am

This bug was addressed some time ago.

To sort this out upgrade to the latest version.

You should do this anyway or your forum will not be secure!!

-------------
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