Support » Plugin: Simple Taxonomy Ordering » SQL Error after upgrade WP to version 4.7

  • Resolved Buri

    (@burisk)


    Hi all,

    This plugin, after WordPress upgrade to 4.7 version is broken in frontpage (not in admin).

    I got SQL error Not unique table/alias: 'term_meta'

    And this is part of generated SQL that causes an error:

    ...
    INNER JOIN wp0_termmeta AS term_meta
    ON t.term_id = term_meta.term_id
    AND term_meta.meta_key = 'tax_position'
    INNER JOIN wp0_termmeta AS term_meta
    ON t.term_id = term_meta.term_id
    AND term_meta.meta_key = 'tax_position'
    INNER JOIN wp0_termmeta AS term_meta
    ON t.term_id = term_meta.term_id
    AND term_meta.meta_key = 'tax_position'
    ...

    Best regards,
    Peter.

    • This topic was modified 3 years, 9 months ago by Buri.
Viewing 1 replies (of 1 total)
  • Plugin Contributor yikesitskevin

    (@yikesitskevin)

    Hi Peter,

    Thanks for letting us know; our join statement was being added to the query twice. This has been fixed and released (see version 1.2.3).

    Thanks again for pointing this out!

    Happy New Year,
    Kevin.

Viewing 1 replies (of 1 total)
  • The topic ‘SQL Error after upgrade WP to version 4.7’ is closed to new replies.