Bulk deletion of albums
|
jdalexa
Joined: 2009-07-30
Posts: 4 |
Posted: Thu, 2009-07-30 21:19
|
|
Yes, I was stupid with not keeping track of perms on albums. Moving on. A user created an album and it wound up with "Everybody" having perms to create sub-albums and comments with the predictable results for spam. I have a VERY large number of albums with lots of sub albums. Is there a reasonable way to delete these? One album has over 30K sub-items. Time-out is a huge problem. Thanks in advance
|
|
Posts: 16503
Nope, have fun with that.
You'll need to do it in chunks. That's why in the latest version (2.3) you can select multiple photos to delete, but not multiple albums. Delete operations are expensive and consume quite a few resources. This would explain the timeout problems you are seeing.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 4
I was afraid of that. There is one album that has over 100K sub-items. I may have to just blow away the site and start over. this isn't gonna be worth it. Pennence for not paying attention to perms I suppose.
Posts: 16503
You might be able to use a script to access Gallery through it's API and do this without going through the interface, but I think you'll still end up with the same issue of timeouts, I think.
This is an example of how to add files automatically through a cron job, but if you're a programmer of any sort you might be able to hack together something for deleting:
http://gallery.menalto.com/node/81010#comment-284733
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 4
The problem I have is that I need to remove albums that typically have a large number of sub albums. Guess I can dig into the code and figure out the delete functions and run them from the command line. Gahh.. lesson learned - and a hard one at that.
Posts: 4
Can anyone help me out here with the tables I need to hit to clear out a bunch of sub-albums and sub-items?