• Resolved Nicki Faulk

    (@nitallica)


    I’m seeing the below error on both blogs of mine that use this plugin. If I downgrade to 4.1.1, I don’t see the errors (but I would rather stay on latest and greatest for security). I see that this error occurred for someone here 3-4 months back in v4.1.4. Is anyone else seeing this?

    • Version numbers: WordPress Version 6.0.2, plugin Version 4.1.5
    • The URL to blog: nowwerecookin.org and nickifaulk.com both run this.
    • Software of webserver: Apache/2.4.54
    • List of other plugins used, especially plugins which modify the output, like caching or SEO plugins: Akismet, Classic Editor, Display Posts, Print PDF, Remove Noreferrer, Search Meter, Sharify, TaxoPress, Very Simple Contact Form, WP Super Cache

    Error_log contents:

    [18-Sep-2022 07:12:37 UTC] 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 '->posts} p WHERE p.post_status='publish'' at line 1 for query SELECT COUNT(*) FROM {$wpdb->posts} p WHERE p.post_status='publish' made by do_action_ref_array('sm_ping_daily'), WP_Hook->do_action, WP_Hook->apply_filters, GoogleSitemapGeneratorLoader::call_send_ping_daily, GoogleSitemapGenerator->send_ping_daily, GoogleSitemapGenerator->send_stats
    [18-Sep-2022 13:54:54 UTC] 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 '->posts} p WHERE p.post_status='publish'' at line 1 for query SELECT COUNT(*) FROM {$wpdb->posts} p WHERE p.post_status='publish' made by do_action_ref_array('sm_ping_daily'), WP_Hook->do_action, WP_Hook->apply_filters, GoogleSitemapGeneratorLoader::call_send_ping_daily, GoogleSitemapGenerator->send_ping_daily, GoogleSitemapGenerator->send_stats
    [18-Sep-2022 19:04:22 UTC] 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 '->posts} p WHERE p.post_status='publish'' at line 1 for query SELECT COUNT(*) FROM {$wpdb->posts} p WHERE p.post_status='publish' made by do_action_ref_array('sm_ping_daily'), WP_Hook->do_action, WP_Hook->apply_filters, GoogleSitemapGeneratorLoader::call_send_ping_daily, GoogleSitemapGenerator->send_ping_daily, GoogleSitemapGenerator->send_stats

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thanks for reaching out to us. We have already tackled this issue. The new version deployment is on the cards, once you update to the latest version, the issue will be fixed.

    Thread Starter Nicki Faulk

    (@nitallica)

    Heyya, any timeline on that new version being released? I’m having to clean up these error-logs pretty often now. ??

    saurabhdhariwal01

    (@saurabhdhariwal01)

    Hello @nitallica,
    We plan to release the new version in two to three weeks.

    Thread Starter Nicki Faulk

    (@nitallica)

    Awesomesauce, thanks! ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Error in SQL syntax, Version 4.1.5’ is closed to new replies.