taxonomy problem

  • SSJB_7

    (@ssjb_7)


    10 years, 10 months ago

    when i go to preview i get on left side this:
    WordPress database error: [Column ‘term_order’ in order clause is ambiguous]
    SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘collection’) AND tr.object_id IN (972) ORDER BY term_order ASC

    and below the post:
    WordPress database error: [Column ‘term_order’ in order clause is ambiguous]
    SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘collection’) AND tr.object_id IN (972) ORDER BY term_order ASC

    https://ww.wp.xz.cn/plugins/wpmovielibrary/

Viewing 1 replies (of 1 total)
  • Charlie Merland

    (@askelon)

    10 years, 10 months ago

    Hi SSJB_7,

    Sorry about that. Can’t reproduce this on my test installs, but I can see where it’s coming from; I’ll run some tests.

    Meanwhile, can you try editing the plugin’s includes/classes/class-wpmoly-utils.php on line 1308 and replace $orderby = "ORDER BY term_order"; by $orderby = "ORDER BY tr.term_order";?

Viewing 1 replies (of 1 total)

The topic ‘taxonomy problem’ is closed to new replies.