| Author |
 Topic Search  Topic Options
|
negrisoli 
Groupie
Joined: 13 April 2006
Location: Brazil
Status: Offline
Points: 79
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Problems with Batch Delete Members - WWF 9.7
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.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
negrisoli
Groupie
Joined: 13 April 2006
Location: Brazil
Status: Offline
Points: 79
|
Post Options
Thanks(0)
Quote Reply
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 !
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
negrisoli
Groupie
Joined: 13 April 2006
Location: Brazil
Status: Offline
Points: 79
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
negrisoli
Groupie
Joined: 13 April 2006
Location: Brazil
Status: Offline
Points: 79
|
Post Options
Thanks(0)
Quote Reply
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
???
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
