Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Yesterday at 02:04 PM
SJ77 Posted November 6, 2023 Posted November 6, 2023 (edited) 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 Posted November 6, 2023 Author Posted November 6, 2023 Now I am worried that this could happen to more people as well. Not good. Any ideas how to trouble shoot?
DawPi Posted November 6, 2023 Posted November 6, 2023 Do you have any 3rd part of plugins/apps which "messing" with follow area on your board?
SJ77 Posted November 6, 2023 Author Posted November 6, 2023 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 Posted November 6, 2023 Posted November 6, 2023 Check with IPS if that setting applies to members too.
Adriano Faria Posted November 6, 2023 Posted November 6, 2023 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 1
SJ77 Posted November 6, 2023 Author Posted November 6, 2023 (edited) 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 1
Adriano Faria Posted November 6, 2023 Posted November 6, 2023 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. SJ77 1
Jim M Posted November 6, 2023 Posted November 6, 2023 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 1
SJ77 Posted November 6, 2023 Author Posted November 6, 2023 (edited) 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 Posted November 6, 2023 Posted November 6, 2023 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 1
SJ77 Posted November 6, 2023 Author Posted November 6, 2023 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.
Recommended Posts