I’m getting a very similar error:
“
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 ‘ORDER BY cat_name ASC’ at line 1]
SELECT cat_id, cat_name FROM ORDER BY cat_name ASC
Being, well, not technically inclined, it’s been a major headache. Any help on this would be appreciated.
The call for links or blogrolls have changed in 2.1. Maybe try calling it with what is in the default template in WordPress 2.1:
<?php wp_list_bookmarks(); ?>
Trent
Like Trent said, use the standard template functions and you should be fine. Any custom link queries that were written before 2.1 will break and error out because the linkcategories table no longer exists.
thanks Trent and froman. got it fixed.
i tried to replace the old code with what trent wrote but: i still get
————————-
WordPress database error: [Unknown column ‘link_count’ in ‘where clause’]
SELECT * FROM wp_1categories WHERE cat_ID > 0 AND link_count > 0 ORDER BY cat_name ASC
#
————————-
where the blogroll should be.
and in the blogroll management i get
——————————
[long code moderated]
————————————–
but adding links and deleting and all works. i re-installed 2.1 3 times now, never had a problem with the installation. can anyone help me on this?
the domain by the way is “whataboutpj.com” – so thats whats in the code.
I am having the same problem. I installed 2.1 on a newly created blog.
Following Trent and froman118 advice, and still no luck.
I have the same errors. Links are only displaying with template tag get_links.
Hope this helps.
get_links doesn’t work for me. what works though is wp_get_linksbyname but i don’t want to use that since links won’t fit to my page layout then.
Something in this thread might lead you on the right path? Good luck!
spencerp
In my case all my blogrolls were copied to categories (but empty) after upgrading from 2.0.7 to 2.1
Anyone noticed this?
RavanH, got the same prob as you. Now I have those blogroll categories in two places. 🙁
When I click on the “categories” that were added after the 2.1 update (in left sidebar), I get a 404 page. You can see my example of this at http://memorylaneproducts.com
Lace
Any idea how to fix this, then?
function yy_widget_links($args) {
global $wpdb;
$title = empty($options['title']) ? __('Links') : $options['title'];
$link_cats = $wpdb->get_results("SELECT cat_id, cat_name FROM $wpdb->linkcategories");
?>
<h2><?php echo $before_widget.$before_title.$title.$after_title; ; ?></h2>
<ul>
<?php
foreach ($link_cats as $link_cat) {
?>
<li id="linkcat-<?php echo $link_cat->cat_id; ?>"><?php echo $link_cat->cat_name; ?>
<ul>
<?php wp_get_links($link_cat->cat_id); ?>
</ul>
</li>
<?php } ?>
</ul>
<?php
}
RavanH,
I fixed my site with the info found in this article. The article tells you how to exclude categories and other things. After I fixed the category prob, the My Category Order plugin I had works just fine!
Here is the info link I used to change the code in my sidebar: http://codex.wordpress.org/Template_Tags/wp_list_categories (scroll to see “Categories with Excludes”)
Lace
I have the same problem for Link:
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
I am getting the following:
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
Any help would be greatly appreciated since I am new at this!
