Excessive Database Error Log Entries

  • Resolved mjke87

    (@mjke87)


    4 years, 1 month ago

    Hi,

    I’ve recently updated the plugin and after that I’m getting thousands of error log entries from the FB plugin. A single page refresh logged several MB of data into the log file. It’s always the same message:

    
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '('15526', 'fb_visibility', 'no')' at line 2 for query 

INSERT INTO vs1YXn_postmeta (post_id, meta_key, meta_value )
	VALUES ('15516', 'fb_visibility', 'no')('15526', 'fb_visibility', 'no')

made by do_action('wp_ajax_nopriv_wc_facebook_background_handle_virtual_products_variations'), WP_Hook->do_action, WP_Hook->apply_filters, SkyVerge\WooCommerce\PluginFramework\v5_5_4\SV_WP_Background_Job_Handler->maybe_handle, SkyVerge\WooCommerce\PluginFramework\v5_5_4\SV_WP_Background_Job_Handler->handle, SkyVerge\WooCommerce\Facebook\Utilities\Background_Handle_Virtual_Products_Variations->process_job, SkyVerge\WooCommerce\Facebook\Utilities\Background_Handle_Virtual_Products_Variations->sync_and_hide, SkyVerge\WooCommerce\Facebook\Utilities\Background_Handle_Virtual_Products_Variations->set_product_visibility_meta

    This problem also reduced the page speed in the backend?— I had to deactivate the plugin as a result.

    Is this a known issue? Let me know if you need further information.

    Kind regards,
    Mike

Viewing 13 replies - 1 through 13 (of 13 total)
  • Thread Starter mjke87

    (@mjke87)

    I’m using the plugin version 2.0.3 and WP version 5.5.1

    We have same issue. We receive alerts about client’s WordPress’ plugin
    Facebook for WooCommerce writing log partition full.

    [06-Oct-2020 12:15:30 UTC] WordPress database error Table 'd1234.wp_postmeta' doesn't exist for request DELETE FROM wp_postmeta WHERE post_id = 123 AND meta_key = 'fb_visibility' AND meta_id != 12345, from do_action('wp_ajax_nopriv_wc_facebook_background_remove_duplicate_visibility_meta'), WP_Hook->do_action, WP_Hook->apply_filters, SkyVerge\WooCommerce\PluginFramework\v5_5_4\SV_WP_Background_Job_Handler->maybe_handle, SkyVerge\WooCommerce\PluginFramework\v5_5_4\SV_WP_Background_Job_Handler->handle, SkyVerge\WooCommerce\Facebook\Utilities\Background_Remove_Duplicate_Visibility_Meta->process_job, SkyVerge\WooCommerce\Facebook\Utilities\Background_Remove_Duplicate_Visibility_Meta->remove_duplicates

    WP 5.5.1
    Plugin facebook-for-woocommerce 2.0.3

    Having the very same errors as @gustavz above. Downgrading to the previous version of the plugin ‘solved’ it for now.

    Error log was growing at 10+ mb per second. Shut down the server due to disk space limits.

    I’m having the same issue, it creates an 80GB log everyday, my whole server is just collapsing because of lack of disk space.

    Please fix this

    mda123

    (@mackowiakmda)

    Same problem here on multiple websites.

    Same, it took the server down. I’ve never seen an error log grow at such a speed.

    The bug is in line 141 of includes/Utilities/Background_Remove_Duplicate_Visibility_Meta.php

    “wp_postmeta” has been hard-coded, but the table prefix is configurable – it should be “{$wpdb->postmeta}”.

    Have the same problem. Grew more than 50 Gb last 24 hours. Took the server down.

    Edit: Uninstalled and reinstalled, seems to not generate new errors.

    Same problem resolved by deactivating/reactivating plugin

      wp plugin deactivate facebook-for-woocommerce
  wp plugin activate facebook-for-woocommerce

    but @cbcg points the true error to be fixed.

    +1 for several sites. Has shut down several woocommerce sites for me.

    Hi @mjke87 @gustavz @spigot @theogk @mackowiakmda @cbcg @oakidoaki @mickaelperrin @mickaelperrin

    Thanks for getting in touch about our Facebook for WooCommerce plugin. I’m truly sorry for the SQL errors here!

    One of the community members has submitted a patch for this issue which has been released in 2.0.4.

    Could you please update your plugins to 2.0.4? This should solve the issue but please let me know if it persists!

    Thanks so much!
    Christine

    Thread Starter mjke87

    (@mjke87)

    Hi Christine,

    I’ve updated and reactivated the plugin. After that no errors get logged any more.
    Thank you very much for having this issue resolved so quickly.

    Kind regards,
    Mike

    Hi @mjke87

    Great! Thanks so much for updating me on this!

    If you run into any other issues or questions, please feel free to reach out again — we’re happy to help!

    Thanks!
    Christine

    thank you

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Excessive Database Error Log Entries’ is closed to new replies.