Web/Online/WordPress Help
I spent some time this evening updating the link structure for the blog and testing some tweaks to the site. Being a former IT guy, I used a testing environment for, well, testing things out before implementing them here.
In the process of refreshing the database in the testing environment, I had to deal with an issue that WordPress has: the site’s base URL is stored in the database, and each post has an absolute URL stored in the database too.
I noticed recently that one of my WordPress sites had started skipping post numbers. It used to just go in order… 1, 2, 3 onward as expected. Suddenly post numbers were incrementing several at a time, seemingly randomly. What’s up with that?
I started looking around and found the database had multiple entries per post. A little more digging and I realized that WordPress 2.6 had added versioning (is “revisioning” a word?). Each time a draft was saved, WordPress would save it as a new entry with the post_type set to “revision” (versus “post” for the final version) and the database would increment the id by one.