Skip to content
No results
  • The journey to better code
  • Articles
  • Tools
  • Projects
  • About
  • Contact
    • Thank you for your message
draghici.net
  • All articles
  • About
  • Contact
draghici.net

WordPress – db_term_taxonomy reset count

  • Cristi DraghiciCristi Draghici
  • October 27, 2014
  • Programming / Development

Reset the term count:

UPDATE wp_term_taxonomy tt SET count = (SELECT count(p.ID) FROM  wp_term_relationships tr LEFT JOIN wp_posts p ON (p.ID = tr.object_id AND p.post_type = 'post' AND p.post_status = 'publish') WHERE tr.term_taxonomy_id = tt.term_taxonomy_id) WHERE tt.taxonomy = 'tag';
# mysql# php# Wordpress
Previous Post dvdbox.tk
Next Post Starfish PHP Framework – Version 0.1

Categories

  • Everything else
  • Programming / Development
  • News and fun facts
  • Useful tools
  • My projects

Tags

Android Apache application Bootstrap css digitalocean docker docker-compose git Github hidden hosting html javascript jenkins jest jquery json laravel leaflet.js Linux macOS mysql node.js npm nvm online openlayers parser php postgres raspberry pi react redux SlimPHP ssh Starfish typescript Ubuntu Virtualmin Vue.js webmin website Windows Wordpress

A quick note

I post here articles that I found interesting, solutions to problems I have encountered and last but not least, display information about my projects and achievements.

Around the web

draghici.net © 2006 - 2023  - Most of the rights reserved