Hi guys,

Thanks for your wonderful plugin.

I am getting from the last updates a strange error when donating. So far, it all worked nicely, and I haven’t changed plugins nor theme. I already tried deactivating all plugins and switching to default theme but without success.

The error screen I get is this one (typical Fatal Error WP screen):

• https://ibb.co/dK5b7J1

This is the error on the WP log error file I get:

[12-Jun-2024 10:59:10 UTC] PHP Fatal error: Uncaught RuntimeException: Unable to claim actions. Database error: Unknown column 'priority' in 'order clause'. in /var/www/www.progua.com/ROOT/wp-content/plugins/give/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:942
Stack trace: 0 /var/www/www.progua.com/ROOT/wp-content/plugins/give/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(799): ActionScheduler_DBStore->claim_actions() 1 /var/www/www.progua.com/ROOT/wp-content/plugins/give/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(221): ActionScheduler_DBStore->stake_claim() 2 /var/www/www.progua.com/ROOT/wp-content/plugins/give/vendor/woocommerce/action-scheduler/classes/ActionScheduler_QueueRunner.php(160): ActionScheduler_HybridStore->stake_claim() 3 /var/www/www.progua.com/ROOT/wp-content/plugins/give/vendor/woocommerce/action-scheduler/classes/ActionScheduler_QueueRunner.php(139): ActionScheduler_QueueRunner->do_batch() 4 /var/www/www.progua.com/ROOT/wp-includes/class-wp-hook.php(324): ActionScheduler_QueueRunner->run() 5 /var/www/www.progua.com/ROOT/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() 6 /var/www/www.progua.com/ROOT/wp-includes/plugin.php(565): WP_Hook->do_action() 7 /var/www/www.progua.com/ROOT/wp-cron.php(191): do_action_ref_array() 8 {main}

thrown in /var/www/www.progua.com/ROOT/wp-content/plugins/give/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 942

By its side, on Give own log error system, this is what I got:

Description:
Database Query
Category:
Uncaught database exception
Source:
Núcleo de Give
Date & Time:
2024-06-12 11:03:08
Error details:

{
    "Query": "SELECT id, user_id AS userId, email, phone, name, purchase_value AS totalAmountDonated, purchase_count AS totalNumberOfDonations, payment_ids AS paymentIds, date_created AS createdAt, token, verify_key AS verifyKey, verify_throttle AS verifyThrottle, give_donormeta_attach_meta_firstName.meta_value AS firstName, give_donormeta_attach_meta_lastName.meta_value AS lastName, give_donormeta_attach_meta_prefix.meta_value AS prefix FROM wp_give_donors LEFT JOIN wp_give_donormeta give_donormeta_attach_meta_firstName ON ID = give_donormeta_attach_meta_firstName.donor_id AND give_donormeta_attach_meta_firstName.meta_key = '_give_donor_first_name' LEFT JOIN wp_give_donormeta give_donormeta_attach_meta_lastName ON ID = give_donormeta_attach_meta_lastName.donor_id AND give_donormeta_attach_meta_lastName.meta_key = '_give_donor_last_name' LEFT JOIN wp_give_donormeta give_donormeta_attach_meta_prefix ON ID = give_donormeta_attach_meta_prefix.donor_id AND give_donormeta_attach_meta_prefix.meta_key = '_give_donor_title_prefix' WHERE user_id = '1'",
    "Query Errors": {
        "db_delta_error": [
            "Unknown column 'phone' in 'field list'"
        ]
    }
}

It says “Database Error” so I tried to update the database tables.

I went to Tools and updated the database tables, all went fine except this one…:

• https://ibb.co/52g537w
• https://ibb.co/9tdQxKv

…and that one:

• https://ibb.co/fYQ1SFP
• https://ibb.co/8ddPdFx

I also seem to have problems when retrieving Donors from the admin area:

• https://ibb.co/cFmQKTm

By its side, again, Give’s own Error Log system tells me this:

Description:
Database Query
Category:
Uncaught database exception
Source:
Give Core
Date & Time:
2024-06-12 10:55:15
Error details:

{
    "Query": "SELECT id, user_id AS userId, email, phone, name, purchase_value AS totalAmountDonated, purchase_count AS totalNumberOfDonations, payment_ids AS paymentIds, date_created AS createdAt, token, verify_key AS verifyKey, verify_throttle AS verifyThrottle, give_donormeta_attach_meta_firstName.meta_value AS firstName, give_donormeta_attach_meta_lastName.meta_value AS lastName, give_donormeta_attach_meta_prefix.meta_value AS prefix FROM wp_give_donors LEFT JOIN wp_give_donormeta give_donormeta_attach_meta_firstName ON ID = give_donormeta_attach_meta_firstName.donor_id AND give_donormeta_attach_meta_firstName.meta_key = '_give_donor_first_name' LEFT JOIN wp_give_donormeta give_donormeta_attach_meta_lastName ON ID = give_donormeta_attach_meta_lastName.donor_id AND give_donormeta_attach_meta_lastName.meta_key = '_give_donor_last_name' LEFT JOIN wp_give_donormeta give_donormeta_attach_meta_prefix ON ID = give_donormeta_attach_meta_prefix.donor_id AND give_donormeta_attach_meta_prefix.meta_key = '_give_donor_title_prefix' ORDER BY id DESC LIMIT 30",
    "Query Errors": {
        "db_delta_error": [
            "Unknown column 'phone' in 'field list'"
        ]
    }
}

