There was a problem running the migrations. Please reach out to GiveWP support f
-
Hi. Got this error, we assume after an update:
There was a problem running the migrations. Please reach out to GiveWP support for assistance: https://givewp.com/supportWebsite sometimes shows Internal Server Error. Had this in the logs:
[Tue Mar 23 20:43:08.842978 2021] [fcgid:warn] [pid 30550] [client 178.79.152.163:32844] mod_fcgid: stderr: WordPress database error Table 'oursite2018.oursite_give_log' doesn't exist for query SHOW FULL COLUMNS FROM
oursite_give_logmade by do_action_ref_array('wp_give_db_updater_cron'), WP_Hook->do_action, WP_Hook->apply_filters, Give_Background_Updater->handle_cron_healthcheck, Give_Background_Updater->handle, Give_Background_Updater->task, Give_Updates->__pause_db_update, Give_Updates->__health_background_update, Give_Logging->add, Give_Logging->insert_log, Give\\Log\\LogModel->save, Give\\Log\\LogRepository->insertLog, Give\\Framework\\Database\\DB::__callStatic, Give\\Framework\\Database\\DB::runQueryWithErrorChecking, Give\\Framework\\Database\\DB::Give\\Framework\\Database\\{closure}, call_user_func_array, referer: https://oursite.org.uk/wp-cron.php?doing_wp_cron=1616532186.1486580371856689453125
-
I duplicated the give_logs table to give_log, and got this now:
[Tue Mar 23 20:55:55.099013 2021] [fcgid:warn] [pid 1055] [client 212.159.47.183:61531] mod_fcgid: stderr: \t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Give\\Helpers\\Hooks::Give\\Helpers\\{closure}, call_user_func_array, Give\\Framework\\Migrations\\MigrationsRunner->run, Give\\MigrationLog\\Migrations\\CreateMigrationsTable->run, Give\\Framework\\Database\\DB::delta, Give\\Framework\\Database\\DB::runQueryWithErrorChecking, Give\\Framework\\Database\\DB::Give\\Framework\\Database\\{closure}, dbDelta, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-settings
Clicked on an update database button for Give WP and it just hangs, but my log is full of the following, so something is really messed up in the plugin.
[Tue Mar 23 21:06:06.386826 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: \t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Give\\Helpers\\Hooks::Give\\Helpers\\{closure}, call_user_func_array, Give\\Framework\\Migrations\\MigrationsRunner->run, Give\\MigrationLog\\Migrations\\CreateMigrationsTable->run, Give\\Framework\\Database\\DB::delta, Give\\Framework\\Database\\DB::runQueryWithErrorChecking, Give\\Framework\\Database\\DB::Give\\Framework\\Database\\{closure}, dbDelta, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:09.608182 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: WordPress database error Table 'oursite2018.oursite_give_migrations' doesn't exist for query SELECT * FROM oursite_give_migrations WHERE status = 'success' made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Give\\Helpers\\Hooks::Give\\Helpers\\{closure}, Give, Give->__call, Give\\Container\\Container->make, Give\\Container\\Container->resolve, Give\\Container\\Container->build, Give\\Container\\Container->Give\\Container\\{closure}, Give\\Container\\Container->build, ReflectionClass->newInstanceArgs, Give\\Framework\\Migrations\\MigrationsRunner->__construct, Give\\MigrationLog\\MigrationLogRepository->getCompletedMigrationsIDs, Give\\Framework\\Database\\DB::__callStatic, Give\\Framework\\Database\\DB::runQueryWithErrorChecking, Give\\Framework\\Database\\DB::Give\\Framework\\Database\\{closure}, call_user_func_array, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:09.608297 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: Query failed in database, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:09.608301 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: WordPress database error Table 'oursite2018.oursite_give_migrations' doesn't exist for query SELECT count(id) FROM oursite_give_migrations WHERE id IN ('add_exchange_amount_and_exchange_currency_column_to_revenue_table','set_paypal_standard_id_to_paypal_from_paypal_standard','create_revenue_table','remove_revenue_foreign_keys','create_migrations_table','migrate_completed_migrations','create_new_log_table') AND status != 'success' made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Give\\Helpers\\Hooks::Give\\Helpers\\{closure}, call_user_func_array, Give\\Framework\\Migrations\\MigrationsRunner->run, Give\\MigrationLog\\MigrationLogRepository->getFailedMigrationsCountByIds, Give\\Framework\\Database\\DB::__callStatic, Give\\Framework\\Database\\DB::runQueryWithErrorChecking, Give\\Framework\\Database\\DB::Give\\Framework\\Database\\{closure}, call_user_func_array, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:09.608329 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: WordPress database error Invalid default value for 'last_run' for query CREATE TABLE oursite_give_migrations (, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:09.608333 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: \t\t\tid VARCHAR(180) NOT NULL,, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:09.608336 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: \t\t\tstatus VARCHAR(16) NOT NULL,, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:09.608338 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: \t\t\terror text NULL,, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:09.608341 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: \t\t\tlast_run DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:09.608344 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: \t\t\tPRIMARY KEY (id), referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:09.608347 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: \t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Give\\Helpers\\Hooks::Give\\Helpers\\{closure}, call_user_func_array, Give\\Framework\\Migrations\\MigrationsRunner->run, Give\\MigrationLog\\Migrations\\CreateMigrationsTable->run, Give\\Framework\\Database\\DB::delta, Give\\Framework\\Database\\DB::runQueryWithErrorChecking, Give\\Framework\\Database\\DB::Give\\Framework\\Database\\{closure}, dbDelta, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:13.675342 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: WordPress database error Table 'oursite2018.oursite_give_migrations' doesn't exist for query SELECT * FROM oursite_give_migrations WHERE status = 'success' made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Give\\Helpers\\Hooks::Give\\Helpers\\{closure}, Give, Give->__call, Give\\Container\\Container->make, Give\\Container\\Container->resolve, Give\\Container\\Container->build, Give\\Container\\Container->Give\\Container\\{closure}, Give\\Container\\Container->build, ReflectionClass->newInstanceArgs, Give\\Framework\\Migrations\\MigrationsRunner->__construct, Give\\MigrationLog\\MigrationLogRepository->getCompletedMigrationsIDs, Give\\Framework\\Database\\DB::__callStatic, Give\\Framework\\Database\\DB::runQueryWithErrorChecking, Give\\Framework\\Database\\DB::Give\\Framework\\Database\\{closure}, call_user_func_array, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:13.675381 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: Query failed in database, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:13.675385 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: WordPress database error Table 'oursite2018.oursite_give_migrations' doesn't exist for query SELECT count(id) FROM oursite_give_migrations WHERE id IN ('add_exchange_amount_and_exchange_currency_column_to_revenue_table','set_paypal_standard_id_to_paypal_from_paypal_standard','create_revenue_table','remove_revenue_foreign_keys','create_migrations_table','migrate_completed_migrations','create_new_log_table') AND status != 'success' made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Give\\Helpers\\Hooks::Give\\Helpers\\{closure}, call_user_func_array, Give\\Framework\\Migrations\\MigrationsRunner->run, Give\\MigrationLog\\MigrationLogRepository->getFailedMigrationsCountByIds, Give\\Framework\\Database\\DB::__callStatic, Give\\Framework\\Database\\DB::runQueryWithErrorChecking, Give\\Framework\\Database\\DB::Give\\Framework\\Database\\{closure}, call_user_func_array, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:13.675418 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: WordPress database error Invalid default value for 'last_run' for query CREATE TABLE oursite_give_migrations (, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:13.675421 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: \t\t\tid VARCHAR(180) NOT NULL,, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:13.675425 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: \t\t\tstatus VARCHAR(16) NOT NULL,, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:13.675427 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: \t\t\terror text NULL,, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:13.675430 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: \t\t\tlast_run DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:13.675446 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: \t\t\tPRIMARY KEY (id), referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [Tue Mar 23 21:06:13.675449 2021] [fcgid:warn] [pid 7876] [client 212.159.47.183:62056] mod_fcgid: stderr: \t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Give\\Helpers\\Hooks::Give\\Helpers\\{closure}, call_user_func_array, Give\\Framework\\Migrations\\MigrationsRunner->run, Give\\MigrationLog\\Migrations\\CreateMigrationsTable->run, Give\\Framework\\Database\\DB::delta, Give\\Framework\\Database\\DB::runQueryWithErrorChecking, Give\\Framework\\Database\\DB::Give\\Framework\\Database\\{closure}, dbDelta, referer: https://oursite.org.uk/wp-admin/edit.php?post_type=give_forms&page=give-updates&give-run-db-update=1 [root@oursiteserver logs]#
- This reply was modified 3 years, 8 months ago by amityweb.
Rolled back to version 2.9.7 seems to have got it working again, no database update errors etc. Will have to leave it at v 2.9.7 until this issue is sorted in the plugin.
Hi @amityweb.
We are working currently to isolate some edge case database migration issues that affect a handful of sites, especially ones with a long donation history.
Do you have a staging site or test site where you can replicate this issue? That would be immensely helpful in getting to the bottom of this.Also, if you can turn on WP_DEBUG mode on that staging site, that would be excellent:
// Turn debugging on define('WP_DEBUG', true); // Tell WordPress to log everything to /wp-content/debug.log define('WP_DEBUG_LOG', true); // Turn off the display of error messages on your site define('WP_DEBUG_DISPLAY', false);
In the meantime, if your site is still able to accept donations, you should be OK to ignore the warnings/errors, and we’ll keep you posted on updates to fix these issues.
- This reply was modified 3 years, 8 months ago by Rick Alday.
- The topic ‘There was a problem running the migrations. Please reach out to GiveWP support f’ is closed to new replies.