Blogroll, ‘WordPress database error’

  • filiusdextrae

    (@filiusdextrae)


    17 years ago

    I thought I had everything working fine on my new WordPress blog, but then all of a sudden my Blogroll disappeared, and in its place is a bunch of SQL code. I’m not sure what to do, or what’s causing the error (could it be my database?), so please advise me if you can help. The following is the text that appears beneath the title ‘Blogroll’:

    WordPress database error: [Column: ‘link_id’ in where clause is ambiguous]
    SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated , UNIX_TIMESTAMP(link_updated) AS link_updated_f FROM wp_links LEFT JOIN wp_link2cat ON (wp_links.link_id = wp_link2cat.link_id) WHERE 1=1 AND link_visible = ‘Y’ AND ( category_id = 2 ) AND ( link_id <> 0 AND link_id <> 0 ) ORDER BY link_name ASC

    Thanks in advance! I’ve had no trouble besides this and am really liking WordPress.

    -Benjamin

Viewing 2 replies - 1 through 2 (of 2 total)
  • alexo05

    (@alexo05)

    16 years, 5 months ago

    Hey there

    I’ve actually found that whenever using the “exclude” parameter with wp_list_bookmarks, this error string will show up. I don’t know if any other parameter will cause the same behavior, but it seems odd.

    I haven’t found a solution.

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    16 years, 5 months ago

    The “category” parameter is not compatible with either the “include” or “exclude” parameters.

    Use one or the other. Not both. Using both doesn’t really make a lot of sense anyway.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Blogroll, ‘WordPress database error’’ is closed to new replies.