Unable to export

Try to disable WpSecurityAuditLog plugin and try again.

hi @yaniiliev,

the security audit log is actually a part of WP Activity Log plugin.

I have tried by temporarily disabling it and run the backup again, but seems like similar error still occured with below sample taken from the container log.

[Sun Nov 05 14:26:58.116602 2023] [php7:notice] [pid 415] [client 172.21.0.4:45100] 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 = ‘_transient_et_builder_ajax_cache’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ET_Builder_Ajax_Cache->save, ET_Builder_Ajax_Cache->load, get_transient, get_option, referer: https://pakejstaging.xxxx.gov.my/wp-admin/admin.php?page=ai1wm_backups
[Sun Nov 05 14:30:30.972862 2023] [php7:notice] [pid 27] [client 172.21.0.4:36086] 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 = ‘_transient_timeout_et_builder_ajax_cache’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ET_Builder_Ajax_Cache->save, ET_Builder_Ajax_Cache->load, get_transient, get_option, referer: https://pakejstaging.xxxx.gov.my/wp-admin/admin.php?page=ai1wm_backups
[Sun Nov 05 14:30:30.973277 2023] [php7:notice] [pid 27] [client 172.21.0.4:36086] 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 = ‘_transient_et_builder_ajax_cache’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ET_Builder_Ajax_Cache->save, ET_Builder_Ajax_Cache->load, get_transient, get_option, referer: https://pakejstaging.xxxx.gov.my/wp-admin/admin.php?page=ai1wm_backups

The “Commands out of sync” error you are encountering is typically related to the improper use of MySQL client functions, which can happen within WordPress plugins that execute direct database queries. It suggests that a previous SQL command needs to be fully processed before the next one can be run.

Here are a few steps you can take to troubleshoot the issue:

1. **Disable Object Caching**: If you have a caching plugin or server-side caching enabled, try disabling it to see if the problem persists.

2. **Plugin Conflict**: Even though disabling the WP Activity Log didn’t resolve the issue, there might be another plugin causing a conflict. Try disabling all non-essential plugins and then run the backup again.

3. **Theme Conflict**: Temporarily switch to a default WordPress theme like Twenty Twenty-One to rule out theme-specific issues.

4. **Database Issues**: Check your database for any potential issues or inconsistencies. You can use tools like phpMyAdmin to analyze and repair tables if necessary.

5. **Server Resources**: Monitor your server resources during the backup process. Insufficient resources can sometimes lead to unexpected errors.

6. **Consult with a Developer**: If the problem continues, you might need to consult with a web developer or a database expert to investigate the direct database queries causing the error.

Remember to always make a complete backup of your website before making changes or performing operations that could affect your site’s data.