What should I try next??

I am lost. Thanks.

Between, this is my System Info:

### WordPress Environment ###

Home URL: https://www.progua.com
Site URL: https://www.progua.com
WP Version: 6.5.3
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: ✔
WP Cron: ✔
Language: en_US
Permalink Structure: /%year%/%monthnum%/%day%/%postname%/
Show on Front: page
Page on Front: Home (#346)
Page for Posts: Shop (#6)
Table Prefix Length: wp_
Table Prefix Length: 3
Table Prefix Status: Acceptable
Admin AJAX: Accessible
Registered Post Statuses: publish, future, draft, pending, private, trash, auto-draft, inherit, request-pending, request-confirmed, request-failed, request-completed, in-progress, failed, flamingo-spam, refunded, revoked, cancelled, abandoned, processing, preapproval, upgraded

### Server Environment ###

Hosting Provider: DBH: localhost, SRV: www.progua.com
TLS Connection: Connection uses TLS 1.3
TLS Connection: Probably Okay
Server Info: Apache/2.4.59 (Debian)
PHP Version: 8.2.20
PHP Post Max Size: 512 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
PHP Max Upload Size: 512 MB
cURL Version: 7.88.1, OpenSSL/3.0.11
SUHOSIN Installed: –
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ❌Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ✔
gzip: ✔
GD Graphics Library: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### GiveWP Configuration ###

GiveWP Version: 3.12.1
GiveWP Cache: Enabled
Database Updates: 2 of 33 updates still need to run.
Database Updates: Few Database Migrations still need to run.
Database Tables: ✔ 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✔ wp_give_revenue✔ wp_give_migrations✔ wp_give_log
GiveWP Cache: Enabled
GiveWP Cache: ✔New Donation✔Donation Receipt✔Donation Processing Receipt❌New Offline Donation❌Offline Donation Instructions✔New User Registration✔User Registration Information✔Donation Note✔Email access
Upgraded From: 3.12.0
Test Mode: Disabled
Currency Code: EUR
Currency Position: Before
Decimal Separator: .
Thousands Separator: ,
Success Page: https://www.progua.com/donation-confirmation/
Failure Page: https://www.progua.com/donation-failed/
Donation History Page: https://www.progua.com/donor-dashboard-37/
GiveWP Forms Slug: /donations/
Enabled Payment Gateways: PayPal Standard
Default Payment Gateway: PayPal Standard
PayPal IPN Notifications: IPN received for #13572 ( 3L3968959V234135V ) on 05/22/2023 at 15:29. Status VERIFIED
Donor Email Access: Enabled
Stripe Webhook Notifications: N/A

### Active GiveWP Add-ons ###


### Other Active Plugins ###

Contact Form 7: by Takayuki Miyoshi – 5.9.5
Contact Form 7 Multilingual: by OnTheGoSystems – 1.2.2
Disable Gutenberg: by Jeff Starr – 3.1.1
Envato Market: by Envato – 2.0.11
Flamingo: by Takayuki Miyoshi – 2.5
LayerSlider WP: by Kreatura Media – 6.7.6
One Click SSL: by Tribulant Software – 1.4.9
Qode Instagram Widget: by Qode Themes – 1.2.1
Qode Twitter Feed: by Qode Themes – 1.1
Slider Revolution: by ThemePunch – 6.6.19
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com, DavidAnderson – 1.24.3
WPBakery Page Builder: by Michael M - WPBakery.com – 6.4.1
WP File Manager: by mndpsingh287 – 7.2.8
WPML CMS Nav: by OnTheGoSystems – 1.5.5
WPML Media Translation: by OnTheGoSystems – 2.7.4
WPML Multilingual CMS: by OnTheGoSystems – 4.6.11
WPML String Translation: by OnTheGoSystems – 3.2.12
Yoast SEO: by Team Yoast – 22.8

### Inactive Plugins ###

Mailchimp for WooCommerce: by Mailchimp – 4.0.2
MailChimp for WordPress Multilingual: by OnTheGoSystems – 0.0.3
Wordfence Security: by Wordfence – 7.11.5

### Theme ###

Name: Bridge
Version: 17.1
Author URL: http://www.qodethemes.com/
Child Theme: No – If you're modifying GiveWP on a parent theme you didn't build personally, then we recommend using a child theme. See: How to Create a Child Theme