View Full Version : how do i delete galleries of deleted vb members?
October 27th, 2007, 04:20 PM
how do i delete galleries of deleted vb members?
out of the thousand galleries i have, there are about 100 galleries with photos, with no matching usernames... username field is blank... how do i delete these galleries?
October 27th, 2007, 06:30 PM
Are there userids assigned to these pictures because if so view the photopost profile of these galleries and there should be a delete all photos of this user link in the profile.
October 28th, 2007, 08:06 PM
i click on Members Galleries and get sent here
then Sort by Alphabetical Order
then i have about a hundred galleries with no attached profiles or usernames
i assume they were left behind from deleted profiles.
how do i remove these?
October 29th, 2007, 09:56 AM
HMM really there is nothing you can do if there is not a userid attached to the photos. You could delete them one by one but to delete them all at once you would need to actually do some database editing to a degree. Like create a dummy test user in vbulletin and then do some mass sql query to your photos table assigning all photos with no userid to this new user. You can then use as I noted in the members profile the link to delete all photos by this user.
I can assist you with the backend query stuff if you have a database viewer/editor like phpmyadmin.
October 29th, 2007, 02:28 PM
i don't mind deleting them one by one...
i spent 12 hours yesterday sifting through 26,000 and deleting about 1,000...
the only problem is, there is no link to member profiles or member galleries, because there is no member...
so yes, i loaded phpadmin and would love your help in getting rid of these please...
how do we do this?
October 29th, 2007, 02:50 PM
well for one I dont know your server control panel. So you know my email just email me that link and sign in then I can go in and tweak those photos to some userid and make me an admin and we can get those images gone.
October 29th, 2007, 02:53 PM
i just sent you the email and made you admin.
October 29th, 2007, 03:03 PM
927 orphaned images where deleted.
October 29th, 2007, 03:04 PM
October 29th, 2007, 03:09 PM
Have a good one.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.