Viewing 4 posts - 1 through 4 (of 4 total)
- Posts
Error when backingup on the latest WP, running on my VPS server inside of a Docker of coolify.io.
Need help.Fatal error: Uncaught Error: Undefined constant PDO::MYSQL_ATTR_USE_BUFFERED_QUERY in /var/www/html/wp-content/plugins/boldgrid-backup/vendor/ifsnop/mysqldump-php/src/Ifsnop/Mysqldump/Mysqldump.php:185 Stack trace: #0 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-db-dump.php(124): Ifsnop\Mysqldump\Mysqldump->__construct('mysql:host=mari...', 'tVQGkVDQDhdo07g...', 'Uwes9FjHeblXY3J...', Array) #1 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(1269): Boldgrid_Backup_Admin_Db_Dump->dump('/var/www/html/w...') #2 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(1810): Boldgrid_Backup_Admin_Core->backup_database() #3 /var/www/html/wp-content/plugins/boldgrid-backup/includes/class-boldgrid-backup-archiver.php(113): Boldgrid_Backup_Admin_Core->archive_files(true) #4 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(2763): Boldgrid_Backup_Archiver->run() #5 /var/www/html/wp-includes/class-wp-hook.php(324): Boldgrid_Backup_Admin_Core->boldgrid_backup_now_callback('') #6 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters('', Array) #7 /var/www/html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #8 /var/www/html/wp-admin/admin-ajax.php(192): do_action('wp_ajax_boldgri...') #9 {main} thrown in /var/www/html/wp-content/plugins/boldgrid-backup/vendor/ifsnop/mysqldump-php/src/Ifsnop/Mysqldump/Mysqldump.php on line 185Hi David, sorry to hear you’re experiencing this fatal error in Total Upkeep. Have backups ever worked in the current environment or is this your first time attempting a backup with Total Upkeep? We also need to know exactly when the error is occurring. Does it happen once you actually click the button to begin the backup, or some time after the backup process has begun?
Itf the error occurs after the backup has initiated it would be helpful to navigate to Total Upkeep > Tools > Logs and check the log file with a name like
archive-XXXXXXX.logwith a timestamp corresponding to one of your failed backups.You can reply here with the text in that log file, we’ll be able to take a closer look at what’s going on.
One thing we suggest in these cases is running a sanity check backup to see if the site is allowing you to create backups at all on your server.
The video below explains how to setup the sanity check:
I hope this helps David, we look forward to assisting you further!
Hi.
I have never been able to do a backup.
The backup process starts, but fails after fetching DB tables.I’m running the WP on a Cloud VPS, running inside of a WP Docker from coolify.io.
Here is the latest log:
[2024-10-27 10:13:24 UTC] Cannot add signal handlers, pcntl_async_signals function does not exist. [2024-10-27 10:13:24 UTC] Backup process initialized. [2024-10-27 10:13:24 UTC] Cannot add signal handlers, pcntl_async_signals function does not exist. [2024-10-27 10:13:24 UTC] Backup process initialized. [2024-10-27 10:13:24 UTC] Process id: 517358 [2024-10-27 10:13:24 UTC] Backup triggered by: WP cron [2024-10-27 10:13:24 UTC] -------------------------------------------------------------------------------- [2024-10-27 10:13:24 UTC] Starting dump of database... [2024-10-27 10:13:24 UTC] Memory usage - limit / current / peak memory usage: 2048M / 12164464 (11.60 MB) / 12197024 (12 MB) [2024-10-27 10:13:24 UTC] Database info: Array ( [wp_cmplz_cookiebanners] => 1 [wp_cmplz_cookies] => 0 [wp_cmplz_dnsmpd] => 0 [wp_cmplz_services] => 0 [wp_commentmeta] => 0 [wp_comments] => 1 [wp_e_events] => 0 [wp_e_notes] => 0 [wp_e_notes_users_relations] => 0 [wp_e_submissions] => 0 [wp_e_submissions_actions_log] => 0 [wp_e_submissions_values] => 0 [wp_links] => 0 [wp_mb_relationships] => 3 [wp_nvf_auctioneers] => 1 [wp_nvf_auctions] => 8 [wp_nvf_poc] => 1 [wp_options] => 351 [wp_postmeta] => 203 [wp_posts] => 180 [wp_term_relationships] => 10 [wp_term_taxonomy] => 113 [wp_termmeta] => 0 [wp_terms] => 113 [wp_usermeta] => 61 [wp_users] => 2 [wp_wfblockediplog] => 103 [wp_wfblocks7] => 108 [wp_wfconfig] => 270 [wp_wfcrawlers] => 0 [wp_wffilechanges] => 0 [wp_wffilemods] => 13759 [wp_wfhits] => 138 [wp_wfhoover] => 0 [wp_wfissues] => 1 [wp_wfknownfilelist] => 13760 [wp_wflivetraffichuman] => 0 [wp_wflocs] => 3 [wp_wflogins] => 12 [wp_wfls_2fa_secrets] => 0 [wp_wfls_role_counts] => 0 [wp_wfls_settings] => 30 [wp_wfnotifications] => 5 [wp_wfpendingissues] => 0 [wp_wfreversecache] => 1 [wp_wfsecurityevents] => 0 [wp_wfsnipcache] => 0 [wp_wfstatus] => 978 [wp_wftrafficrates] => 0 [wp_wfwaffailures] => 0 ) [2024-10-27 10:13:24 UTC] Last error: Array ( [type] => 1 [message] => Uncaught Error: Undefined constant PDO::MYSQL_ATTR_USE_BUFFERED_QUERY in /var/www/html/wp-content/plugins/boldgrid-backup/vendor/ifsnop/mysqldump-php/src/Ifsnop/Mysqldump/Mysqldump.php:185 Stack trace: #0 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-db-dump.php(124): Ifsnop\Mysqldump\Mysqldump->__construct('mysql:host=mari...', 'tVQGkVDQDhdo07g...', 'Uwes9FjHeblXY3J...', Array) #1 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(1269): Boldgrid_Backup_Admin_Db_Dump->dump('/var/www/html/w...') #2 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(1810): Boldgrid_Backup_Admin_Core->backup_database() #3 /var/www/html/wp-content/plugins/boldgrid-backup/includes/class-boldgrid-backup-archiver.php(113): Boldgrid_Backup_Admin_Core->archive_files(true) #4 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-wp-cron.php(353): Boldgrid_Backup_Archiver->run() #5 /var/www/html/wp-includes/class-wp-hook.php(324): Boldgrid_Backup_Admin_WP_Cron->backup() #6 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters('', Array) #7 /var/www/html/wp-includes/plugin.php(565): WP_Hook->do_action(Array) #8 /var/www/html/wp-cron.php(191): do_action_ref_array('boldgrid_backup...', Array) #9 {main} thrown [file] => /var/www/html/wp-content/plugins/boldgrid-backup/vendor/ifsnop/mysqldump-php/src/Ifsnop/Mysqldump/Mysqldump.php [line] => 185 )The sanity check worked fine. Here is the log from that:
[2024-10-27 10:13:24 UTC] Cannot add signal handlers, pcntl_async_signals function does not exist. [2024-10-27 10:13:24 UTC] Backup process initialized. [2024-10-27 10:13:24 UTC] Cannot add signal handlers, pcntl_async_signals function does not exist. [2024-10-27 10:13:24 UTC] Backup process initialized. [2024-10-27 10:13:24 UTC] Process id: 517358 [2024-10-27 10:13:24 UTC] Backup triggered by: WP cron [2024-10-27 10:13:24 UTC] -------------------------------------------------------------------------------- [2024-10-27 10:13:24 UTC] Starting dump of database... [2024-10-27 10:13:24 UTC] Memory usage - limit / current / peak memory usage: 2048M / 12164464 (11.60 MB) / 12197024 (12 MB) [2024-10-27 10:13:24 UTC] Database info: Array ( [wp_cmplz_cookiebanners] => 1 [wp_cmplz_cookies] => 0 [wp_cmplz_dnsmpd] => 0 [wp_cmplz_services] => 0 [wp_commentmeta] => 0 [wp_comments] => 1 [wp_e_events] => 0 [wp_e_notes] => 0 [wp_e_notes_users_relations] => 0 [wp_e_submissions] => 0 [wp_e_submissions_actions_log] => 0 [wp_e_submissions_values] => 0 [wp_links] => 0 [wp_mb_relationships] => 3 [wp_nvf_auctioneers] => 1 [wp_nvf_auctions] => 8 [wp_nvf_poc] => 1 [wp_options] => 351 [wp_postmeta] => 203 [wp_posts] => 180 [wp_term_relationships] => 10 [wp_term_taxonomy] => 113 [wp_termmeta] => 0 [wp_terms] => 113 [wp_usermeta] => 61 [wp_users] => 2 [wp_wfblockediplog] => 103 [wp_wfblocks7] => 108 [wp_wfconfig] => 270 [wp_wfcrawlers] => 0 [wp_wffilechanges] => 0 [wp_wffilemods] => 13759 [wp_wfhits] => 138 [wp_wfhoover] => 0 [wp_wfissues] => 1 [wp_wfknownfilelist] => 13760 [wp_wflivetraffichuman] => 0 [wp_wflocs] => 3 [wp_wflogins] => 12 [wp_wfls_2fa_secrets] => 0 [wp_wfls_role_counts] => 0 [wp_wfls_settings] => 30 [wp_wfnotifications] => 5 [wp_wfpendingissues] => 0 [wp_wfreversecache] => 1 [wp_wfsecurityevents] => 0 [wp_wfsnipcache] => 0 [wp_wfstatus] => 978 [wp_wftrafficrates] => 0 [wp_wfwaffailures] => 0 ) [2024-10-27 10:13:24 UTC] Last error: Array ( [type] => 1 [message] => Uncaught Error: Undefined constant PDO::MYSQL_ATTR_USE_BUFFERED_QUERY in /var/www/html/wp-content/plugins/boldgrid-backup/vendor/ifsnop/mysqldump-php/src/Ifsnop/Mysqldump/Mysqldump.php:185 Stack trace: #0 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-db-dump.php(124): Ifsnop\Mysqldump\Mysqldump->__construct('mysql:host=mari...', 'tVQGkVDQDhdo07g...', 'Uwes9FjHeblXY3J...', Array) #1 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(1269): Boldgrid_Backup_Admin_Db_Dump->dump('/var/www/html/w...') #2 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(1810): Boldgrid_Backup_Admin_Core->backup_database() #3 /var/www/html/wp-content/plugins/boldgrid-backup/includes/class-boldgrid-backup-archiver.php(113): Boldgrid_Backup_Admin_Core->archive_files(true) #4 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-wp-cron.php(353): Boldgrid_Backup_Archiver->run() #5 /var/www/html/wp-includes/class-wp-hook.php(324): Boldgrid_Backup_Admin_WP_Cron->backup() #6 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters('', Array) #7 /var/www/html/wp-includes/plugin.php(565): WP_Hook->do_action(Array) #8 /var/www/html/wp-cron.php(191): do_action_ref_array('boldgrid_backup...', Array) #9 {main} thrown [file] => /var/www/html/wp-content/plugins/boldgrid-backup/vendor/ifsnop/mysqldump-php/src/Ifsnop/Mysqldump/Mysqldump.php [line] => 185 )Since I have full root access, how can I debug this scenario?
Thank youThanks for sending over your log David. The error you’re encountering points to missing functionality (
PDO::MYSQL_ATTR_USE_BUFFERED_QUERY) typically caused by improper configuration of the PHP PDO MySQL extension in your Docker environment.It might be specific to your Docker environment but I will run this by our developers for more insight as this issue may call for a bug fix or new feature request.
Thanks for working with us through this!
Viewing 4 posts - 1 through 4 (of 4 total)
- The topic ‘Fatal error when backing up with Total Upkeep’ is closed to new replies.
