colinjason

Where is your installation of wordpress installed to?

Ok, here’s a list of problems I’ve found thus far, all related to the same issue with the posts. It seems that when my database was upgraded, the ‘auto_increment’ value was dropped off SEVERAL fields. I’ve spent about the last hour, checking functionality to see where other problems appeared.

HOPEFULLY I’ve fixed all I need to, but this worries me about future upgrades to be sure. Anyway, here’s a list of what I had to fix in my database;

wp_posts: added ‘auto_increment’ to ‘ID’ field

wp_comments: added ‘auto_increment’ to ‘comment_ID’ field

wp_links: added ‘auto_increment’ to ‘link_id’ field

wp_users: added ‘auto_increment’ to ‘ID’ field

wp_usermeta: added ‘auto_increment’ to ‘umeta_id’ field

If anyone knows of any other tweaks needed, please let me know! I’m not sure what the wp_postmeta area is for, but there’s no information in that area in my database, so I’ve not made any adjustments there. The adjustments I made above was to get Categories, Posts, Comments, Blogroll, Users & their data working properly again after the upgrade.

This will teach me to fully backup my database next time!

I found ANOTHER area where the auto_increment setting is also causing problems; comments. I had a comment that I needed to delete, and when I tried to, WordPress threw an error. I looked at the link when hovering over the ‘edit’ link, and lo and behold, it’s ID was also set to 0.

I’m definitely thinking that the upgrade.php script has issues!!

I’m going to check over the other fields, and see if this is a trend.

My ID field was set as primary, but in the ‘extras’ area, auto_increment was not set. Once I set that, things started working as they should. ??

Hopefully this will help others!

Now, the question is, was this a fault of the upgrade.php script?

That fixed it! Thanks MichealH!

I’m looking over my attributes for the wp_posts field, and the ID area doesn’t say ‘auto_increment’ anywhere on it. I’m going to try changing that, and see what happens.

Well! I’m glad I’m not the only one having this issue! I just decided to give up on it for a while, and see if someone in the community knew something. I upgraded without realizing how new the upgrade was. LOL

Lesson learned.

Thankfully, if I have to do a fresh install to get my site working again, it won’t be a total wash, since I only had a few posts in it before the upgrade attempt. Still though, it’s frustrating when you go over all the steps VERY carefully, and weirdness like this occurs.