Mysql error

  • Resolved eiland

    (@eiland)


    5 years, 4 months ago

    Hi, Regarding https://www.ads-software.com/support/topic/wp_postmeta-query-compatibility/

    My error log contains a mysql error on

    SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta AS stmt1 ON wp_posts.ID = stmt1.post_id WHERE 1=1 AND wp_posts.ID NOT IN (REDACTED) AND (((wp_posts.post_title LIKE '%REDACTED\\') OR (stmt1.meta_value LIKE '%REDACTED\\')%') OR (wp_posts.post_excerpt LIKE '%REDACTED\\')%') OR (wp_posts.post_content LIKE '%REDACTED\\')%')) AND ((wp_posts.post_title LIKE '%AND%') OR (stmt1.meta_value LIKE '%AND%') OR (wp_posts.post_excerpt LIKE '%AND%') OR (wp_posts.post_content LIKE '%AND%')) AND ((wp_posts.post_title LIKE '%9349=3455%') OR (stmt1.meta_value LIKE '%9349=3455%') OR (wp_posts.post_excerpt LIKE '%9349=3455%') OR (wp_posts.post_content LIKE '%9349=3455%')) AND ((wp_posts.post_title LIKE '%AND%') OR (stmt1.meta_value LIKE '%AND%') OR (wp_posts.post_excerpt LIKE '%AND%') OR (wp_posts.post_content LIKE '%AND%')) AND ((wp_posts.post_title LIKE '%(\\'sEzC\\'=\\'sEzC%') OR (wp_posts.post_excerpt LIKE '%(\\'sEzC\\'=\\'sEzC%') OR (wp_posts.post_content LIKE '%(\\'sEzC\\'=\\'sEzC%'))) AND (wp_posts.post_password = '') AND wp_posts.post_type IN ('post', 'page', 'attachment') AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10

    The variable REDACTED seems to be escaped double?

    Not entirely sure if is connected with 2T or with https://www.ads-software.com/plugins/search-filter/ though

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author thaikolja

    (@thaikolja)

    Hi,

    Have you tried deactivating all other plugins to narrow the source of the bug down?

    Thread Starter eiland

    (@eiland)

    Nope, that would break the site. I just thought to give you a heads up.

    Plugin Author thaikolja

    (@thaikolja)

    Thanks a lot, I appreciate that, but as you know, chasing a bug that I can’t reproduce is tricky.

    The only escaping functions used are esc_attr() and esc_html(). The title format goes through stripslashes() before it lands in the database.

    Thread Starter eiland

    (@eiland)

    Sure. As for reproducing, I also don’t know exactly the search query at hand, as its from the log, and it doesn’t seem to be ‘REDACTED’.

    Plugin Author thaikolja

    (@thaikolja)

    Thanks, I’ll keep an eye on this, maybe it pops up with some plugin combinations. Thanks for reporting this!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Mysql error’ is closed to new replies.

Tags