WordPress.org

Make WordPress Core

Opened 12 years ago

Closed 12 years ago

Last modified 6 years ago

#9962 closed defect (bug) (invalid)

wp_get_object_terms fails on some queries

Reported by: wnorris Owned by: filosofo
Milestone: 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 12 years ago.

Download all attachments as: .zip

Change History (4)

@wnorris
12 years ago

#1 @wnorris
12 years ago

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

#2 @wnorris
12 years ago

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

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

#3 @DrewAPicture
6 years ago

  • Milestone 2.8 deleted
Note: See TracTickets for help on using tickets.