db error in the log

  • Resolved krasi1

    (@krasi1)


    12 months ago

    on multiple file uploads I see this error
    might be some conflict with the WP Media folder plugin

    [30-Nov-2023 08:31:48 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = '_site_transient_timeout_webpc_cron_paths' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WebpConverter\Action\UploadFileHandler->save_paths_to_conversion, WebpConverter\Conversion\Cron\CronInitiator->add_paths_to_conversion, WebpConverter\Conversion\Cron\CronStatusManager->get_paths_to_conversion, get_site_transient, get_site_option, get_network_option, get_option
[30-Nov-2023 08:31:48 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = '_site_transient_webpc_cron_paths' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WebpConverter\Action\UploadFileHandler->save_paths_to_conversion, WebpConverter\Conversion\Cron\CronInitiator->add_paths_to_conversion, WebpConverter\Conversion\Cron\CronStatusManager->get_paths_to_conversion, get_site_transient, get_site_option, get_network_option, get_option
[30-Nov-2023 08:31:48 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('_site_transient_timeout_webpc_cron_paths', '1701336708', 'no') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WebpConverter\Action\UploadFileHandler->save_paths_to_conversion, WebpConverter\Conversion\Cron\CronInitiator->add_paths_to_conversion, WebpConverter\Conversion\Cron\CronStatusManager->set_paths_to_conversion, set_site_transient, add_site_option, add_network_option, add_option
[30-Nov-2023 08:31:48 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('_site_transient_webpc_cron_paths', 'a:6:{i:0;s:128:\"/home/thesear2/public_html/staging/wp-content/uploads/posts/bangladesh-disaster-comms-bycatch/20220129_124018-scaled-300x225.jpg\";i:1;s:129:\"/home/thesear2/public_html/staging/wp-content/uploads/posts/bangladesh-disaster-comms-bycatch/20220129_124018-scaled-1024x768.jpg\";i:2;s:128:\"/home/thesear2/public_html/staging/wp-content/uploads/posts/bangladesh-disaster-comms-bycatch/20220129_124018-scaled-150x150.jpg\";i:3;s:128:\"/home/thesear2/public_html/staging/wp-content/uploads/posts/bangladesh-disaster-comms-bycatch/20220129_124018-scaled-768x576.jpg\";i:4;s:130:\"/home/thesear2/public_html/staging/wp-content/uploads/posts/bangladesh-disaster-comms-bycatch/20220129_124018-scaled-1536x1152.jpg\";i:5;s:130:\"/home/thesear2/public_html/staging/wp-content/uploads/posts/bangladesh-disaster-comms-bycatch/20220129_124018-scaled-2048x1536.jpg\";}', 'no') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WebpConverter\Action\UploadFileHandler->save_paths_to_conversion, WebpConverter\Conversion\Cron\CronInitiator->add_paths_to_conversion, WebpConverter\Conversion\Cron\CronStatusManager->set_paths_to_conversion, set_site_transient, add_site_option, add_network_option, add_option
[30-Nov-2023 08:31:48 UTC] WordPress database error Commands out of sync; you can't run this command now for query UPDATE wp_options SET option_value = '1701333168', autoload = 'no' WHERE option_name = '_site_transient_timeout_webpc_cron_request_id' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WebpConverter\Action\UploadFileHandler->save_paths_to_conversion, WebpConverter\Conversion\Cron\CronInitiator->init_async_conversion, WebpConverter\Conversion\Endpoint\CronConversionEndpoint::get_route_nonce, WebpConverter\Conversion\Cron\CronStatusManager->refresh_conversion_request_id, set_site_transient, update_site_option, update_network_option, update_option
[30-Nov-2023 08:31:48 UTC] WordPress database error Commands out of sync; you can't run this command now for query UPDATE wp_options SET option_value = '65684874dc3721.89176432', autoload = 'no' WHERE option_name = '_site_transient_webpc_cron_request_id' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WebpConverter\Action\UploadFileHandler->save_paths_to_conversion, WebpConverter\Conversion\Cron\CronInitiator->init_async_conversion, WebpConverter\Conversion\Endpoint\CronConversionEndpoint::get_route_nonce, WebpConverter\Conversion\Cron\CronStatusManager->refresh_conversion_request_id, set_site_transient, update_site_option, update_network_option, update_option
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Mateusz Gbiorczyk

    (@mateuszgbiorczyk)

    Hi @krasi1,

    Thank you for your message.

    Our plugin uses the set_site_transient function available in WordPress. After using this feature, WordPress saves the data to the database and then the problem occurs. We are unable to change this feature as it is essential for the plugin to work and we use it in accordance with the WordPress documentation. Over 400,000 websites use our plugin and we have never had a report like this.

    In my opinion, the problem is related to the connection to the database or some other plugin that changes something in the connection to the SQL database. It’s hard for me to say what the source of the problem is.

    I also don’t know what the WP Media folder plugin is.

    Please tell me what do you expect from me?

    Best,
    Mateusz

    Thread Starter krasi1

    (@krasi1)

    https://www.joomunited.com/wordpress-products/wp-media-folder
    it stored the images into phisical folders


    Any pointers on where to look for fixing this in the plugin?

    Plugin Author Mateusz Gbiorczyk

    (@mateuszgbiorczyk)

    @krasi1 The WP Media Folder plugin is a paid plugin, we do not have access to it.

    Did you see my entire previous message? You only commented on the sentence about the WP Media Folder plugin, and I wrote my entire opinion to you above.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘db error in the log’ is closed to new replies.