WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: Link Library] sql error when choosing "link order" plugin sorting (2 posts)

  1. gottaloveit
    Member
    Posted 4 years ago #

    link library: Version 1.2.5

    In link library config, breaks when results order is set to:
    <option value="order">Order set by 'My Link Order' WordPress Plugin</option>

    The SQL Error is:
    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 ASC' at line 1 for query SELECT t.*, tt.* FROM wppna_terms AS t INNER JOIN wppna_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('link_category') AND tt.count > 0 ORDER BY order ASC

    Problem is there is no column "order" in any of the 2 tables you reference. the correct column in the ORDER BY should be term_order

  2. Yannick Lefebvre
    Member
    Posted 4 years ago #

    Did you install the My Link Order plugin (which is not mine, but another plugin), before choosing this option?

    http://wordpress.org/extend/plugins/my-link-order/

    Please make sure that it is installed and configured before choosing this sorting order.

Topic Closed

This topic has been closed to new replies.

About this Topic