Web Wiz Support and Community Forums : Batch delete members https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 07:41:22 +0000 Thu, 03 Aug 2006 20:53:17 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20880 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Batch delete members : Sorry -boRg- It appears I got...]]> https://forums.webwiz.net/batch-delete-members_topic20880_post112046.html#112046 Author: donstar
Subject: 20880
Posted: 03 August 2006 at 8:53pm

Sorry -boRg-
 
It appears I got the above error message because I misspelled the new code!
 
The modification works fine on the Access version.
 
Still no joy on the mySQL version though.


Edited by donstar - 03 August 2006 at 9:12pm]]> Thu, 03 Aug 2006 20:53:17 +0000 https://forums.webwiz.net/batch-delete-members_topic20880_post112046.html#112046 <![CDATA[Batch delete members : Yes the file is admin_batch_delete_members.aspIf...]]> https://forums.webwiz.net/batch-delete-members_topic20880_post112023.html#112023 Author: WebWiz-Bruce
Subject: 20880
Posted: 03 August 2006 at 11:27am

Yes the file is admin_batch_delete_members.asp

If the example I gave does not work then it may mean recoding the page and a quick fix is not possible. Sorry.
]]> Thu, 03 Aug 2006 11:27:00 +0000 https://forums.webwiz.net/batch-delete-members_topic20880_post112023.html#112023 <![CDATA[Batch delete members : I assume you mean the file admin_batch_delete_members.asp...]]> https://forums.webwiz.net/batch-delete-members_topic20880_post111983.html#111983 Author: donstar
Subject: 20880
Posted: 02 August 2006 at 11:11pm

I assume you mean the file admin_batch_delete_members.asp as I don't have a file called batch_delete_members.asp.
 
I've tried changing line 77 as you suggested and it's not deleting any members? Will this work with both Access and mySQL version? I'm trying to delete members in mySQL version.
 
I know I can delete them directly from the DB, but I'd like to set up the admin page so that I can delete old inactive members on a regular basis.
 
Edited to add that I've just tried this on Access Version and I'm getting the following error
 
Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forum/admin_batch_delete_members.asp, line 92



Edited by donstar - 02 August 2006 at 11:59pm]]> Wed, 02 Aug 2006 23:11:24 +0000 https://forums.webwiz.net/batch-delete-members_topic20880_post111983.html#111983 <![CDATA[Batch delete members : To change it from the join date...]]> https://forums.webwiz.net/batch-delete-members_topic20880_post111943.html#111943 Author: WebWiz-Bruce
Subject: 20880
Posted: 02 August 2006 at 9:50am

To change it from the join date to last active date open the file batch_delete_members.asp and on line 77 change:-

Author.Join_date

To:-

Author.Last_visit

This will then delete non-posting members based on the time they where last active rather than by when they joined.


Edited by -boRg- - 02 August 2006 at 9:51am]]> Wed, 02 Aug 2006 09:50:49 +0000 https://forums.webwiz.net/batch-delete-members_topic20880_post111943.html#111943 <![CDATA[Batch delete members : I know that in the Admin area...]]> https://forums.webwiz.net/batch-delete-members_topic20880_post111910.html#111910 Author: donstar
Subject: 20880
Posted: 01 August 2006 at 9:32pm

I know that in the Admin area it's possible to Delete Members that have never posted that registered over so many days, weeks, months, years ago, which is great, but I have a fair few members that registered over 2 years ago and have never posted but who visit the Forum regularly. I don't want to delete them because I have the Forum set so that all topics are hidden to non members.
 
What I'd like to be able to do is Delete Members that have never posted and/or were LAST ACTIVE more than one or two years ago because these are the ones that are just taking up space in my DB.
 
Can the Batch Delete Members page be modified to allow me to do this?
]]> Tue, 01 Aug 2006 21:32:58 +0000 https://forums.webwiz.net/batch-delete-members_topic20880_post111910.html#111910