WordPress.org

Support

Support » How-To and Troubleshooting » [Resolved] Missing categories and post author after upgrade to 2.3

[Resolved] Missing categories and post author after upgrade to 2.3

Viewing 7 replies - 1 through 7 (of 7 total)
  • Hello,

    I’ve got the exact same issue : most of my posts appear as “uncategorized”. I started a thread yesterday and logged a support ticket.

    No matter how much memory is increased, the upgrade process to 2.3.x does not complete properly.

    Yeah, another guy told me it was a memory issue. I have my own server with 1G RAM and not much running on it. I rebooted it before I did the upgrade, it didn’t help.

    Here’s my problem…

    When I upgraded from 2.0.11 to 2.3, the database upgrade didn’t complete. So I have 2.3 code with an old database and things are messed up.

    How do I run the database upgrade again?

    Ahh, okay, I found a variable in the “options” table called “db_version” which is set to: 6124

    I switched it to 6123 and attempted upgrade again, it said the db was out of date so I ran the upgrade. It was successful, but didn’t help.

    So I fixed the missing authors problem – The db upgrade added a new column in the ‘users’ table called ‘display_name’. This was left blank for my users.

    Just go into the control panel, edit each user, and select their display_name from the drop down menu.

    About my categories disappearing – It appears that WP handles categories differently in the database. There’s now these 3 “terms” tables.

    When I upgraded to v2.3 it seems to have created these tables but didn’t convert the old “categories” tables to them. So looks like I’ll have to try and do that manually.

    How many posts have you got ? This is going to take forever :-/

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘[Resolved] Missing categories and post author after upgrade to 2.3’ is closed to new replies.
Skip to toolbar