• anybody knows how to resolve this problem after upgrading to 2.1? Thanks.

    “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”

Viewing 15 replies - 16 through 30 (of 42 total)
  • Which solutions did you try from the posts above?

    Im not exactly sure where to put any of the code solutions above. The first part of code from my sidebar is:

    [mod – long code removed]

    Don’t post long code here, nobody can read it.

    Use https://wordpress.pastebin.ca and post back with the URI. Somebody might be able to help

    Got it to work using <?php wp_list_bookmarks(); ?>, https://www.joynerlibraryblog.com/ but it just places the link in two places now.

    I’d like to add that the category ID’s have all changed too. I had some code that wold use get_links() and the ID number for the categories are different in 2.1 vs. 2.07

    Mike

    Alright, this is a problem I have as well. I’ve posted my stuff to the pastebin– you can see it here. I don’t know what there to replace with the <?php wp_list_bookmarks(); ?> code, though– any help would be greatly appreciated.

    Thanks!

    I’m really confused here. Previously I had a set of links down the sidebar grouped into categories. How do I get this to display this way again?

    Some of my links went to internal pages, and others when to external sites. It seems that the categories for the links have been merged.

    The stuff above seems to be talking about showing categories as well. I just want to show my blogrolls. Is there a way to do this now?

    Im having the same problems as buntingw and gigas.

    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

    What does this mean? How can I SPECIFICALLY fix it?
    Ive read through this thread and nothing has fixed it yet

    Read these pages if you haven’t already found them.
    Template Changes – https://lorelle.wordpress.com/2007/01/26/wordpress-21-template-tag-and-function-changes/

    codex for list categories – https://codex.www.ads-software.com/Template_Tags/wp_list_categories (mentioned in post above) and

    codex for bookmarks – https://codex.www.ads-software.com/Template_Tags/wp_list_bookmarks

    Southwest, if you’re still looking – Try replacing <?php get_links_list(); ?> with <?php wp_list_bookmarks('category='); ?>

    Here is what I have done on talkjunkie.com to separate and call the categories and the link(bookmark) categories: On the left sidebar I’m using – <?php wp_list_categories('orderby=name& hide_empty=0&exclude=34,29,36,31,33,30,37,32,35& hierarchical=1& title_li=0'); ?></ul>

    On the right sidebar I use – <?php wp_list_bookmarks('category=33,34,37,35'); ?>
    <?php wp_list_bookmarks('category=30,31,32,36'); ?>

    If anyone comes across a good explanation of why the category merge is an improvement, I’d love to read it.

    davenj, I agree, I would love to see ’em turning back to wp_list_links. I just don’t see the merits.

    Word of experience one has to locate id of the links (category now) in order to fix your theme.

    Now here is what I am trying to do to my sidebar on https://www.themarque.org

    https://wordpress.pastebin.ca/333814

    It isnt working.
    I found that it works if I add

    <?php wp_list_bookmarks(‘category=’); ?>

    after <?php } ?>

    But it still leaves the “Links” box with the error. So if I try to completely delete the link box, etc the sidebar disappears into an error all together.
    How do I get my links (blogroll) to show back up under “Links”, or at least have “Blogroll” substiture for it?

    I’m getting this.

    WordPress database error: [Unknown column ‘cat_1’ in ‘order clause’]
    SELECT * FROM wp_categories WHERE cat_ID > 0 AND link_count > 0 ORDER BY cat_1 ASC

    Links set up in the dashboard, zilch on the site. Does anyone have a quick cut and paste patch idea to try (with noobish explainer on how/

    Thanks!

    Hehe, I know this sounds repetitive. But I still need a noobish way to do this. Can someone just say exactly what to do?

    My information is two posts up.

    Folks,

    I had the same problem and simply replaced the original code with <?php wp_list_bookmarks(); ?> and it all worked fine.

    c0y0te
    https://www.avalon5.com
    “Howl @ The Moon!”

    Marque,
    try this: https://wordpress.pastebin.ca/338534
    Hopefully, it will show your links… but only when on the home page. If you want them all the time – remove the conditional from around the code.

Viewing 15 replies - 16 through 30 (of 42 total)
  • The topic ‘2.1 Blogroll Problem’ is closed to new replies.