• Resolved amityweb

    (@amityweb)


    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/support

    Website 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 FROMoursite_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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter amityweb

    (@amityweb)

    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

    Thread Starter amityweb

    (@amityweb)

    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.
    Thread Starter amityweb

    (@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.

    Plugin Support Rick Alday

    (@mrdaro)

    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.
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘There was a problem running the migrations. Please reach out to GiveWP support f’ is closed to new replies.