Problem with Batch Delete 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=26498
Printed Date: 03 April 2026 at 3:33am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Problem with Batch Delete Members
Posted By: negrisoli
Subject: Problem with Batch Delete Members
Date Posted: 08 November 2008 at 8:27pm
|
Hi Guys,
A long time ago, I posted one topic about this problem, and I continue with this problem in my Forum yet.
Well, I don´t know ASP and SQL very well, then I would like to have a help.
The problem is:
I don´t get to remove my "Un-activated member accounts" when I choise "NOW" in "Delete Members that have never posted that registered over" and I select "Un-activated member accounts" in Control Panel/Forum Tools.
The message error is:
Microsoft OLE DB Provider for SQL Server error '80004005'
The cursor does not include the table being modified or the table is not updatable through the cursor.
/fnew/admin_batch_delete_members.asp, line 174
Well, I think that the Code is ok, then I think the problem will be in the my SQL Server Configuration.
My SQL Server is: MS-SQL 2005 Standard
Collation: SQL_Latin1_General_CP850_CI_AI
See image below with the properties/options database:
 Please, anyone can help me ? Thank you !
|
Replies:
Posted By: Putz22
Date Posted: 09 November 2008 at 12:22am
| Why not use the Batch Delete button in the Admin Section of the Forums? there you can choose back to how long you want to delete someone... if you make the user inactive you can do a Batch Delete in there.. you can delete members back from two years ago... just a thought... |
Posted By: WebWiz-Bruce
Date Posted: 09 November 2008 at 9:12am
|
I doubt it is an issue with the way your database is setup. However the file admin_batch_delete_members.asp has been re-written for the next release so will hopefully fix this issue for you.
------------- 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: negrisoli
Date Posted: 09 November 2008 at 5:50pm
Hi Putz22, this is the feature that I'm having problem !
Thank you Bruce, I'm waiting for your new release !
Att.
|
Putz22 wrote: