You have an error in your SQL syntax – debug

  • Resolved Atimoon

    (@atimoon)


    7 years, 1 month ago

    Hi, it’s me again. I have debugged our website and in debug log i have this by your plugin.
    In Czech wordpress
    [22-Jan-2018 12:58:44 UTC] Chyba databáze WordPressu: 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 ‘AND comment_type NOT IN (‘atum_order_note’, ‘log_note’) ORDER BY comment_date’ at line 1. Konkrétní dotaz: SELECT wp_comments.* FROM wp_comments AND comment_type NOT IN (‘atum_order_note’, ‘log_note’) ORDER BY comment_date_gmt DESC LIMIT 99999. P?íslu?ná funkce: require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts.
    I think it will be about:
    [22-Jan-2018 12:58:44 UTC] Error WordPress database: 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 ‘AND comment_type NOT IN (‘atum_order_note’, ‘log_note’) ORDER BY comment_date’ at line 1. Especially querry: SELECT wp_comments.* FROM wp_comments AND comment_type NOT IN (‘atum_order_note’, ‘log_note’) ORDER BY comment_date_gmt DESC LIMIT 99999. Function: require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts.
    Is there some way hot to fix this problem?
    BTW Thank for your best plugin. ??
    Lukas – Czechia

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Atimoon

    (@atimoon)

    Hi Pavel, zdravím takté?. ??

    Thank you very much for quick answer, today i send you private ticket with information, login to WordPress, FTP and SQL access.

    Best Regards,

    Lukas

    Plugin Author Stock Management Labs

    (@stockmanagementlabs)

    Hi Lukas,

    I am sure you are buy, so please, accept my apology for being pushy.

    Have you got the details for us so we can sort this out, please?

    Best Regards,

    Pavel

    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    @stockmanagementlabs I’ve deleted your offer to login to your user’s site. I’m am 100% sure you mean well but please never ask for credentials on these forums.

    https://www.ads-software.com/support/guidelines/#the-bad-stuff

    Now for the why: The internet is a wonderful place full of very nice people and a few very bad ones. I’m sure everyone here is very nice however, by giving some ones keys to your house you are trusting they wont steal anything. Likewise the person who takes the keys is now responsible for the house FOREVER.

    If something was to go wrong, then you the author may well legally become liable for damages, which they would not normally have been as their software is provided without warranty.

    Please be aware that repeatedly asking for credentials will result in us asking you to repeatedly stop before escalating up to the plugins team.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘You have an error in your SQL syntax – debug’ is closed to new replies.