Batch Delete Members isn't working
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=28480
Printed Date: 02 April 2026 at 12:34am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Batch Delete Members isn't working
Posted By: Omniwel
Subject: Batch Delete Members isn't working
Date Posted: 05 April 2010 at 6:42pm
|
I am running the 9.67 MySQL version. When I try to Batch Delete Members older than 1 year with no posts it just returns "0 Members have been Deleted." This regardless of whether I choose All member accounts or Un-activated member accounts. And I do have quite a number of member accounts that are 2 and 3 years old with no posts, so lack of candidates is not the reason. What to do? |
Replies:
Posted By: SnowBlind
Date Posted: 05 April 2010 at 10:23pm
|
Did you migrate from Access to mySQL?
I have and experince this on 9.66. I've not found a solution.
|
Posted By: Omniwel
Date Posted: 06 April 2010 at 7:18pm
|
Yes, actually I did migrate from Access to MySQL. I installed the 9.66 MySQL version and then imported the data from Access into the MySQL database using Navicat. Apart from a few extremely long posts that got lost it worked like a charm. I did have various small problems with the 9.66 version, including this one, but since I have upgraded to 9.67 they have all disappeared - except for this one (afaik). So until I saw your reply here I actually thought the migration had been without any problems. |
Posted By: WebWiz-Bruce
Date Posted: 07 April 2010 at 8:40am
|
Moving from Access to mySQL is not support as the mySQL version uses a very different schema so you often end up with an unstable database. We also see issues with mySQL database corruptions when you get above 400MB database. You should look instead at upsizing the database to SQL Server as the schemas are very simular and SQL Server can also handle millions of posts. ------------- 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: SnowBlind
Date Posted: 07 April 2010 at 8:51pm
| Omniwel; You may notice that the Posts count doesn't increase with users. You will also notice that the number of posts do not correctly reflect the actual posts of your users. All the users with 0 posts may actually have several posts. What I've been doing is going through all the users and searching for their posts and updating their account with the real post count. It is tedious work so far. I've also removed a lot of older topics that had been migrated over from the Access database. After removing the topics I did notice that the users Post count was being modified properly. I haven't had any new users lately to see if their post counts are properly increasing yet. Bruce; Are you saying that the Access to mySQL migrations start to corrupt after 400 megabytes within the mySQL database. Or, just a fresh install is corrupting? That is a bit discouraging to hear, though I doubt mine will ever get that big. |
Posted By: WebWiz-Bruce
Date Posted: 08 April 2010 at 9:11am
|
Both
------------- 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: Omniwel
Date Posted: 08 April 2010 at 7:47pm
Thanks a lot SnowBlind, but actually the number of posts seem to increase as it should. With new users as well as migrated users. I have just tested it and everything seems perfectly okay in that respect. Also the batch delete returns 0 deleted users. Had the cause been an inaccurate post count then the actual number of users without any posts might have been lower than shown but I doubt it would ever be 0. During the years at least one person is bound to have signed up without ever posting. So I doubt this is the cause in my case. But thanks anyway! 
It sure does sound like tedious work - almost regardless of the number of users  And as I have understood you, fixing the count issue hasn't solved the problem with batch delete? |
SnowBlind wrote:Posted By: SnowBlind
Date Posted: 08 April 2010 at 8:08pm
|
So far, no it has not solved the problem with the batch delete of the users. I still get 0 deleted. |