Unable to create DB Tables

  • Resolved squidg

    (@squidg)


    1 month ago

    The below have been created:

    •  wp_give_revenue
    •  wp_give_migrations
    •  wp_give_log

    However, I can’t create:

    •  wp_give_donors
    •  wp_give_donormeta
    •  wp_give_comments
    •  wp_give_commentmeta
    •  wp_give_sessions
    •  wp_give_formmeta
    •  wp_give_sequential_ordering
    •  wp_give_donationmeta

    When I enable debug on WordPress i see:

    WordPress database error: [Table 'opwzyvmy_main.wp_give_donors' doesn't exist]
SELECT wp_give_donors.* FROM wp_give_donors WHERE 1=1 AND wp_give_donors.user_id IN( 11 ) ORDER BY wp_give_donors.id+0 DESC LIMIT 0,20;

WordPress database error: [Table 'opwzyvmy_main.wp_give_donors' doesn't exist]
SELECT wp_give_donors.* FROM wp_give_donors INNER JOIN wp_give_donormeta ON ( wp_give_donors.id = wp_give_donormeta.donor_id ) AND ( ( wp_give_donormeta.meta_key = 'additional_email' AND wp_give_donormeta.meta_value = '11' ) ) WHERE 1=1 ORDER BY wp_give_donors.id+0 DESC LIMIT 0,20;

WordPress database error: [Table 'opwzyvmy_main.wp_give_formmeta' doesn't exist]
SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_give_formmeta ON ( wp_posts.ID = wp_give_formmeta.form_id ) WHERE 1=1 AND ( ( wp_give_formmeta.meta_key = '_give_goal_option' AND wp_give_formmeta.meta_value = 'enabled' ) ) AND wp_posts.post_type = 'give_forms' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC LIMIT 0, 30

    I’m using the latest version of Beaver Builder Theme and it’s hosted on Bluehost.

    When I try to create “Add Missing Transaction Id For Uncompleted Stripe Donations” manually, I get the error:

    Give\Framework\Database\Exceptions\DatabaseQueryException Object
(
    [message:protected] => Database Query
    [string:Exception:private] => 
    [code:protected] => 0
    [file:protected] => /home1/opwzyvmy/public_html/wp-content/plugins/give/src/Framework/Database/DB.php
    [line:protected] => 247
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home1/opwzyvmy/public_html/wp-content/plugins/give/src/Framework/Database/DB.php
                    [line] => 86
                    [function] => runQueryWithErrorChecking
                    [class] => Give\Framework\Database\DB
                    [type] => ::
                    [args] => Array
                        (
                            [0] => Closure Object
                                (
                                    [static] => Array
                                        (
                                            [name] => query
                                            [arguments] => Array
                                                (
                                                    [0] => 
            INSERT INTO wp_give_donationmeta (donation_id, meta_key, meta_value)
            SELECT dm1.donation_id, '_give_payment_transaction_id',SUBSTR( gc.comment_content, 34 ) as transactionId
            FROM wp_give_donationmeta as dm1
                INNER JOIN wp_give_comments as gc on gc.comment_parent = dm1.donation_id
                INNER JOIN wp_posts as p on p.ID = dm1.donation_id
            WHERE NOT EXISTS (
                SELECT *
                FROM wp_give_donationmeta as dm2
                WHERE dm1.donation_id=dm2.donation_id
                    AND meta_key='_give_payment_transaction_id'
                )
                AND p.post_status!='publish'
                AND p.post_date > '2022-02-20'
                AND dm1.meta_key = '_give_payment_gateway'
                AND dm1.meta_value like '%stripe%'
                AND gc.comment_content like '%Stripe Charge/Payment Intent ID%'
                AND SUBSTR( gc.comment_content, 34 ) != ''
            ORDER BY dm1.donation_id DESC
            
                                                )

                                        )

                                )

                        )

                )

            [1] => Array
                (
                    [file] => /home1/opwzyvmy/public_html/wp-content/plugins/give/src/PaymentGateways/Gateways/Stripe/Migrations/AddMissingTransactionIdForUncompletedDonations.php
                    [line] => 49
                    [function] => __callStatic
                    [class] => Give\Framework\Database\DB
                    [type] => ::
                    [args] => Array
                        (
                            [0] => query
                            [1] => Array
                                (
                                    [0] => 
            INSERT INTO wp_give_donationmeta (donation_id, meta_key, meta_value)
            SELECT dm1.donation_id, '_give_payment_transaction_id',SUBSTR( gc.comment_content, 34 ) as transactionId
            FROM wp_give_donationmeta as dm1
                INNER JOIN wp_give_comments as gc on gc.comment_parent = dm1.donation_id
                INNER JOIN wp_posts as p on p.ID = dm1.donation_id
            WHERE NOT EXISTS (
                SELECT *
                FROM wp_give_donationmeta as dm2
                WHERE dm1.donation_id=dm2.donation_id
                    AND meta_key='_give_payment_transaction_id'
                )
                AND p.post_status!='publish'
                AND p.post_date > '2022-02-20'
                AND dm1.meta_key = '_give_payment_gateway'
                AND dm1.meta_value like '%stripe%'
                AND gc.comment_content like '%Stripe Charge/Payment Intent ID%'
                AND SUBSTR( gc.comment_content, 34 ) != ''
            ORDER BY dm1.donation_id DESC
            
                                )

                        )

                )

            [2] => Array
                (
                    [file] => /home1/opwzyvmy/public_html/wp-content/plugins/give/src/API/Endpoints/Migrations/RunMigration.php
                    [line] => 109
                    [function] => run
                    [class] => Give\PaymentGateways\Gateways\Stripe\Migrations\AddMissingTransactionIdForUncompletedDonations
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [3] => Array
                (
                    [file] => /home1/opwzyvmy/public_html/wp-includes/rest-api/class-wp-rest-server.php
                    [line] => 1230
                    [function] => handleRequest
                    [class] => Give\API\Endpoints\Migrations\RunMigration
                    [type] => ->
                    [args] => Array
                        (
                            [0] => WP_REST_Request Object
                                (
                                    [method:protected] => POST
                                    [params:protected] => Array
                                        (
                                            [URL] => Array
                                                (
                                                )

                                            [GET] => Array
                                                (
                                                )

                                            [POST] => Array
                                                (
                                                )

                                            [FILES] => Array
                                                (
                                                )

                                            [JSON] => Array
                                                (
                                                    [id] => add-missing-transaction-id-for-uncompleted-stripe-donations
                                                )

                                            [defaults] => Array
                                                (
                                                )

                                        )

                                    [headers:protected] => Array
                                        (
                                            [accept] => Array
                                                (
                                                    [0] => application/json, text/plain, */*
                                                )

                                            [accept_encoding] => Array
                                                (
                                                    [0] => gzip, br
                                                )

                                            [accept_language] => Array
                                                (
                                                    [0] => en-US,en;q=0.9
                                                )

                                            [connection] => Array
                                                (
                                                    [0] => 
                                                )

                                            [content_type] => Array
                                                (
                                                    [0] => application/json
                                                )

                                            [content_length] => Array
                                                (
                                                    [0] => 68
                                                )

                                            [cookie] => Array
                                                (
                                                    [0] => cookielawinfo-checkbox-necessary=yes; cookielawinfo-checkbox-functional=no; cookielawinfo-checkbox-performance=no; cookielawinfo-checkbox-analytics=no; cookielawinfo-checkbox-advertisement=no; cookielawinfo-checkbox-others=no; CookieLawInfoConsent=eyJuZWNlc3NhcnkiOnRydWUsImZ1bmN0aW9uYWwiOmZhbHNlLCJwZXJmb3JtYW5jZSI6ZmFsc2UsImFuYWx5dGljcyI6ZmFsc2UsImFkdmVydGlzZW1lbnQiOmZhbHNlLCJvdGhlcnMiOmZhbHNlfQ==; viewed_cookie_policy=yes; _ga=GA1.1.1846135016.1716198250; _ga_CFFJK4XDKY=GS1.1.1716198250.1.0.1716198257.0.0.0; wf_loginalerted_ee3975bf7015719c1a02b6688cb9e58b94c952537b4f4ba1ce3f9e03c607460f=8dbeb272a5a34efebe744bbc6eedebaa333100eeaeb43a2e03d53c476b2fe57e; wp-settings-11=editor%3Dtinymce%26libraryContent%3Dbrowse%26hidetb%3D1%26imgsize%3Dfull%26urlbutton%3Dfile%26align%3Dcenter; wp-settings-time-11=1716357084; wfwaf-authcookie-efed3bf82b066cfb0390ad6f976be646=11%7Cadministrator%7Cmanage_options%2Cunfiltered_html%2Cedit_others_posts%2Cupload_files%2Cpublish_posts%2Cedit_posts%2Cread%7C842052f9a9a541b7b694b6cab686afde7ce51757c36f70482e4dc2eeccf15285; wordpress_test_cookie=WP%20Cookie%20check; wordpress_logged_in_73fadc4507e166ae82ef2da4c253207b=peter%7C1716886550%7CgwwzHexWyWQxicunk5nbqkXclUQPUi0JXpbHEcSFYex%7Caa6833e832a42b264b255c816027ddf2b8a007c8162bdee3d03bf602d223f7c2
                                                )

                                            [host] => Array
                                                (
                                                    [0] => my-website.org
                                                )

                                            [referer] => Array
                                                (
                                                    [0] => https://my-website.org/wp-admin/edit.php?post_type=give_forms&page=give-tools&tab=data
                                                )

                                            [user_agent] => Array
                                                (
                                                    [0] => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36
                                                )

                                            [x_forwarded_for] => Array
                                                (
                                                    [0] => 122.150.104.174
                                                )

                                            [cdn_loop] => Array
                                                (
                                                    [0] => cloudflare
                                                )

                                            [cf_ipcountry] => Array
                                                (
                                                    [0] => AU
                                                )

                                            [cf_ray] => Array
                                                (
                                                    [0] => 889cb8933ec4572d-SYD
                                                )

                                            [x_forwarded_proto] => Array
                                                (
                                                    [0] => https
                                                )

                                            [cf_visitor] => Array
                                                (
                                                    [0] => {"scheme":"https"}
                                                )

                                            [sec_ch_ua] => Array
                                                (
                                                    [0] => "Google Chrome";v="125", "Chromium";v="125", "Not.A/Brand";v="24"
                                                )

                                            [sec_ch_ua_mobile] => Array
                                                (
                                                    [0] => ?0
                                                )

                                            [x_wp_nonce] => Array
                                                (
                                                    [0] => 7f2e1775f8
                                                )

                                            [sec_ch_ua_platform] => Array
                                                (
                                                    [0] => "Windows"
                                                )

                                            [origin] => Array
                                                (
                                                    [0] => https://my-website.org
                                                )

                                            [sec_fetch_site] => Array
                                                (
                                                    [0] => same-origin
                                                )

                                            [sec_fetch_mode] => Array
                                                (
                                                    [0] => cors
                                                )

                                            [sec_fetch_dest] => Array
                                                (
                                                    [0] => empty
                                                )

                                            [priority] => Array
                                                (
                                                    [0] => u=1, i
                                                )

                                            [cf_connecting_ip] => Array
                                                (
                                                    [0] => 122.150.104.174
                                                )

                                            [x_real_ip] => Array
                                                (
                                                    [0] => 122.150.104.174
                                                )

                                            [x_eig_origin] => Array
                                                (
                                                    [0] => 162.241.217.24
                                                )

                                            [x_https] => Array
                                                (
                                                    [0] => 1
                                                )

                                            [authorization] => Array
                                                (
                                                    [0] => 
                                                )

                                        )

                                    [body:protected] => {"id":"add-missing-transaction-id-for-uncompleted-stripe-donations"}
                                    [route:protected] => /give-api/v2/migrations/run-migration
                                    [attributes:protected] => Array
                                        (
                                            [methods] => Array
                                                (
                                                    [POST] => 1
                                                )

                                            [accept_json] => 
                                            [accept_raw] => 
                                            [show_in_index] => 1
                                            [args] => Array
                                                (
                                                    [id] => Array
                                                        (
                                                            [validate_callback] => Closure Object
                                                                (
                                                                    [this] => Give\API\Endpoints\Migrations\RunMigration Object
                                                                        (
                                                                            [endpoint:protected] => migrations/run-migration
                                                                            [migrationRegister:Give\API\Endpoints\Migrations\RunMigration: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
                                                                                            [donation-forms-donation-levels-schema] => Give\DonationForms\Migrations\UpdateDonationLevelsSchema
                                                                                        )

                                                                                )

                                                                            [migrationLogFactory:Give\API\Endpoints\Migrations\RunMigration:private] => Give\MigrationLog\MigrationLogFactory Object
                                                                                (
                                                                                )

                                                                        )

                                                                    [parameter] => Array
                                                                        (
                                                                            [$param] => <required>
                                                                        )

                                                                )

                                                        )

                                                )

                                            [callback] => Array
                                                (
                                                    [0] => Give\API\Endpoints\Migrations\RunMigration Object
                                                        (
                                                            [endpoint:protected] => migrations/run-migration
                                                            [migrationRegister:Give\API\Endpoints\Migrations\RunMigration: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
                                                                            [donation-forms-donation-levels-schema] => Give\DonationForms\Migrations\UpdateDonationLevelsSchema
                                                                        )

                                                                )

                                                            [migrationLogFactory:Give\API\Endpoints\Migrations\RunMigration:private] => Give\MigrationLog\MigrationLogFactory Object
                                                                (
                                                                )

                                                        )

                                                    [1] => handleRequest
                                                )

                                            [permission_callback] => Array
                                                (
                                                    [0] => Give\API\Endpoints\Migrations\RunMigration Object
                                                        (
                                                            [endpoint:protected] => migrations/run-migration
                                                            [migrationRegister:Give\API\Endpoints\Migrations\RunMigration: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
                                                                            [donation-forms-donation-levels-schema] => Give\DonationForms\Migrations\UpdateDonationLevelsSchema
                                                                        )

                                                                )

                                                            [migrationLogFactory:Give\API\Endpoints\Migrations\RunMigration:private] => Give\MigrationLog\MigrationLogFactory Object
                                                                (
                                                                )

                                                        )

                                                    [1] => permissionsCheck
                                                )

                                        )

                                    [parsed_json:protected] => 1
                                    [parsed_body:protected] => 
                                )

                        )

                )

            [4] => Array
                (
                    [file] => /home1/opwzyvmy/public_html/wp-includes/rest-api/class-wp-rest-server.php
                    [line] => 1063
                    [function] => respond_to_request
                    [class] => WP_REST_Server
                    [type] => ->
                    [args] => Array
                        (
                            [0] => WP_REST_Request Object
                                (
                                    [method:protected] => POST
                                    [params:protected] => Array
                                        (
                                            [URL] => Array
                                                (
                                                )

                                            [GET] => Array
                                                (
                                                )

                                            [POST] => Array
                                                (
                                                )

                                            [FILES] => Array
                                                (
                                                )

                                            [JSON] => Array
                                                (
                                                    [id] => add-missing-transaction-id-for-uncompleted-stripe-donations
                                                )

                                            [defaults] => Array
                                                (
                                                )

                                        )

                                    [headers:protected] => Array
                                        (
                                            [accept] => Array
                                                (
                                                    [0] => application/json, text/plain, */*
                                                )

                                            [accept_encoding] => Array
                                                (
                                                    [0] => gzip, br
                                                )

                                            [accept_language] => Array
                                                (
                                                    [0] => en-US,en;q=0.9
                                                )

                                            [connection] => Array
                                                (
                                                    [0] => 
                                                )

                                            [content_type] => Array
                                                (
                                                    [0] => application/json
                                                )

                                            [content_length] => Array
                                                (
                                                    [0] => 68
                                                )

                                            [cookie] => Array
                                                (
                                                    [0] => cookielawinfo-checkbox-necessary=yes; cookielawinfo-checkbox-functional=no; cookielawinfo-checkbox-performance=no; cookielawinfo-checkbox-analytics=no; cookielawinfo-checkbox-advertisement=no; cookielawinfo-checkbox-others=no; CookieLawInfoConsent=eyJuZWNlc3NhcnkiOnRydWUsImZ1bmN0aW9uYWwiOmZhbHNlLCJwZXJmb3JtYW5jZSI6ZmFsc2UsImFuYWx5dGljcyI6ZmFsc2UsImFkdmVydGlzZW1lbnQiOmZhbHNlLCJvdGhlcnMiOmZhbHNlfQ==; viewed_cookie_policy=yes; _ga=GA1.1.1846135016.1716198250; _ga_CFFJK4XDKY=GS1.1.1716198250.1.0.1716198257.0.0.0; wf_loginalerted_ee3975bf7015719c1a02b6688cb9e58b94c952537b4f4ba1ce3f9e03c607460f=8dbeb272a5a34efebe744bbc6eedebaa333100eeaeb43a2e03d53c476b2fe57e; wp-settings-11=editor%3Dtinymce%26libraryContent%3Dbrowse%26hidetb%3D1%26imgsize%3Dfull%26urlbutton%3Dfile%26align%3Dcenter; wp-settings-time-11=1716357084; wfwaf-authcookie-efed3bf82b066cfb0390ad6f976be646=11%7Cadministrator%7Cmanage_options%2Cunfiltered_html%2Cedit_others_posts%2Cupload_files%2Cpublish_posts%2Cedit_posts%2Cread%7C842052f9a9a541b7b694b6cab686afde7ce51757c36f70482e4dc2eeccf15285; wordpress_test_cookie=WP%20Cookie%20check; wordpress_logged_in_73fadc4507e166ae82ef2da4c253207b=peter%7C1716886550%7CgwwzHexWyWQxicunk5nbqkXclUQPUi0JXpbHEcSFYex%7Caa6833e832a42b264b255c816027ddf2b8a007c8162bdee3d03bf602d223f7c2
                                                )

                                            [host] => Array
                                                (
                                                    [0] => my-website.org
                                                )

                                            [referer] => Array
                                                (
                                                    [0] => https://my-website.org/wp-admin/edit.php?post_type=give_forms&page=give-tools&tab=data
                                                )

                                            [user_agent] => Array
                                                (
                                                    [0] => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36
                                                )

                                            [x_forwarded_for] => Array
                                                (
                                                    [0] => 122.150.104.174
                                                )

                                            [cdn_loop] => Array
                                                (
                                                    [0] => cloudflare
                                                )

                                            [cf_ipcountry] => Array
                                                (
                                                    [0] => AU
                                                )

                                            [cf_ray] => Array
                                                (
                                                    [0] => 889cb8933ec4572d-SYD
                                                )

                                            [x_forwarded_proto] => Array
                                                (
                                                    [0] => https
                                                )

                                            [cf_visitor] => Array
                                                (
                                                    [0] => {"scheme":"https"}
                                                )

                                            [sec_ch_ua] => Array
                                                (
                                                    [0] => "Google Chrome";v="125", "Chromium";v="125", "Not.A/Brand";v="24"
                                                )

                                            [sec_ch_ua_mobile] => Array
                                                (
                                                    [0] => ?0
                                                )

                                            [x_wp_nonce] => Array
                                                (
                                                    [0] => 7f2e1775f8
                                                )

                                            [sec_ch_ua_platform] => Array
                                                (
                                                    [0] => "Windows"
                                                )

                                            [origin] => Array
                                                (
                                                    [0] => https://my-website.org
                                                )

                                            [sec_fetch_site] => Array
                                                (
                                                    [0] => same-origin
                                                )

                                            [sec_fetch_mode] => Array
                                                (
                                                    [0] => cors
                                                )

                                            [sec_fetch_dest] => Array
                                                (
                                                    [0] => empty
                                                )

                                            [priority] => Array
                                                (
                                                    [0] => u=1, i
                                                )

                                            [cf_connecting_ip] => Array
                                                (
                                                    [0] => 122.150.104.174
                                                )

                                            [x_real_ip] => Array
                                                (
                                                    [0] => 122.150.104.174
                                                )

                                            [x_eig_origin] => Array
                                                (
                                                    [0] => 162.241.217.24
                                                )

                                            [x_https] => Array
                                                (
                                                    [0] => 1
                                                )

                                            [authorization] => Array
                                                (
                                                    [0] => 
                                                )

                                        )

                                    [body:protected] => {"id":"add-missing-transaction-id-for-uncompleted-stripe-donations"}
                                    [route:protected] => /give-api/v2/migrations/run-migration
                                    [attributes:protected] => Array
                                        (
                                            [methods] => Array
                                                (
                                                    [POST] => 1
                                                )

                                            [accept_json] => 
                                            [accept_raw] => 
                                            [show_in_index] => 1
                                            [args] => Array
                                                (
                                                    [id] => Array
                                                        (
                                                            [validate_callback] => Closure Object
                                                                (
                                                                    [this] => Give\API\Endpoints\Migrations\RunMigration Object
                                                                        (
                                                                            [endpoint:protected] => migrations/run-migration
                                                                            [migrationRegister:Give\API\Endpoints\Migrations\RunMigration: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
                                                                                            [donation-forms-donation-levels-schema] => Give\DonationForms\Migrations\UpdateDonationLevelsSchema
                                                                                        )

                                                                                )

                                                                            [migrationLogFactory:Give\API\Endpoints\Migrations\RunMigration:private] => Give\MigrationLog\MigrationLogFactory Object
                                                                                (
                                                                                )

                                                                        )

                                                                    [parameter] => Array
                                                                        (
                                                                            [$param] => <required>
                                                                        )

                                                                )

                                                        )

                                                )

                                            [callback] => Array
                                                (
                                                    [0] => Give\API\Endpoints\Migrations\RunMigration Object
                                                        (
                                                            [endpoint:protected] => migrations/run-migration
                                                            [migrationRegister:Give\API\Endpoints\Migrations\RunMigration: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
                                                                            [donation-forms-donation-levels-schema] => Give\DonationForms\Migrations\UpdateDonationLevelsSchema
                                                                        )

                                                                )

                                                            [migrationLogFactory:Give\API\Endpoints\Migrations\RunMigration:private] => Give\MigrationLog\MigrationLogFactory Object
                                                                (
                                                                )

                                                        )

                                                    [1] => handleRequest
                                                )

                                            [permission_callback] => Array
                                                (
                                                    [0] => Give\API\Endpoints\Migrations\RunMigration Object
                                                        (
                                                            [endpoint:protected] => migrations/run-migration
                                                            [migrationRegister:Give\API\Endpoints\Migrations\RunMigration: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
    • This topic was modified 1 month ago by squidg.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Matheus Martins

    (@matheusfd)

    1 month ago

    Hi, @squidg.

    I’m glad you reached out. I can certainly help you.

    Did this issue happen after you used GiveWP for a while or it happened when you tried to install GiveWP for the first time?

    Looking forward to helping you get to the bottom of this!

    Thread Starter squidg

    (@squidg)

    1 month ago

    Installing for the first time.

    Thread Starter squidg

    (@squidg)

    1 month ago

    Has any progress be made on this? I would rather use this plugin than another if possible…

    Plugin Support Matheus Martins

    (@matheusfd)

    2 weeks, 4 days ago

    Hi, @squidg.

    This might have something to do with the privileges your database user has that is preventing some tables from being created. Putting myself in your shoes, I’d remove GiveWP completely and then install it back.

    Looking forward to helping you get to the bottom of this!

    Thread Starter squidg

    (@squidg)

    2 weeks, 4 days ago

    The user has full priviledges to the database and every other plugin works fine except for this one. Also when i try to uninstall it, it doesn’t work. I need to go though file manage delete the plugin folder and then into phpmyadmin and delete the tables that it was able to create. Reinstalling it doesn’t fix the issue.

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.