Fixes for Wordpress 2.1 Ella
Some of the themes are experiencing some errors in the codes after upgrading to wordpress 2.1 . The reason is wordpress has changed few codes like integrated links into category table. Unfortunately for some reason I will not be able to update all theme files on GFXedit.com for few days. So for the time being, those who have the errors please correct it by changing this line …
Open the file where your links apear (most probably sidebar.php) and replace
$link_cats = $wpdb->get_results(”SELECT cat_id, cat_name FROM $wpdb->linkcategories”);
with
$link_cats = $wpdb->get_results(”SELECT cat_id, cat_name FROM $wpdb->categories WHERE link_count!=’0′”);
Then replace
<?php wp_get_links($link_cat->cat_id); ?>
with
<?php get_links($link_cat->cat_id, ‘<li>’, ‘</li>’, ‘<br />’, FALSE, ‘id’, FALSE, TRUE, -1, TRUE); ?>
RSS 2.0
February 6th, 2007 at 9:46 am
Hi,
I am using DarkPad and this doesn’t to fix it for me.
Am I missing something?
Thanks,
-Steve
February 6th, 2007 at 10:09 am
Does it show the same error ? If so, Are you sure that you replaced and saved the file ?
February 6th, 2007 at 11:30 am
Thanks for getting back to me.
I think so.
I first tried it in Wordpress theme editor, then I tried it in Dreamweaver and I got the same result. When I tried the new code, the right column disapeared altogether. I had to go back and re-enter the old code.
-Steve
February 7th, 2007 at 8:01 pm
Try this fix now.
February 8th, 2007 at 9:20 am
I’m using Darkpad as well, and I’m getting the same error as Steve. I tried the fix above, and the error remains. Not sure if I’m putting it in the correct place in sidebar.php. Here is the text of the error that appears in place of my links:
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]
SELECT cat_id, cat_name FROM
Thanks,
MB
February 9th, 2007 at 3:42 am
Okay, managed to get it working in DarkPad. Here’s what I had to do:
in style.css add:
.linkcat {
list-style-type:none;
}
In sidebar.php replace links code with:
February 9th, 2007 at 3:43 am
Sorry, it choked on the php tags.
sidebar.php gets:
?php wp_list_bookmarks(); ?
but all that surrounded by angle brackets.
February 10th, 2007 at 3:39 am
That fix doesn’t work either.
Using
works, albeit with improper formatting (unnecessary bullets at each category header, headers are in the wrong font).
February 10th, 2007 at 3:18 pm
I don’t seem to be getting this. Uhm, can you elaborate on which line we have to replace? Thanks.
February 11th, 2007 at 3:05 am
I’m using Internet Broadcast and the sidebar got problem so how to fix it back to normal the themes… u can check with my website http://iboxed.com
Please help me to fix it thank you!
February 12th, 2007 at 1:00 am
Thanks for your fix - I just upgraded last night and was having some trouble with this.
I found another method, and I was on my way to solving it this way:
&title_after='); ?>
I was almost going to stick with that, as it seems a little cleaner method for displaying links, however there is a pesky little List Item dot prefixing the title that I couldn’t get rid of.
Either method is fine.
February 12th, 2007 at 9:29 am
Thank you for the quick fix. I was worried I would have to switch back to the default theme but this worked like a charm for me.
Thanks again for a great theme.
February 15th, 2007 at 8:09 am
I am also having trouble with links on the ‘Buryy’ theme. I tried the above methods but with no success. Upon editing the sidebar.php, my theme would no longer load at all. Any ideas what I’m doing wrong?
Huge thanks in advance for the help and keep up the good work!
February 15th, 2007 at 9:39 am
Please download the theme again and replace the sidebar.php
February 15th, 2007 at 9:23 pm
Thanks Sreejith, that fixed my problems.
Cheers!
February 19th, 2007 at 7:30 am
I redownloaded the DarkPad theme and it shows all of the sidebar as it’s supposed to, but now the descriptions are printed alongside the link. How can I remove them?
March 2nd, 2007 at 7:58 am
Does not appear to be working for the internet marketing theme. Any info is appreciated. :(
March 2nd, 2007 at 8:08 am
Ok, replaced the links code with the code from the ‘fixed’ theme you suggested to download again. ;)
March 4th, 2007 at 1:25 am
Hi, Sreejith,
I love your DaVinci code theme. For an author of Historical fiction, it’s perfect.
I have all the fixes in place on the sidebar as you suggested. But with a recent upgrade to WordPress 2.1.1, the layout broke. I cannot figure out how to fix. Have gone into every file I can access to edit. and even from my file manager, and on my Dreamweaver on my Mac.
Cannot seem to fix it, and it stays the same even when I switch to the Taft Theme.
I am in the process of redesigning my site: www.reneodeay.com , but the Wordpress is not public yet.
Now they have a new Urgent upgrade to WordPress 2.1.2 but my Fantastico doesn’t offer it yet. just the 2.1.1, after which I started having problems with the layout.
Any ideas?
thanks,
René
March 4th, 2007 at 1:37 am
Uh, sorry. Thought my DaVinci Code wordpress site would show up:
My DaVinci
At the top, a bar of the regular background shows up. Can’t fix it.
As above.
March 6th, 2007 at 2:43 pm
Dont know if this helps, but I had a similar problem and fixed it quickly with this
REPLACE
$link_cats = $wpdb->get_results(”SELECT cat_id, cat_name FROM $wpdb->linkcategories”);
WITH
$link_cats = $wpdb->get_results(”SELECT cat_id, cat_name FROM $wpdb->categories”);
March 11th, 2007 at 7:01 pm
Rene again, Sreejith,
I finally got the new wordpress 2.1.2 upgrade to my site, that is still not public, cuz it’s still broken.
I downloaded Davinci again, deleted it on the site and reloaded the new download.
I don’t know why, I was playing with some new plugins and suddenly the middle background image appears at top of the site, where it does not belong. When I change themes this does not happen.
I did a screen shot and can send you that in an email, downsized for sending.
Renee
March 19th, 2007 at 11:52 pm
sure you can send me the theme screenshot and theme files at me[dot]sreejith[at]gmail.com . I will surely look into it .
April 4th, 2007 at 2:05 am
[…] and MySQL database in MAMP. I found that the template I use needed a quick update (as detailed on GFXedit) but otherwise the upgrade script seems to have done the job without any trouble. Please let me […]
April 10th, 2007 at 9:42 pm
Is there a way to keep the link descriptions from showing up on my blog? In the older versions showed up only when moused-over. In this version they show up under the link name. This takes up more space visually than I want it to. Thanks for any help you can supply!
May 16th, 2007 at 8:55 am
Shonnie,
In sidebar.php, instead of
use
May 21st, 2007 at 9:26 pm
Thanks Sreejith! That’s what I needed.
July 18th, 2007 at 2:43 am
Do you have any ideas how I can fix this error:
WordPress database error: [Unknown column ‘link_count’ in ‘where clause’] SELECT cat_id, cat_name FROM wp_categories WHERE link_count!=’0′
Everything shows up fine except for my blogroll and other links. Thanks for any help you can provide!
July 25th, 2007 at 11:01 am
Which version of Wordpress are you using. Because in latest version 2.2.1 link_count table is there in wp_categories column.
If you are using the latest version, then reinstall wp.
July 28th, 2007 at 9:24 pm
Sorry to bug you, but I spent mucho time on the Wordpress support forum last night trying to fix my blogroll.
Okay, this is totally flipping me out. I’ve tried fixing the Blogroll code using:
to replace
but to no avail.
I’ve got the exact same code (for sidebar links) shown here and while the fix seems to work for some people, I still get this crud:
check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1]
SELECT cat_id, cat_name FROM
What in the heck am I doing wrong?
I also tried the above fix from your original post. I’m using the lightCMS theme, but the code seems identical.
help?
July 28th, 2007 at 9:29 pm
Oops. Forgot to remove the . Sorry for the above garble.
I used ?php wp_list_bookmarks(); ? to replace ?php get_links_list(); ? in my sidebar.php code, but it didn’t work.
I’ve tried every possible configuration (given my limited understanding of code). My link code is the same as http://wordpress.pastebin.ca/330828
August 5th, 2007 at 5:49 pm
Jesse, could you please use the contact form and mail me the problem.