WordPress.org

Make WordPress Core

Opened 5 years ago

Closed 5 years ago

#9962 closed defect (bug) (invalid)

wp_get_object_terms fails on some queries

Reported by: wnorris Owned by: filosofo
Milestone: 2.8 Priority: high
Severity: critical Version: 2.8
Component: Taxonomy Keywords: has-patch
Focuses: Cc:

Description

When deleting multiples posts (and perhaps in other cases), wpdb throws the following error: WordPress database error: [Unknown column 't.name' in 'order clause']

This is because one of the sql queries in taxonomy.php fails to include the terms table in the query, which is sometimes referenced in the sql order clause. Patch attached. Patch seems to work, but should definitely be reviewed, as my SQL-fu isn't what it used to be.

Attachments (1)

taxonomy.diff (930 bytes) - added by wnorris 5 years ago.

Download all attachments as: .zip

Change History (3)

wnorris5 years ago

comment:1 wnorris5 years ago

err... this may have been fixed by r11469. looking into that.

comment:2 wnorris5 years ago

  • Resolution set to invalid
  • Status changed from new to closed

yep, false alarm... I was a couple days behind trunk. All good.

Note: See TracTickets for help on using tickets.