Conversation
supportNextGen gallery is bloating my wp_options table with transients. Hopefully only since version 2.0, but I had over 170,000 transient rows in the options table. Using the Delete All Transients, I’ve managed to reduce it to 52,000 which should let me do a backup before manually deleting the rest. http://wordpress.org/plugins/delete-expired-transients/
G’day apurdam, I see that the latest version of NextGEN Gallery (2.0.27) has incorporated its own process for deleting old transients, so you might not need this plugin after you upgrade. Check it out and let me know please 🙂 cheers, Ross
Well, they’ve been trying. I did have that version and still had 170,000 transients, so I’d say they hadn’t succeeded. Interestingly, I still had 52,000 after using your plugin, but that was sufficient to let me do a backup before manually deleting the rest using SQL (once I felt confident with what I was doing).
Right, so much for that then! Ah well, maybe by version 2.1 eh? You can manually delete all transients with this plugin, from the Tools menu. See the screenshot: http://wordpress.org/plugins/delete-expired-transients/screenshots/ cheers, Ross
I doubt Photocrati will get their act together. I’ve gone back to v 1.9 for stability. Wasted a LOT of time today. re: Deleting all transients, that’s what I did, and it still left 52,000! Maybe they weren’t transients?? Don’t know what they were, then. “But I sprayed them and they all died.” 🙂
Do you still have the SQL you used? I’d like to see what it was you deleted, maybe I can add that to the plugin 🙂 I’ve kept all my clients on 1.9.13 of NextGEN Gallery for now. The 2.0 series doesn’t let you specify a gallery template when you use an album shortcode, which makes 2.0 unusable on the sites I’ve built (using NextGEN Download Gallery). cheers, Ross
Sorry no exact SQL remembered, but the method is given below: I was using my ISP’s phpsql thingy, which lets you look under the hood of your database. This would let you browse, select and delete entries, showing the SQL for each command before executing it. Quite tedious for 52,000 rows, even at 1000 per command, which is why I decided “ look, every row above this id number seems to be gallery related, so why not just change the criteria to ‘>nnn’ rather than ‘=nnn’? ” So that’s what I did. And I hope I didn’t inadvertently delete anything I missed seeing! I doubt that would be a safe attitude to take into your plugin! 🙂
Right, that does sound likely to wipe good data! I’ll have to have a peek at one of my test sites that has NGG2 installed on it and see what it’s filling wp_options with. cheers, Ross
G’day apurdam, I see that the latest version of NextGEN Gallery (2.0.27) has incorporated its own process for deleting old transients, so you might not need this plugin after you upgrade. Check it out and let me know please 🙂 cheers, Ross
Well, they’ve been trying. I did have that version and still had 170,000 transients, so I’d say they hadn’t succeeded. Interestingly, I still had 52,000 after using your plugin, but that was sufficient to let me do a backup before manually deleting the rest using SQL (once I felt confident with what I was doing).
Right, so much for that then! Ah well, maybe by version 2.1 eh? You can manually delete all transients with this plugin, from the Tools menu. See the screenshot: http://wordpress.org/plugins/delete-expired-transients/screenshots/ cheers, Ross
I doubt Photocrati will get their act together. I’ve gone back to v 1.9 for stability. Wasted a LOT of time today. re: Deleting all transients, that’s what I did, and it still left 52,000! Maybe they weren’t transients?? Don’t know what they were, then. “But I sprayed them and they all died.” 🙂
Do you still have the SQL you used? I’d like to see what it was you deleted, maybe I can add that to the plugin 🙂 I’ve kept all my clients on 1.9.13 of NextGEN Gallery for now. The 2.0 series doesn’t let you specify a gallery template when you use an album shortcode, which makes 2.0 unusable on the sites I’ve built (using NextGEN Download Gallery). cheers, Ross
Sorry no exact SQL remembered, but the method is given below: I was using my ISP’s phpsql thingy, which lets you look under the hood of your database. This would let you browse, select and delete entries, showing the SQL for each command before executing it. Quite tedious for 52,000 rows, even at 1000 per command, which is why I decided “ look, every row above this id number seems to be gallery related, so why not just change the criteria to ‘>nnn’ rather than ‘=nnn’? ” So that’s what I did. And I hope I didn’t inadvertently delete anything I missed seeing! I doubt that would be a safe attitude to take into your plugin! 🙂
Right, that does sound likely to wipe good data! I’ll have to have a peek at one of my test sites that has NGG2 installed on it and see what it’s filling wp_options with. cheers, Ross