I think you'd have to write a php script (or I guess another language if you want) to compare the custom avatar file name with the avatarrevision in the database for each user, and do a correction if necessary. I don't think any of the updates in the admincp do that for you.
eta: Maybe if someone was good at linux commands they could write something to get the userid and revision number off each custom avatar in the file system and create a comma-separated file with the data, then you could import that into the database to a temporary table and use SQL to fix the user table avatarrevision column. Then you wouldn't really need to write a script. Yeah, maybe 'find' into a file and awk to change it to csv format., I think that would work.
Could it be anything like being out of space on the disk where the avatars are stored? Or did you do anything like restore files or the database? I guess you could just fix it somehow and wait to see if it happens again. Maybe it was a temporary problem.
|