Too many categories

  • psimatrix

    (@psimatrix)


    16 years, 1 month ago

    We have over 15,000 categories after importing XML files with posts that had categories. We want to convert these categories to tags, however, due to the number of categories the categories to tags script fails to load and displays a blank page. The problem also seems to cause the Write Post page to fail in the admin.

    Is there an SQL statement that can substitute for the Categories to Tags script?

    What is the normal maximum number of Categories allowed before the admin begins to fail?

Viewing 1 replies (of 1 total)
  • vtxyzzy

    (@vtxyzzy)

    16 years, 1 month ago

    This is UNTESTED AND A BEST GUESS. This query should change ALL categories to tags (BACK UP YOUR DATABASE FIRST!!).

    UPDATE wp_term_taxonomy
SET taxonomy = 'post_tag'
WHERE taxonomy = 'category'
Viewing 1 replies (of 1 total)

The topic ‘Too many categories’ is closed to new replies.