Problem with blogroll after upgrading to WP2.1.1

  • argie01

    (@argie01)


    18 years ago

    Hi,

    after upgrading from WP209 to WP211 I got the typical error with the table wp_link2cat:

    WordPress database error: [Table ‘XXXX.wp_link2cat’ doesn’t exist] SELECT category_id FROM wp_link2cat WHERE link_id = 11 ORDER BY category_id

    So, I created the table using this code:

    CREATE TABLE wp_link2cat (
    rel_id bigint(20) NOT NULL auto_increment,
    link_id bigint(20) NOT NULL default ‘0’,
    category_id bigint(20) NOT NULL default ‘0’,
    PRIMARY KEY (rel_id),
    KEY link_id (link_id,category_id)
    ) TYPE=MyISAM AUTO_INCREMENT=9 ;

    After that, I assigned all the links in blogroll to one category (I get just 3 categories for the links, and instead for the posts I have 15 ones…I don’t know why).

    Anyway, now I’m getting this error:

    WordPress database error: [Unknown column ‘link_’ in ‘order clause’]
    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 WHERE 1=1 AND link_visible = ‘Y’ ORDER BY link_ ASC

    as you can see here: https://www.iccc.es (under “Enlaces”, you should select the text to see this error).

    Please, since I just have a little idea about sql, I appreciate any kind of help.

    Thank you.

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

  • Hi argie01,

    it looks like you fixed it! How did you do it?

    I’ve got this error after upgrading to WP 2.1.2 (I’m using theme connections:

    WordPress database error: [Unknown column ‘link_’ in ‘order clause’]
    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 = 1 ) ORDER BY link_ ASC

    ok, solved the issue by switching from 

    <ul>
<?php get_links('1', '<li>', '</li>', ' ', '', '', FALSE); ?>
</ul>

    to

    <div id="bookmarks">
      <?php wp_list_bookmarks('category_before=<span>&category_after=</span>'); ?>
    </div>
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Problem with blogroll after upgrading to WP2.1.1’ is closed to new replies.

Tags