• Resolved nziakas78

    (@nziakas78)


    i can’t proceed donation with this module anymore. i see logs and i get this

    { “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 id = ’56′”, “Query Errors”: { “db_delta_error”: [ “Unknown column ‘phone’ in ‘SELECT'” ] } }

    Category:Uncaught database exception

    Source:Give Core

    Date & Time:2025-01-11 07:27:44

    here system report

    WordPress Environment

    Home URL: https://allforblue.org
    Site URL: https://allforblue.org
    WP Version: 6.6.2
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    Permalink Structure: /%year%/%monthnum%/%day%/%postname%/
    Show on Front: page
    Page on Front: HOME (#2920)
    Page for Posts: Unset
    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, wc-pending, wc-processing, wc-on-hold, wc-completed, wc-cancelled, wc-refunded, wc-failed, wc-checkout-draft, refunded, failed, revoked, cancelled, abandoned, processing, preapproval, upgraded Server Environment

    Hosting Provider: DBH: localhost, SRV: allforblue.org
    TLS Connection: Connection uses TLS 1.3
    TLS Connection: Probably Okay
    Server Info: nginx/1.26.2
    PHP Version: 7.4.33
    PHP Post Max Size: 16 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 1000
    PHP Max Upload Size: 16 MB
    cURL Version: 7.61.1, OpenSSL/1.1.1k
    SUHOSIN Installed: –
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    gzip: ?
    GD Graphics Library: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ? GiveWP Configuration

    GiveWP Version: 3.19.4
    GiveWP Cache: Enabled
    Database Updates: All DB Updates Completed.
    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.19.0
    Test Mode: Disabled
    Currency Code: EUR
    Currency Position: Before
    Decimal Separator: .
    Thousands Separator: ,
    Success Page: https://allforblue.org/donation-confirmation/
    Failure Page: https://allforblue.org/donation-failed/
    Donation History Page: https://allforblue.org/donor-dashboard-2/
    GiveWP Forms Slug: /donations/
    Enabled Payment Gateways: PayPal Donations, PayPal Standard
    Default Payment Gateway: PayPal Donations
    PayPal IPN Notifications: IPN received for #17763 ( 7D260519KC2509839 ) on 09/16/2024 at 09:27. Status VERIFIED
    Donor Email Access: Enabled
    Stripe Webhook Notifications: N/A Active GiveWP Add-ons Other Active Plugins

    All 404 Redirect to Homepage: by wp-buy – 4.9
    AutoConvert Greeklish Permalinks: by Dimitris Mavroudis – 4.2.0
    Classic Editor: by WordPress Contributors – 1.6.7
    Classic Widgets: by WordPress Contributors – 0.3
    Contact Form 7: by Takayuki Miyoshi – 6.0.2
    Copy & Delete Posts: by Inisev – 1.4.9
    Disable Comments: by WPDeveloper – 2.4.6
    Dynamic Featured Image: by Ankit Pokhrel – 3.7.0
    Easy WP SMTP: by Easy WP SMTP – 2.9.0
    EWWW Image Optimizer: by Exactly WWW – 8.0.0
    Formidable Forms: by Strategy11 Form Builder Team – 6.16.3
    Formidable Forms Pro: by Strategy11 – 6.9.2
    GDPR Cookie Compliance: by Moove Agency – 4.15.6
    Massive Addons for WPBakery Page Builder: by MassivePixelCreation – 2.3.2
    Payment Plugins for PayPal WooCommerce: by Payment Plugins, [email protected] – 1.0.54
    Pixel Cat Lite: by Fatcat Apps – 3.0.6
    Popup Builder - Create highly converting, mobile friendly marketing popups.: by Looking Forward Software Incorporated. – 4.3.6
    Porto Theme - Functionality: by P-Themes – 2.0.4
    Product Catalog Feed Pro by PixelYourSite: by PixelYourSite – 5.0.0
    Real-Time Find and Replace: by Marios Alexandrou – 4.3
    Really Simple Security: by Really Simple Security – 9.1.4
    Redux Framework: by Team Redux – 4.5.4
    Remove Uppercase Accents: by Giorgos Sarigiannidis – 1.1.1
    Robo Gallery: by RoboSoft – 3.2.23
    Sassy Social Share: by Team Heateor – 3.3.70
    Shortcodes Ultimate: by Vova Anokhin – 7.3.3
    Simple Custom CSS and JS: by SilkyPress.com – 3.49
    Slider Revolution: by ThemePunch – 6.7.20
    Thrive Quiz Builder: by Thrive Themes – 2.3.7.1
    WooCommerce: by Automattic – 9.5.2
    WooCommerce Multilingual & Multicurrency: by OnTheGoSystems – 5.3.9
    Woo Subject Fix: by FOCUS-ON GROUP – 1.0
    Wordfence Security: by Wordfence – 8.0.2
    WPBakery Page Builder: by Michael M - WPBakery.com – 7.9
    WP Fastest Cache: by Emre Vona – 1.3.3
    WPML Media Translation: by OnTheGoSystems – 2.7.5
    WPML Multilingual CMS: by OnTheGoSystems – 4.6.15
    WPML String Translation: by OnTheGoSystems – 3.2.18
    WPS Hide Login: by WPServeur, NicolasKulka, wpformation – 1.9.17.1
    XML Sitemap Generator for Google: by Auctollo – 4.1.21
    Yoast SEO: by Team Yoast – 24.2 Inactive Plugins

    Flexible Checkout Fields: by WP Desk – 4.1.15
    Flexible Shipping: by Octolize – 5.1.2
    HT Easy GA4: by HasThemes – 1.2.7
    Piraeus Bank WooCommerce Payment Gateway: by Papaki – 3.0.1
    Variation Swatches for WooCommerce: by Emran Ahmed – 2.1.3
    WooCommerce Smart COD: by woosmartcod.com – 1.7.2
    WP Downgrade | Specific Core Version: by Reisetiger – 1.2.6 Theme

    Name: Porto
    Version: 6.0.6
    Author URL: https://www.portotheme.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

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Robin Joshua Del Mundo

    (@robindelmundo)

    Hi @nziakas78 ,

    You came to the right place, I’m happy to help you resolve that.

    Thank you for sending those along as well! This helps significantly in diagnosing the issue.

    Checking your system information, I can confirm that you do still have a few database migrations that need to run.

    Could you go through the following steps within GiveWP on your website:

    1. Before taking any steps for troubleshooting or updating, I highly recommend taking a good backup of the site you can confidently restore from. Having a backup of your site is essential to a solid workflow, and will allow you to restore to a previous version of the site if you run into any issues. You can read more about our top recommendations for taking a backup here:?https://givewp.com/backup-for-faster-troubleshooting/.
    2. Enable Advanced Database Updates in Donations → Settings → Advanced.
    3. Next, go to the Donations → Tools → Data page, and re-run any pending/failed updates.
    4. Check the logs at Donations → Tools → Logs for errors. If there are any errors, pass those along here.
    5. Last, navigate back to Donations → Settings → Advanced and disable Advanced Database Updates.

    Thereafter, try to do a test donation to see if it’s working now.

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

    Plugin Support Robin Joshua Del Mundo

    (@robindelmundo)

    Hi @nziakas78 ,

    It’s been a while since we’ve heard back, and I know troubleshooting needs a little extra time. I’m marking this as resolved for now, but if you still have questions, you can send them along right here, and I’ll be happy to hop back in.

    Have a great day!

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