How could a member lose 4K+ followers?

[SJ77]

Member reached out because they lost a massive amount of followers.
Checked live site versus a backup

Looking on live production site.

Showing rows 0 - 24 (84 total, Query took 0.4368 seconds.)

SELECT * FROM `core_follow` WHERE `follow_app` LIKE '%core%' AND `follow_area` LIKE '%member%' AND `follow_rel_id` = 88151

Looking in backup.

Showing rows 0 - 24 (4370 total, Query took 0.0167 seconds.)

SELECT * FROM `core_follow` WHERE `follow_app` LIKE '%core%' AND `follow_area` LIKE '%member%' AND `follow_rel_id` = 88151

 

What could have possibly caused this?

Edited November 6, 2023 by SJ77

[SJ77]

Now I am worried that this could happen to more people as well. Not good.
Any ideas how to trouble shoot?

[DawPi]

Do you have any 3rd part of plugins/apps which "messing" with follow area on your board?

[SJ77]

Just now, DawPi said:

Do you have any 3rd part of plugins/apps which "messing" with follow area on your board?

I don't think so. The couple that I thought might have been related, I just confirmed with @Adriano Faria that they are unrelated.

[Adriano Faria]

Check with IPS if that setting applies to members too.

[SJ77]

[Adriano Faria]

Since you mentioned me here, I will reply as I replied on my board.

This is the only DELETE it has:

					try
					{
						$follow = \IPS\followspecificcontent\Follow::load( \IPS\Member::loggedIn()->member_id, 'cfe_member_id' );
						$follow->delete();
					}
					catch ( \UnderflowException $e )
					{
						parent::unfollow();
					}

The \IPS\followspecificcontent\Follow model is:

<?php

namespace IPS\followspecificcontent;

if( !\defined( '\IPS\SUITE_UNIQUE_KEY' ) )
{
	header( ( isset( $_SERVER['SERVER_PROTOCOL'] ) ? $_SERVER['SERVER_PROTOCOL'] : 'HTTP/1.0' ) . ' 403 Forbidden' );
	exit;
}

class _Follow extends \IPS\Patterns\ActiveRecord
{
    protected static $multitons;
    public static $databaseTable = 'followspecificcontent_data';

It doesn't delete records from core_follow and most importantly: the delete in my app happens when the member UNFOLLOWS the member.

Well, it would be very funny if a delete in my table could delete data from core_follow too.

As I truly believe it doesn't do that, it's not my app problem.

[SJ77]

Thank you for the follow up Adriano,
Honestly I assumed it wasn't your stuff.
This is just a really weird one. I have no idea how on earth this could have happened.
She had 4000+ followers in a yesterday backup.

Edited November 6, 2023 by SJ77

[Adriano Faria]

2 minutes ago, SJ77 said:

Honestly I assumed it wasn't your stuff.

No worries. I just wanted to leave it clear because you know how it works when there's a 3rd-party item in the game.

[Jim M]

What does the UI say for this member? While I understand you ran the same query here, we would need to go by what the software is pulling rather than a manual query.

If it is reporting the same for both. Have you recently pruned members? 

[SJ77]

8 minutes ago, Jim M said:

What does the UI say for this member? While I understand you ran the same query here, we would need to go by what the software is pulling rather than a manual query.

If it is reporting the same for both. Have you recently pruned members? 

UI is saying 85 (she got 1 more follower since I made this thread)



UI on backup has all 4000K followers.
I have not pruned any members. I never prune members.
Thank you

Edited November 6, 2023 by SJ77

[Jim M]

42 minutes ago, SJ77 said:

Has this always been configured as such? If not, this may explain what you're seeing.

I'd also reach out to any third party authors of applications/plugins you have installed that deal with members or followers as outside of the quoted screenshot, the system would not delete followers.

[SJ77]

2 minutes ago, Jim M said:

Has this always been configured as such? If not, this may explain what you're seeing.

I'd also reach out to any third party authors of applications/plugins you have installed that deal with members or followers as outside of the quoted screenshot, the system would not delete followers.

Yes it has always been set to never.

I will have to carefully look at third party plugins.
I don't have many that deal with members / followers.