Web Wiz Support and Community Forums : Problems with Batch Delete Members - WWF 9.7 https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 04 Apr 2026 03:48:43 +0000 Thu, 10 Jan 2008 12:50:10 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=25124 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Problems with Batch Delete Members - WWF 9.7 : It´s really ! Well , I will...]]> https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130635.html#130635 Author: negrisoli
Subject: 25124
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 ?
]]> Thu, 10 Jan 2008 12:50:10 +0000 https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130635.html#130635 <![CDATA[Problems with Batch Delete Members - WWF 9.7 : You should never delete data directly...]]> https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130634.html#130634 Author: WebWiz-Bruce
Subject: 25124
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. ]]> Thu, 10 Jan 2008 12:36:51 +0000 https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130634.html#130634 <![CDATA[Problems with Batch Delete Members - WWF 9.7 : Well , I will see all tables that...]]> https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130633.html#130633 Author: negrisoli
Subject: 25124
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
 
???
]]> Thu, 10 Jan 2008 12:23:26 +0000 https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130633.html#130633 <![CDATA[Problems with Batch Delete Members - WWF 9.7 : It just uses standard SQL read...]]> https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130629.html#130629 Author: WebWiz-Bruce
Subject: 25124
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.
]]> Thu, 10 Jan 2008 11:42:03 +0000 https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130629.html#130629 <![CDATA[Problems with Batch Delete Members - WWF 9.7 : Hi boRg, Realy , I found very...]]> https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130628.html#130628 Author: negrisoli
Subject: 25124
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.
]]> Thu, 10 Jan 2008 11:30:44 +0000 https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130628.html#130628 <![CDATA[Problems with Batch Delete Members - WWF 9.7 : Have tried to replicate this error...]]> https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130625.html#130625 Author: WebWiz-Bruce
Subject: 25124
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.
]]> Thu, 10 Jan 2008 10:41:06 +0000 https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130625.html#130625 <![CDATA[Problems with Batch Delete Members - WWF 9.7 : Hi boRg, I already made a reuploadthe...]]> https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130621.html#130621 Author: negrisoli
Subject: 25124
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 !
]]> Wed, 09 Jan 2008 22:35:50 +0000 https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130621.html#130621 <![CDATA[Problems with Batch Delete Members - WWF 9.7 : Often errors are coursed by corrupted...]]> https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130618.html#130618 Author: WebWiz-Bruce
Subject: 25124
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.
]]> Wed, 09 Jan 2008 22:03:25 +0000 https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130618.html#130618 <![CDATA[Problems with Batch Delete Members - WWF 9.7 : Hi Dear, I´m with a little...]]> https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130614.html#130614 Author: negrisoli
Subject: 25124
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.
]]> Wed, 09 Jan 2008 19:02:49 +0000 https://forums.webwiz.net/problems-with-batch-delete-members-wwf-9-7_topic25124_post130614.html#130614