SQL Error after upgrade WP to version 4.7

  • Resolved Buri

    (@burisk)


    9 years, 5 months ago

    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 9 years, 5 months ago by Buri.
Viewing 1 replies (of 1 total)
  • Plugin Contributor yikesitskevin

    (@yikesitskevin)

    9 years, 5 months ago

    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.