Web Wiz Forums - Problems with Batch Delete Members

Print Page | Close Window

Problems with Batch Delete Members - WWF 9.7

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=25124
Printed Date: 04 April 2026 at 5:19am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Problems with Batch Delete Members - WWF 9.7

Posted By: negrisoli
Subject: Problems with Batch Delete Members - WWF 9.7
Date Posted: 09 January 2008 at 7:02pm

Hi Dear,

I´m with a little problem in my WWF.

When I enter in "Batch Delete Members" in Menu Control Panel , and I choise to remove "Un-activated member accounts" and select "NOW", I received this error mensage below:

------------------------------------------------------------------------------

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.

/forum/admin_batch_delete_members.asp, line 174

------------------------------------------------------------------------------

Well , someone know how to resolve this problem ?

Att.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 09 January 2008 at 10:03pm

Often errors are coursed by corrupted files, so the first thing you should do is reupload the original files again.

If that doesn't solve the issue please post some more details such as the database you are using.

-------------
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 January 2008 at 10:35pm

Hi boRg,

I already made a reupload the file and didn't have success.

I'm using DB SQL 2005 Standard on my provider.

Thank you for your return !

Posted By: WebWiz-Bruce
Date Posted: 10 January 2008 at 10:41am

Have tried to replicate this error in the lab and been through the code and can not see why you would get this error.

The file itself has not changed in around 3 years, so it's very strange why you get are getting this error.

-------------
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: 10 January 2008 at 11:30am

Hi boRg,

Realy , I found very very strange this error , because I never had problem with this file !

This script use or call some procedure in DB SQL ?

Maybe , the problem can be in DB !

Att.

Posted By: WebWiz-Bruce
Date Posted: 10 January 2008 at 11:42am

It just uses standard SQL read and delete queries, pluas an ADO delete. Nothing unusual or special and never seen this error before, which suggest maybe a configuration option on the database server.

The part which is throwing the error at line 174 is a delete through ADO.

-------------
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: 10 January 2008 at 12:23pm

Well , I will see all tables that have relation with table "tblAuthor".

Because I delete manually directly in DB SQL all unactive members and maybe were some users or posts of users in others tables , and can be cansing this error or not ?

The tables that have relation with table "tblAuthor" are:

tblThread

tblGroup

tblEmailNotify

tblBuddyList

tblPMMessage

???

Posted By: WebWiz-Bruce
Date Posted: 10 January 2008 at 12:36pm

You should never delete data directly in the database as it can course issues. However, with the SQL Server version because the database is relation most of the time it will not allow data to be deleted which is related to data in another table. But this is not the case all the time.

-------------
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: 10 January 2008 at 12:50pm

It´s really !

Well , I will try to find in this tables if there are datas without author. If there are , I´ll remove them.

Do you know commands SQL or how to do this direct in DB ?