If this is here, then my upgrade to the latest version of WordPress and a new theme won’t have been a complete disaster. If it isn’t here, then let’s keep it to ourselves, eh?
The newest thing is native support for tags, as well as categories. Everything is miscellaneous, of course (check this fantastic video of a presentation by David Weinberger on this theme (57 minutes) if you haven’t caught onto this idea yet), so tags ought to supply a folksonomy for posts on the site, as well as the taxonomy it’s always had. Windows Live Writer apparently supports this natively now through the Keywords field at the bottom of the editing window. Except it isn’t quite right, since I am the only person who can add or edit those tags. I wonder if there are any plug-ins out there yet that allow this to be carried to the next level — to let users add their own tags to articles in a way that sits inside the system rather than through widgets and third parties like del.icio.us?
On the theme: it’s back to Cutline again, for the time being, since it’s one of the few that supply native support for tags. Yes, it’s easy to hack existing themes to provide that, but I really can’t be bothered.
Things to do:
Haven’t quite finished with the masthead — there’s still a couple of generic pics in there and I think the title of the site needs to be a few points bigger.
Add tags to previous posts. I used to use the very popular plug-in Ultimate Tag Warrior. It used too much CPU ultimately whenever this site became moderately popular, and I had to drop it. Nonetheless, a lot of the posts on this blog have already been tagged. Some sort of import for that would be more than welcome.
Database may or may not be screwed. Oops. (Proper IT person: “Of course you backed up your database before performing such a drastic operation?”; Me: “Uh… yeah… sure I did.”). Updating old posts to add tags results in a MySQL error, though the edits are carried out nonetheless. Have to google it and see where I may have cocked things up.
This is what it looks like, for people in the know:
WordPress database error: [Table ‘twopoint_wrdp1.wp_post2cat’ doesn’t exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM `wp_posts` p LEFT JOIN `wp_post2cat` pc ON p.ID = pc.post_id LEFT JOIN `wp_categories` c ON pc.category_id = c.cat_ID WHERE post_status = 'publish' GROUP BY cat_ID
Share this post:
Your database is fine (: The wp_post2cat table vanished in wordpress 2.3.1. Probably you have a plugin which is no longer compatible. Probably the plugin grabs the most recent post from each category, looking at the SQL.
On the importing tags front; go to Manage > Import, and there’s an option to import tags from UTW and a bunch of other places.
the site is here, so success, right?
Thank you so much, Christine, for your advice. Isn’t the Internet wonderful? I’ll switch them all off this weekend, then switch them back one-by-one, as WP tell you to when performing an upgrade. Great tip on the tags import, too. I’d never have thought to look there.
The culprit seems to have been Spam Karma, which is unfortunate, since it’s handy to have around if Akismet is having one of its off days.
*later* ah — just needed its own database refreshed, it seems. everything fine now
Just went through the same on TechBrew.net.
Several of my plugins were using the UTW category tables, so that may take a bit of toggling to find out which one is complaining.
I also had a Google Sitemap plugin that generated the above error, so you might want to check for that as well.
- M
Woops, sorry for the belated and unnecessary advice.
Mark — it’s all welcome, I assure you. I’m still scrabbling with the sidebar.
Ian,
I can’t comment on the technical stuff but I really love the new look!
Andy
Did you get any responses about a plugin that lets readers add tags? I am interested in the same thing.
No, I didn’t. Wouldn’t that be cool, though.