Member with 5,487 empty albums!

[imthebest]

While debugging some things on my XFMG installation today I found that I have a member with 5,487 empty albums, all with the same title "I'M WATCHING YOU @.@"

All albums seem to have a creation date of Aug 2009. These albums were imported from vBulletin 3.x however I can't confirm right now if the source data had in fact those 5,487 identical empty albums for the member or if it was a migration error (I didn't got any error message during the migration, everything went perfectly fine using the XF standard importer and then the XMG standard importer). I guess I'll need to restore my old vBulletin backup in order to further investigate this problem.

The member is banned so he isn't being listed at the Notable Members list under the Most Albums tab.

Could you please provide me a query to list the top 10 members with the highest albums count regardless if they are banned or not? This will help me to find any other similar occurrence to further investigate.

Thanks,
Super120

 

[Chris D]

When you imported did you retain content IDs or not?

 

[imthebest]

Yes, I retained content IDs.

 

[Chris D]

Definitely not a migration error then.

Query is

SELECT * FROM xf_user ORDER BY xengallery_album_count DESC LIMIT 10

 

[imthebest]

Thanks for the query, it seems that he's the only guy with that problem. Maybe the problem was present in vBulletin.

How I can fix this? I'd like to remove all the albums from that member. Could this be safely done through a SQL query or it needs to be done via the UI (which will be a pain considering the huge amount of albums)?

 

[imthebest]

How I can fix this? I'd like to remove all the albums from that member. Could this be safely done through a SQL query or it needs to be done via the UI (which will be a pain considering the huge amount of albums)?

Chris when you get some time please give me a hand with this one. Thanks!

 

[Chris D]

DELETE FROM xengallery_album WHERE album_user_id = 9999 AND album_media_count = 0

Change 9999 to the user ID of the user.

Back up first!

 

[imthebest]

Do I need to run any rebuilder after this or just wait for the next run of the "Update XenForo Media Gallery Statistics" cronjob?

 

[Chris D]

Should be fine now.

That guy's album count is a lot higher now than it should be.

That's fixed by:

UPDATE xf_user
SET xengallery_album_count = 0
WHERE user_id = 9999

Change 9999 to the user ID of the user.

Back up first!