Php Newbie needs help with blogroll after update to 2.1

  • lindse

    (@lindse)


    17 years, 3 months ago

    Okay, this is my first newbie and I am not that good with php – so I hope you can help. I have read a lot of posts and docs ,but I can´t figure it out.

    My template (tiga) has this code http://lindse.dk/links.txt and I get this 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 ” at line 1]
    SELECT cat_ID, cat_name FRO

    I really hope you can help! My blog is at http://lindse.dk if you need it to figure out what is wrong.
    Thanks //Karen

Viewing 6 replies - 1 through 6 (of 6 total)
  • dokushiroi

    (@dokushiroi)

    17 years, 3 months ago

    I’m having the same problem. Mine says:

    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 hope someone posts how to fix this!

    dokushiroi

    (@dokushiroi)

    17 years, 3 months ago

    how do you fix this?????

    froman118

    (@froman118)

    17 years, 3 months ago

    You can check if the theme has been upgraded, if not try the following:

    replace

    $link_cats = $wpdb->get_results(“SELECT cat_id, cat_name FROM $wpdb->linkcategories”);

    with

    $link_cats = $wpdb->get_results(“SELECT * FROM $wpdb->categories where link_count > 0”);

    slakethirst

    (@slakethirst)

    17 years, 3 months ago

    Say, that half-way worked. Now it’s definitely getting category names. However, the code I have to display links (by category) is wp_get_links($link_cat->cat_id); ? and it’s returning emptiness. Do you know what would have changed there?

    froman118

    (@froman118)

    17 years, 3 months ago

    Arg lame, I tried some similar code and found out what is wrong. In that whole block of code, replace “cat_id” with “cat_ID”, I forget about php being case sensitive.

    slakethirst

    (@slakethirst)

    17 years, 3 months ago

    Hmm. But wp_get_links now seems to be displaying descriptions — which I don’t want — and the codex doesn’t indicate that wp_get_links accepts an argument about that one way or the other. 🙁 Gadzooks.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Php Newbie needs help with blogroll after update to 2.1’ is closed to new replies.