Title: taxonomy problem
Last modified: August 30, 2016

---

# taxonomy problem

 *  [SSJB_7](https://wordpress.org/support/users/ssjb_7/)
 * (@ssjb_7)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/taxonomy-problem-4/)
 * 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://wordpress.org/plugins/wpmovielibrary/](https://wordpress.org/plugins/wpmovielibrary/)

Viewing 1 replies (of 1 total)

 *  [Charlie Merland](https://wordpress.org/support/users/askelon/)
 * (@askelon)
 * [10 years, 10 months ago](https://wordpress.org/support/topic/taxonomy-problem-4/#post-6427830)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/wpmovielibrary_f6ad77.svg)
 * [WPMovieLibrary](https://wordpress.org/plugins/wpmovielibrary/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpmovielibrary/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpmovielibrary/)
 * [Active Topics](https://wordpress.org/support/plugin/wpmovielibrary/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpmovielibrary/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpmovielibrary/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Charlie Merland](https://wordpress.org/support/users/askelon/)
 * Last activity: [10 years, 10 months ago](https://wordpress.org/support/topic/taxonomy-problem-4/#post-6427830)
 * Status: not resolved