Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - error on deleting members
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

error on deleting members

 Post Reply Post Reply
Author
triggerlock View Drop Down
Newbie
Newbie


Joined: 07 May 2003
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote triggerlock Quote  Post ReplyReply Direct Link To This Post Topic: error on deleting members
    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 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)



Edited by triggerlock
Back to Top
sundaytricky View Drop Down
Newbie
Newbie


Joined: 26 May 2003
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote sundaytricky Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.

Back to Top
triggerlock View Drop Down
Newbie
Newbie


Joined: 07 May 2003
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote triggerlock Quote  Post ReplyReply Direct Link To This Post 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?

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 30 May 2003 at 11:41am
Once the account is detleted it is almost impossible to get the account back.
Back to Top
triggerlock View Drop Down
Newbie
Newbie


Joined: 07 May 2003
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote triggerlock Quote  Post ReplyReply Direct Link To This Post 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-

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.