Forums

[resolved] 2.6 missing categories wp_terms table error (7 posts)

  1. Anonymous
    Unregistered
    Posted 1 year ago #

    I upgraded from some 2.1 version (I think...not sure) to 2.6. Everything works fine except for that the category descriptions are blank. In the wp_categories table, they're listed correctly, but not in the wp_terms table.

    Whatever version of WP I had before didn't use the wp_terms table, so I copied the info from the wp_categories table and tried to paste it into the wp_terms table. I get this error message each time.

    I'm entering the following sql code. Any idea what's wrong with the code?

    --
    -- Data contents of table wp_terms
    --

    INSERT INTO wp_terms VALUES (1, 'Uncategorized', 'uncategorized', '', 0, 5, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (2, 'Cool Blogs', 'cool-blogs', '', 0, 0, 5, 0, 0) ;
    INSERT INTO wp_terms VALUES (3, 'Inspiring', 'inspiring', '', 0, 34, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (4, 'Via Email', 'via-email', '', 0, 1, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (5, 'Health', 'health', '', 0, 12, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (6, 'Give time/money', 'give-timemoney', '', 0, 6, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (7, 'Read this', 'read-this', '', 0, 5, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (8, 'Pay attention', 'pay-attention', '', 0, 58, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (9, 'Moment of Truth', 'moment-of-truth', '', 0, 69, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (10, 'Watch this', 'watch-this', '', 0, 28, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (11, 'Research', 'research', '', 0, 1, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (12, 'Random', 'random', '', 0, 13, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (13, 'Thoughts', 'thoughts', '', 0, 27, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (14, 'Plain cool', 'plain-cool', '', 0, 22, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (15, 'Website', 'website', '', 0, 11, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (16, 'Do your reseach!', 'do-your-reseach', '', 0, 26, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (17, 'Learn something', 'learn-something', '', 0, 9, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (18, 'Rewritable words', 'quotations-rewriteable-words', '', 0, 14, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (19, 'What My World Sounds Like', 'what-my-world-sounds-like', '', 0, 14, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (20, 'Listen', 'listen', '', 0, 13, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (21, 'Spotlight', 'spotlight', '', 0, 11, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (22, 'Consider this', 'consider-this', '', 0, 32, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (23, 'Great ideas', 'great-ideas', '', 0, 3, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (24, 'The Visual', 'the-visual', '', 0, 3, 0, 0, 0) ;
    INSERT INTO wp_terms VALUES (25, 'Challenge', 'challenge', '', 0, 1, 0, 0, 0) ;
    --
    --End of data contents of table 'wp_terms'

  2. Otto42
    Moderator
    Posted 1 year ago #

    The terms table is not an exact replica of the older categories table and you can't just change names like that willy nilly.

    Just put your descriptions in again if they got lost.

  3. Anonymous
    Unregistered
    Posted 1 year ago #

    Where do I put the descriptions in?

  4. Anonymous
    Unregistered
    Posted 1 year ago #

    I emptied the wp_terms table so the list of categories isn't there anymore. Is there anyway to reload the table? Or downgrade and try upgrading again?

  5. Anonymous
    Unregistered
    Posted 1 year ago #

    I had the same error, solved it yesterday night :)

    My experience with it: http://blog.cumps.be/wordpress-26-upgrade-categories-missing/

    You'll have to edit 1 table and then fiddle a bit in the admin section to get your links working again :)

  6. Anonymous
    Unregistered
    Posted 1 year ago #

    Apparently there are more people having problems, made a post to give something back to the community, detailing what I did to fix it with screenshots :)

    http://blog.cumps.be/wordpress-26-upgrade-fix-missing-categories/

    Good luck fixing it elleepiphany2

  7. Anonymous
    Unregistered
    Posted 1 year ago #

    It worked! I'm elated. Thank you.

Topic Closed

This topic has been closed to new replies.

About this Topic