Support » Plugin: Comments - wpDiscuz » MySQL "error in your SQL syntax"

  • Resolved Violent

    (@violent)


    Hi, after update to the last version, I’m getting this error under comments’ form:
    << Ошибка базы данных WordPress: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]
    SELECT GROUP_CONCAT(TRIM(BOTH ‘,’ FROM meta_value)) FROM wp_commentmeta WHERE meta_key = ‘wpdiscuz_child_ids’ AND comment_id IN () >>

    Please check this and fix.

    https://wordpress.org/plugins/wpdiscuz/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Amr Ali

    (@amr3li)

    Hello
    I am getting the same error everytime wpDiscuz is loaded in a blog post, and it only stared to count since the last update “3.0.8”

    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1 for query SELECT GROUP_CONCAT(TRIM(BOTH ‘,’ FROM meta_value)) FROM ehdb_commentmeta WHERE meta_key = ‘wpdiscuz_child_ids’ AND comment_id IN () made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/salient/single.php’), comments_template, require(‘/plugins/wpdiscuz/templates/comment/comment-form.php’), WpdiscuzCore->getWPComments, WpdiscuzCore->_getWPComments, WpdiscuzOptimizationHelper->getCommentListByParentIds, WpdiscuzDBManager->getIdsInMeta

    Hopefully it gets fixed quickly, Thank you

    Plugin Author gVectors Team

    (@gvectors-team)

    Ok, we see the issue.
    We’re going to update it asap…

    Plugin Author gVectors Team

    (@gvectors-team)

    All issues are fixed please update to 3.0.9 version. We just released it. Don’t forget delete cache after the update.

    Violent

    (@violent)

    Thanks for the quick response to the problem! All is good now 😊😉

    Amr Ali

    (@amr3li)

    Hello

    3.0.9 update solved the issue.
    Quick respond and brilliant support. thank you guys

    regards

    Plugin Author gVectors Team

    (@gvectors-team)

    You’re welcome!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘MySQL "error in your SQL syntax"’ is closed to new replies.