XF 2.2 How to remove non-existent avatars?

[USCSS_Nostromo]

After restoring the forum following a crash, some avatar files are missing in the file system (they don't exist).
How can I remove records about this from the database?

 

[Paul B]

How many accounts are affected?

You could edit them in the ACP and remove the avatar record.

 

[USCSS_Nostromo]

How many accounts are affected?

I can't say for sure how many. Possibly around a thousand.
I found a plugin that does this. But it's for Xenforo 1.0.Is it difficult to adapt it for Xenforo 2.0?

Avatar Data Check

Description: Corrects situation where avatar images are missing from file system. A missing avatar image missing from the file system will result in a blank avatar to be shown. This add-on fixes this problem. (Example of Avatar Data Check...

xenforo.com

 

[Starbucks]

I can't say for sure how many. Possibly around a thousand.
I found a plugin that does this. But it's for Xenforo 1.0.Is it difficult to adapt it for Xenforo 2.0?

Avatar Data Check

Description: Corrects situation where avatar images are missing from file system. A missing avatar image missing from the file system will result in a blank avatar to be shown. This add-on fixes this problem. (Example of Avatar Data Check...

xenforo.com

@AndyB

 

[USCSS_Nostromo]

@AndyB

I fixed

UPDATE xf_user SET avatar_date = 0, avatar_width = 0, avatar_height = 0, avatar_highdpi = 0 WHERE avatar_date BETWEEN 1664745443 AND 1693948643;


XF, thank You for avatar_date