Web Wiz Support and Community Forums : Error - Remove member https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 01:02:00 +0000 Mon, 13 Sep 2004 10:54:37 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=11768 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Error - Remove member : This bug was addressed some time...]]> https://forums.webwiz.net/error-remove-member_topic11768_post65277.html#65277 Author: WebWiz-Bruce
Subject: 11768
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!!
]]> Mon, 13 Sep 2004 10:54:37 +0000 https://forums.webwiz.net/error-remove-member_topic11768_post65277.html#65277 <![CDATA[Error - Remove member : Hi,I got some problems when I...]]> https://forums.webwiz.net/error-remove-member_topic11768_post65208.html#65208 Author: jola
Subject: 11768
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 ?

]]> Sun, 12 Sep 2004 04:41:28 +0000 https://forums.webwiz.net/error-remove-member_topic11768_post65208.html#65208