dm5br
Forum Replies Created
Viewing 2 replies - 1 through 2 (of 2 total)
-
Continuing to try and get this resolved I poked around in the database. In the give_migrations table there are 24 records all with status of “success” except for one, which has a status “failed”. It has an id of “move-donation-comment-to-donation-meta-table”
The error column has this stack trace. Note the deadlock error (line 198).
Give\Framework\Migrations\Exceptions\DatabaseMigrationException Object
(
[message:protected] => Failed running migration: Move donation comment to donation meta table
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /home/customer/www/mc-care.org/public_html/mccare/wp-content/plugins/give/src/Donations/Migrations/MoveDonationCommentToDonationMetaTable.php
[line:protected] => 87
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/customer/www/mc-care.org/public_html/mccare/wp-content/plugins/give/src/Framework/Migrations/MigrationsRunner.php
[line] => 113
[function] => run
[class] => Give\Donations\Migrations\MoveDonationCommentToDonationMetaTable
[type] => ->
[args] => Array
(
)) [1] => Array ( [function] => run [class] => Give\Framework\Migrations\MigrationsRunner [type] => -> [args] => Array ( [0] => ) ) [2] => Array ( [file] => /home/customer/www/mc-care.org/public_html/mccare/wp-content/plugins/give/src/Helpers/Hooks.php [line] => 43 [function] => call_user_func_array [args] => Array ( [0] => Array ( [0] => Give\Framework\Migrations\MigrationsRunner Object ( [completedMigrations:Give\Framework\Migrations\MigrationsRunner:private] => Array ( [0] => add_paymentmode_to_subscription_table [1] => add-missing-donor-id-in-donation-comments [2] => add-missing-transaction-id-for-uncompleted-stripe-donations [3] => add-statement-descriptor-to-stripe-accounts [4] => complete-removed-legacy-log-migration [5] => create_migrations_table [6] => create_new_log_table [7] => create_revenue_table [8] => create_subscription_tables [9] => delete_old_log_tables [10] => migrate_completed_migrations [11] => remove_revenue_foreign_keys [12] => remove_sensitive_logs [13] => remove-log-with-card-info [14] => remove-paypal-ipn-verification-setting [15] => set_paypal_standard_id_to_paypal_from_paypal_standard [16] => set-form-donation-levels-to-strings ) [migrationRegister:Give\Framework\Migrations\MigrationsRunner:private] => Give\Framework\Migrations\MigrationsRegister Object ( [migrations:Give\Framework\Migrations\MigrationsRegister:private] => Array ( [set_paypal_standard_id_to_paypal_from_paypal_standard] => Give\PaymentGateways\Gateways\PayPalStandard\Migrations\SetPayPalStandardGatewayId [remove-paypal-ipn-verification-setting] => Give\PaymentGateways\Gateways\PayPalStandard\Migrations\RemovePayPalIPNVerificationSetting [set-form-donation-levels-to-strings] => Give\Onboarding\Migrations\SetFormDonationLevelsToStrings [create_revenue_table] => Give\Revenue\Migrations\CreateRevenueTable [remove_revenue_foreign_keys] => Give\Revenue\Migrations\RemoveRevenueForeignKeys [create_migrations_table] => Give\MigrationLog\Migrations\CreateMigrationsTable [migrate_completed_migrations] => Give\MigrationLog\Migrations\MigrateCompletedMigrations [create_new_log_table] => Give\Log\Migrations\CreateNewLogTable [remove_sensitive_logs] => Give\Log\Migrations\RemoveSensitiveLogs [complete-removed-legacy-log-migration] => Give\Log\Migrations\CompleteRemovedLegacyLogMigration [delete_old_log_tables] => Give\Log\Migrations\DeleteOldLogTables [add-statement-descriptor-to-stripe-accounts] => Give\PaymentGateways\Gateways\Stripe\Migrations\AddStatementDescriptorToStripeAccounts [add-missing-transaction-id-for-uncompleted-stripe-donations] => Give\PaymentGateways\Gateways\Stripe\Migrations\AddMissingTransactionIdForUncompletedDonations [remove-log-with-card-info] => Give\PaymentGateways\PayPalCommerce\Migrations\RemoveLogWithCardInfo [remove_payment_intent_secret_meta] => Give\PaymentGateways\Gateways\Stripe\Migrations\RemovePaymentIntentSecretMeta [register-paypal-donations-refresh-token-cron-job-by-mode] => Give\PaymentGateways\PayPalCommerce\Migrations\RegisterPayPalDonationsRefreshTokenCronJobByMode [copy-v2-gateways-settings-to-v3] => Give\PaymentGateways\Migrations\CopyV2GatewaysSettingsToV3 [add-missing-donor-id-in-donation-comments] => Give\Donations\Migrations\AddMissingDonorIdToDonationComments [set_automatic_formatting_option] => Give\Donations\Migrations\SetAutomaticFormattingOption [move-donation-comment-to-donation-meta-table] => Give\Donations\Migrations\MoveDonationCommentToDonationMetaTable [donors-add-phone-column] => Give\Donors\Migrations\AddPhoneColumn [create_subscription_tables] => Give\Subscriptions\Migrations\CreateSubscriptionTables [add_paymentmode_to_subscription_table] => Give\Subscriptions\Migrations\AddPaymentModeToSubscriptionTable [donation-forms-clean-multiple-slashes-on-db] => Give\DonationForms\Migrations\CleanMultipleSlashesOnDB [donation-forms-remove-duplicate-meta] => Give\DonationForms\Migrations\RemoveDuplicateMeta ) ) [migrationLogFactory:Give\Framework\Migrations\MigrationsRunner:private] => Give\MigrationLog\MigrationLogFactory Object ( ) [migrationLogRepository:Give\Framework\Migrations\MigrationsRunner:private] => Give\MigrationLog\MigrationLogRepository Object ( [migration_table:Give\MigrationLog\MigrationLogRepository:private] => cax_give_migrations [migrationFactory:Give\MigrationLog\MigrationLogRepository:private] => Give\MigrationLog\MigrationLogFactory Object ( ) ) ) [1] => run ) [1] => Array ( [0] => ) ) ) [3] => Array ( [file] => /home/customer/www/mc-care.org/public_html/mccare/wp-includes/class-wp-hook.php [line] => 324 [function] => Give\Helpers\{closure} [class] => Give\Helpers\Hooks [type] => :: [args] => Array ( [0] => ) ) [4] => Array ( [file] => /home/customer/www/mc-care.org/public_html/mccare/wp-includes/class-wp-hook.php [line] => 348 [function] => apply_filters [class] => WP_Hook [type] => -> [args] => Array ( [0] => [1] => Array ( [0] => ) ) ) [5] => Array ( [file] => /home/customer/www/mc-care.org/public_html/mccare/wp-includes/plugin.php [line] => 517 [function] => do_action [class] => WP_Hook [type] => -> [args] => Array ( [0] => Array ( [0] => ) ) ) [6] => Array ( [file] => /home/customer/www/mc-care.org/public_html/mccare/wp-admin/admin-ajax.php [line] => 45 [function] => do_action [args] => Array ( [0] => admin_init ) ) ) [previous:Exception:private] => Give\Framework\Database\Exceptions\DatabaseQueryException Object ( [queryErrors:Give\Framework\Database\Exceptions\DatabaseQueryException:private] => Array ( [db_delta_error] => Array ( [0] => Deadlock found when trying to get lock; try restarting transaction ) ) [query:Give\Framework\Database\Exceptions\DatabaseQueryException:private] => DELETE FROM cax_give_commentmeta WHERE give_comment_id IN( SELECT comment_ID FROM cax_give_comments WHERE comment_type = 'donor_donation' ) [message:protected] => Database Query [string:Exception:private] => [code:protected] => 0 [file:protected] => /home/customer/www/mc-care.org/public_html/mccare/wp-content/plugins/give/src/Framework/Database/DB.php [line:protected] => 247 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home/customer/www/mc-care.org/public_html/mccare/wp-content/plugins/give/src/Framework/Database/DB.php [line] => 95 [function] => runQueryWithErrorChecking [class] => Give\Framework\Database\DB [type] => :: [args] => Array ( [0] => Closure Object ( [static] => Array ( [name] => query [arguments] => Array ( [0] => DELETE FROM cax_give_commentmeta WHERE give_comment_id IN( SELECT comment_ID FROM cax_give_comments WHERE comment_type = 'donor_donation' ) ) ) ) ) ) [1] => Array ( [file] => /home/customer/www/mc-care.org/public_html/mccare/wp-content/plugins/give/src/Donations/Migrations/MoveDonationCommentToDonationMetaTable.php [line] => 69 [function] => __callStatic [class] => Give\Framework\Database\DB [type] => :: [args] => Array ( [0] => query [1] => Array ( [0] => DELETE FROM cax_give_commentmeta WHERE give_comment_id IN( SELECT comment_ID FROM cax_give_comments WHERE comment_type = 'donor_donation' ) ) ) ) [2] => Array ( [file] => /home/customer/www/mc-care.org/public_html/mccare/wp-content/plugins/give/src/Framework/Migrations/MigrationsRunner.php [line] => 113 [function] => run [class] => Give\Donations\Migrations\MoveDonationCommentToDonationMetaTable [type] => -> [args] => Array ( ) ) [3] => Array ( [function] => run [class] => Give\Framework\Migrations\MigrationsRunner [type] => -> [args] => Array ( [0] => ) ) [4] => Array ( [file] => /home/customer/www/mc-care.org/public_html/mccare/wp-content/plugins/give/src/Helpers/Hooks.php [line] => 43 [function] => call_user_func_array [args] => Array ( [0] => Array ( [0] => Give\Framework\Migrations\MigrationsRunner Object ( [completedMigrations:Give\Framework\Migrations\MigrationsRunner:private] => Array ( [0] => add_paymentmode_to_subscription_table [1] => add-missing-donor-id-in-donation-comments [2] => add-missing-transaction-id-for-uncompleted-stripe-donations [3] => add-statement-descriptor-to-stripe-accounts [4] => complete-removed-legacy-log-migration [5] => create_migrations_table [6] => create_new_log_table [7] => create_revenue_table [8] => create_subscription_tables [9] => delete_old_log_tables [10] => migrate_completed_migrations [11] => remove_revenue_foreign_keys [12] => remove_sensitive_logs [13] => remove-log-with-card-info [14] => remove-paypal-ipn-verification-setting [15] => set_paypal_standard_id_to_paypal_from_paypal_standard [16] => set-form-donation-levels-to-strings ) [migrationRegister:Give\Framework\Migrations\MigrationsRunner:private] => Give\Framework\Migrations\MigrationsRegister Object ( [migrations:Give\Framework\Migrations\MigrationsRegister:private] => Array ( [set_paypal_standard_id_to_paypal_from_paypal_standard] => Give\PaymentGateways\Gateways\PayPalStandard\Migrations\SetPayPalStandardGatewayId [remove-paypal-ipn-verification-setting] => Give\PaymentGateways\Gateways\PayPalStandard\Migrations\RemovePayPalIPNVerificationSetting [set-form-donation-levels-to-strings] => Give\Onboarding\Migrations\SetFormDonationLevelsToStrings [create_revenue_table] => Give\Revenue\Migrations\CreateRevenueTable [remove_revenue_foreign_keys] => Give\Revenue\Migrations\RemoveRevenueForeignKeys [create_migrations_table] => Give\MigrationLog\Migrations\CreateMigrationsTable [migrate_completed_migrations] => Give\MigrationLog\Migrations\MigrateCompletedMigrations [create_new_log_table] => Give\Log\Migrations\CreateNewLogTable [remove_sensitive_logs] => Give\Log\Migrations\RemoveSensitiveLogs [complete-removed-legacy-log-migration] => Give\Log\Migrations\CompleteRemovedLegacyLogMigration [delete_old_log_tables] => Give\Log\Migrations\DeleteOldLogTables [add-statement-descriptor-to-stripe-accounts] => Give\PaymentGateways\Gateways\Stripe\Migrations\AddStatementDescriptorToStripeAccounts [add-missing-transaction-id-for-uncompleted-stripe-donations] => Give\PaymentGateways\Gateways\Stripe\Migrations\AddMissingTransactionIdForUncompletedDonations [remove-log-with-card-info] => Give\PaymentGateways\PayPalCommerce\Migrations\RemoveLogWithCardInfo [remove_payment_intent_secret_meta] => Give\PaymentGateways\Gateways\Stripe\Migrations\RemovePaymentIntentSecretMeta [register-paypal-donations-refresh-token-cron-job-by-mode] => Give\PaymentGateways\PayPalCommerce\Migrations\RegisterPayPalDonationsRefreshTokenCronJobByMode [copy-v2-gateways-settings-to-v3] => Give\PaymentGateways\Migrations\CopyV2GatewaysSettingsToV3 [add-missing-donor-id-in-donation-comments] => Give\Donations\Migrations\AddMissingDonorIdToDonationComments [set_automatic_formatting_option] => Give\Donations\Migrations\SetAutomaticFormattingOption [move-donation-comment-to-donation-meta-table] => Give\Donations\Migrations\MoveDonationCommentToDonationMetaTable [donors-add-phone-column] => Give\Donors\Migrations\AddPhoneColumn [create_subscription_tables] => Give\Subscriptions\Migrations\CreateSubscriptionTables [add_paymentmode_to_subscription_table] => Give\Subscriptions\Migrations\AddPaymentModeToSubscriptionTable [donation-forms-clean-multiple-slashes-on-db] => Give\DonationForms\Migrations\CleanMultipleSlashesOnDB [donation-forms-remove-duplicate-meta] => Give\DonationForms\Migrations\RemoveDuplicateMeta ) ) [migrationLogFactory:Give\Framework\Migrations\MigrationsRunner:private] => Give\MigrationLog\MigrationLogFactory Object ( ) [migrationLogRepository:Give\Framework\Migrations\MigrationsRunner:private] => Give\MigrationLog\MigrationLogRepository Object ( [migration_table:Give\MigrationLog\MigrationLogRepository:private] => cax_give_migrations [migrationFactory:Give\MigrationLog\MigrationLogRepository:private] => Give\MigrationLog\MigrationLogFactory Object ( ) ) ) [1] => run ) [1] => Array ( [0] => ) ) ) [5] => Array ( [file] => /home/customer/www/mc-care.org/public_html/mccare/wp-includes/class-wp-hook.php [line] => 324 [function] => Give\Helpers\{closure} [class] => Give\Helpers\Hooks [type] => :: [args] => Array ( [0] => ) ) [6] => Array ( [file] => /home/customer/www/mc-care.org/public_html/mccare/wp-includes/class-wp-hook.php [line] => 348 [function] => apply_filters [class] => WP_Hook [type] => -> [args] => Array ( [0] => [1] => Array ( [0] => ) ) ) [7] => Array ( [file] => /home/customer/www/mc-care.org/public_html/mccare/wp-includes/plugin.php [line] => 517 [function] => do_action [class] => WP_Hook [type] => -> [args] => Array ( [0] => Array ( [0] => ) ) ) [8] => Array ( [file] => /home/customer/www/mc-care.org/public_html/mccare/wp-admin/admin-ajax.php [line] => 45 [function] => do_action [args] => Array ( [0] => admin_init ) ) ) [previous:Exception:private] => ))
Please let me know if there’s anything else I can to to help resolve this so we can be back to using the plugin.
Thanks!
Thank you for your response. I must be missing something obvious. I cannot find anywhere to change GiveWP settings. I’ve updated to 4.7. Here are the steps I follow:
Login in to the site Dashboard
Go to Plugins. The Give – Donation Plugin is inactive. There is no place that I see to change settings.
Click “Activate” for the plugin – results in a page with this:
There has been a critical error on this website. Please check your site admin email inbox for instructions. If you continue to have problems, please try the support forums.Where should I be looking for the settings if I can’t activate the plugin?
Viewing 2 replies - 1 through 2 (of 2 total)