Blogroll and category issues with 2.1 upgrade – my solution

It makes sense in an abstract way but it is a little too complicated for me. Is the problem with the links and link categories not displaying properly because of bugs in 2.1? Will an update be out soon that corrects these problems?

I am really wishing I had just stuck with 2.0.4 as I had no problems with it and I don’t have the expertise to understand what is going on. If I had known there would be problems like this I would never have upgraded.

I may give your suggestions a go, though – if there is no other option.

How do I delete wp_link2cat.frm file in MySQL? In phpmyadmin?

My benefit is I have my own server, so I just browsed the MySQL data directory and looked for the file. I have no idea how one can delete this file if you have a web host.

I do agree with you that I wish I had not upgraded, but upgrading is a necessary evil when it comes to securing a blog. I figured on just upgrading it now and dealing with the issues as the 2.1.x updates should be painless.

I should make it clear that I did not try the above steps without deleting the wp_link2cat.frm file. I decided on deleting it since it was the file that caused me grief.

Also, the links do show in the side bar even with the php get_links_list() function in place – some have mentioned a change to this.

I don’t even have any links within Blogroll, and I still have the same issue on 2 web sites… error message in the sidebar panel:

https://www.yvondurelle.com

?WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1]
00 SELECT cat_id, 01 cat_name FROM?.

Evidently, when I remove the Sidebar Widgets plugin, it resolves. My sidebar widget plugin 1.0.20060711, and all other plugin, has been updated to the latest version.

I too have a problem with the link page. I wish there was a fix without having to delete all links, I have a few, and without having to mess with deleting files in the database and then reloading them, and then running the upgrade again, what a mess!!!!!

There has to be an easier fix, I am starting to regret the upgrade.

Here’s what I did:

I chose a theme that works (both the WP default theme and the classic theme, I chose the classic), opened the theme editor and chose the sidebar file from it. From the code I highlighted the code for the blogroll:

<?php wp_list_bookmarks('title_after=&title_before='); ?>

(hope the code shows here right)

Then I copy-pasted the code into the sidebar.php of my own blog theme to replace the old blogroll code, and uploaded it into the server. And everything works just fine!

Erm… worked with one blog with only one link group, not the other with three link categories. Or yes, it worked, but then css didn’t work at the blogroll titles anymore.

eija, you saved my neck!!! Thank you soooo much. It worked. My link categories are not quite in the right order, but I don’t have a php blurb instead of links! And all my links and categories are there.
Thanks for your clear explanations