Solution: WordPress Categories and Tags missing bug

by Rooturaj on June 9, 2010

Recently I faced this situation on my personal blog. I just posted a new article and I was shocked to find all the categories and tags gone. All my posts were there but the categories and tags and even links were all gone. Actually they did exist in the wordpress database but were not being associated with the posts.

As a result my blog home page, that calls post in different category blocks was blank. I was facing the dark prospect of re creating all posts and loosing backlinks as my permalink settings involve categories as well. But then …to my luck I found a solution to the issue.

We just need to get back the category-post-tags relation so this smart bit of SQL code does it for us. You need to go to your database manager software (phpmyadmin or whatever you use) go to the SQL query section and execute this code.

UPDATE wp_term_taxonomy,wp_terms SET wp_term_taxonomy.description = wp_terms.name WHERE wp_term_taxonomy.term_id = wp_terms.term_id

If this does not help you or your categories are all actually gone then you might try contacting your host and ask them if they have a backup of the databases. This would only work if you have a backup generated or if your host did an autoback for your before the problem of missing categories and tags cropped up.

About Rooturaj:
  • Deborah

    Thank you so much for the fix! Between a migration to a new server and an update, I'd lost my categories and tags. I did have to use the table names created by updates, i.e.,  wp_32_term_taxonomy and wp_32_terms

  • Mark

    You, my man, are a hero.

  • Wordpress is best for blog i also use word press.

  • Hansuey

    hi sir!

    Where shall I use this?
    i tried it on the database of that wordpress site 
    localhost>wp1> then SQL
    then i get this:

    import.php: Missing parameter: import_typeimport.php: Missing parameter: format

    however, when i tried it not just on the wordpress site, but
    on the localhost>then SQL
    then i get this:

    You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

    please shed light on this:

    my website is the 
    How to quit your job with a millionaire mind

  • ravdibarbosa

    I don’t mean those crappy profile links or what they call Angella Paul links. Lnks are a different thing. 
    One day one deal
    best pizza franchise

  • #1030 - Got error 28 from storage engine

    I got the above error. Any idea?

    Thanks

blog comments powered by Disqus