Simon
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: delete 100,000 images from media libraryFor anyone else reading this – be aware that depending on plugins used, you will have at least one, maybe 4 or more records on the wp_postmeta table. It is wise to delete these two, as if you don’t they end up being orphaned in the database, and taking up space / slowing things down.
So, first:
DELETE FROM wp_postmeta
WHERE post_id IN
(
SELECT id
FROM wp_posts
WHERE post_type = ‘attachment’
)
;Then once executed,
DELETE FROM wp_posts WHERE post_type = ‘attachment’
I just deleted 8,400 images, after deleting 25,000+ rows in wp_postmeta – if you don’t do this and your site is or will possibly be big in the future, you may run into performance issues…
Thanks
SiSame here – was looking forward to getting this functionality on my site – but major fail forcing a sign up to use it.
I can understand the desire to do this, but at the very least, make sure it works!!
Maybe it would be better to ask for a tweet/Plus one/FB Like within the plugin settings welcome page, to reveal top tips or something like that.
(no charge for that idea 🙂 )Hi Fab1en, Joost
I too would love this feature – specifically for custom taxonomies too. I have just had a nasty experience when one of my team tried to code noindex into a theme header for a product tag (custom-tax) it went wrong, wasn’t tested properly, now site had lost 99% of search traffic 🙁 Problem is fixed and hoping a recovery won#t take too long. Having this an option in the indexation section would be awesome – I’d buy you a Beer!
OK, in fact I just checked and seen you have v 1.2.3 out. Installed and changing ‘tabs’ to taxonomies does nothing… clicking any tab just changes the URL (..site/wp-admin/admin.php?page=wpseo_titles#top#taxonomies) but content of screen doesn’t change… (still WP 3.3.2) does it require WP 3.4.1?
Questions questions..!
Thanks much
Thanks for an awesome plugin though Joost.
Maybe if poss, mention whitespace in functions.php in the error message? Could you even put a small function in that then attempts to remove possible offending white space?!
Cheers
SiThis took me ages to fix, but think its working now on this site:
Thanks Jon – you are bang on with the cause – bit of custom taxonomy work resulted in white space at the bottom of functions file. Disabling plugins made no difference, try cleaning up you functions.php file first folks!