The MU forums have moved to

Problems between wp_sitecategories and wp_X_categories (5 posts)

  1. iolaire
    Posted 16 years ago #

    I've got nine sites set up on Worpdress MU. I'm really just using it as a content management system for nine sites.

    Now when I add a category I'm getting errors like:
    WordPress database error: [Duplicate entry '62' for key 1]
    UPDATE wp_9_categories SET cat_ID = '62' WHERE cat_id = '3841'

    62 Electronic Keyboards 0 0 EditDelete ]]>Electronic Keyboards added]]>

    What I see is that wp_sitecategories has the category id of 62, where the wp_9_categories has the category id as 3841. I'm thinking that this is caused by my use of bulk-category-manager.

    I'm guessing that I need to have the same number of categories in wp_sitecategories as there is across all nine blogs?

    Any suggestions on how to fix this?

  2. drmike
    Posted 16 years ago #

    Um, bulk-category-manager?

  3. iolaire
    Posted 16 years ago #

    This one:
    Useful for uploading getting lots of categories added. I'm now moving to an xmlrpc method, but am finding the above mentioned errors.

    It might not be the cause, but I'm thinking that could be the cause.

    Is it accurate to assume that wp_sitecategories ids should correspond to wp_x_categories entries?

  4. iolaire
    Posted 16 years ago #

    Here is how I think I can fix this. Export each blog using the WordPress export function - that will get me all categories and posts. Delete all posts and categories from all blogs and wp_sitecategories. Import back each blog's content. Does this route sound effective?

  5. iolaire
    Posted 16 years ago #

    So I exported all of my posts using the WordPress export function and re-imported, that fixed the category problems from using bulk-category-manager on MU.

    One item of note, is it seems like the import would only parse xml files of about 6-8 megs, after that it would stop parsing and appear done with out a total number of posts imported. I don't know if this is unique to my host or not.

About this Topic