With WordPress 2.1 released only a mere 16 days ago, I thought it would be a nice time to upgrade and see what new features there are. Luckily the transition from 2.05 to 2.1 was smooth, but the results weren’t what I was expecting. As you may notice on my sidebar I am now missing my blogroll and other links. Surely at first I thought something happened during the upgrade, but that wasn’t the case. Having a dig around within the source code of my theme and checking out the database, I realise that the theme I am using does not accomodate well with the new changes.
What has happened in WordPress 2.1 is the merging of the links category and posts category and making them into one table. But the source code for the links was relying on the links category table, and due to that that is why you currently see that SQL error message. Below is the actual code to display my links (do note the spaces for the tags):
< ?php /* Get links with link-categories */
$link_cats = $wpdb->get_results(”SELECT cat_id, cat_name FROM $wpdb->linkcategories”);
foreach ($link_cats as $link_cat) {
? >
< li id="linkcat-< ?php echo $link_cat->cat_id; ? >”>< h3>< ?php echo $link_cat->cat_name; ? >< /h3>
< ul class="linklist">
< ?php wp_get_links($link_cat->cat_id); ? >
< /ul>
< /li>
< ?php } ? >
At this point I have posted the creator of this theme, Tim from freshlabs, and hope that he can fix this as I do quite like this theme a lot. Though if not then I may decide to change themes. I could at this point try to fix this myself as I do understand how this code works, but it’s more of a rearranging the code to suit the database. Honestly I could do a really crappy hack but I would not be guaranteed that it would not affect future categories being added. So in the meantime, I’ll be leaving it as it is and hope nothing else has gone wrong.
What has also been brought to light recently is the amount of spam comment posts I am getting. A few days ago I was getting an average of nearly 30 spam comments an hour. So far I have turned commenting and pingback off on that post but I rather find a better option, such as a captcha. So if anyone has any suggestions on a plugin or a hack that I could use that would be greatly appreciated.
Having spent an hour seeing what was new with WordPress 2.1 there are a few things I like and dislike. The main part I like is the rearrangement of the posts, comments, blogroll management system. However the Writing Post section is by far the only thing I dislike. Obviously it’s missing the HTML Editor button and the lack of being able to enlarge the text box that i am currently writing in. other than that I don’t find anything particularly different as a lot of the upgrade is the backbone of WordPress.
hmm.. if it cant do edit html in plain text then I wont upgrade my blog to 2.1…; and I dont see anything new here as well
Sorry to hear about your upgrade woes. I’d seen that someone else had had a problem so I was waiting a while before I myself made the plunge.
As for the comment spam, I have turned to Spam Karma 2, and that has greatly reduced the headache. Not only do I not have to fret about the spam, but it seems the amount of spam comments had decreased.
Good luck!
Which is why I didn’t even bother upgrading, since the “upgrades” are so little that they aren’t worth the hassle, and, in your example, even messed up with your sidebar. Well, good luck, hope you find a solution soon
With the spam problem, like wrex, I’d suggest you to get Spam Karma 2. It works like a charm, until now no spam comment has passed yet.
~neko
Change the variables to refer to the name of the new table.
That should solve problems.
Trying to upgrade totally fucked my blog up, so i reverted back to my old version. Im probably gonna try to update it again soon, but geeze, it really wasnt worth it. Its pretty pointless anyway, you dont get shit but problems out of it.
wrex: Thanks for that, I think I’ll try it out.
DrmChsr0: I tried that before and the way the code works, it displays every single category, not just the ones I want.
I would upgrade were it not for the hassle…actually, I wouldn’t anyway, unless there was an urgent security threat from not upgrading.
If there’s no urgent need, you might as well wait until your theme and favorite plugins get updated or noted as stable. I waited until my theme and “essential” plug-in was deemed stable and it wasn’t a problem at all. The only hassle for me was I decided I’d mess around a bit (I need to remind myself to not do that again, but I’m not listening to myself). The wp-admin side of it is faster now and the ability to tab between the visual editor and code views on the fly when writing posts is nice.
It does look like they’re starting to build up the CMS side of WP with 2.1, which probably doesn’t matter for a typical blog, but does open the door for making WP more than just a blogging platform.