• Resolved Dorgman

    (@dorgman)


    Hello – I’m having problems with our donation pages. I created 40 individual pages, one for each animal in The Sanctuary, but I am receiving critical errors when making donations. I have activated test donations, tried removing all other payment gateways, deactivated all other plugins inc. security, cleared cache and still the same error:

    Can anyone help me out here? Thank you.

    Error Details

    An error of type E_ERROR was caused in line 155 of the file /home/u539594664/domains/llamasanctuary.com/public_html/wp-content/plugins/give/src/Framework/Support/ValueObjects/Money.php. Error message: Uncaught TypeError: Argument 2 passed to Give\Framework\Support\ValueObjects\Money::fromDecimal() must be of the type string, null given, called in /home/u539594664/domains/llamasanctuary.com/public_html/wp-content/plugins/give/src/Donations/DataTransferObjects/DonationQueryData.php on line 143 and defined in /home/u539594664/domains/llamasanctuary.com/public_html/wp-content/plugins/give/src/Framework/Support/ValueObjects/Money.php:155
    Stack trace:

    0 /home/u539594664/domains/llamasanctuary.com/public_html/wp-content/plugins/give/src/Donations/DataTransferObjects/DonationQueryData.php(143): Give\Framework\Support\ValueObjects\Money::fromDecimal(NULL, NULL)

    1 /home/u539594664/domains/llamasanctuary.com/public_html/wp-content/plugins/give/src/Donations/Models/Donation.php(274): Give\Donations\DataTransferObjects\DonationQueryData::fromObject(Object(stdClass))

    2 /home/u539594664/domains/llamasanctuary.com/public_html/wp-content/plugins/give/src/Framework/Models/ModelQueryBuilder.php(111): Give\Donations\Models

    and this is one of the errors logged in the Database:

    {“message”:”Database Query”,”context”:{“Query”:”INSERT INTO wp_give_revenue (donation_id, form_id, amount) VALUES (8181, 8009, 10000)”,”Query Errors”:{“db_delta_error”:[“Table ‘u539594664_migration1.wp_give_revenue’ doesn’t exist”]}}}

    • This topic was modified 1 year, 9 months ago by Dorgman.

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hi @dorgman,
    Glad you reached out. I’ll need a little more information to get started here:

    First, send along your system information. You can do this by navigating to Donations > Tools > System Info (tab) and click the button to “Get System Report” and copy/paste that in your reply here.

    The error you sent along looks like you may be missing the wp_give_revenue table. Your system information should help me confirm this, but I have some steps to get that square away that should help:

    GiveWP updates databases in order to provide new features right now and for the future, but some hosting companies prevent these upgrades from being completed correctly.

    1. First, I always recommend taking a backup of the site that you can confidently restore from. Here’s an article we wrote that explains more clearly how to do that: https://givewp.com/backup-for-faster-troubleshooting/
    2. Next, enable Advanced Database Updates in Donations > Settings > Advanced.
    3. Next, run the update in Donations -> Tools -> Data, and based on the Run Order columns, re-run the create_revenue_table update. If you notice any pending updates, run them as well.
    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.

    Give this a look and let me know how things go. If you run into any issues or have any questions, I’m here to help!

    Thread Starter Dorgman

    (@dorgman)

    Greetings Stephanieliy – thank you for your assistance. Last night I tried doing a fresh install of the plugin using Filezilla (renaming the old version, just in case anything went wrong) Nothing changed, so I deleted the old version and kept the new install.

    To begin with here is the system report:

    WordPress Environment
    
    Home URL: https://llamasanctuary.com
    Site URL: https://llamasanctuary.com
    WP Version: 6.1.1
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    Permalink Structure: /%postname%/
    Show on Front: page
    Page on Front: Home (#2614)
    Page for Posts: Llama Sanctuary Magazine (#2643)
    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 Server Environment Hosting Provider: DBH: localhost, SRV: llamasanctuary.com
    TLS Connection: Connection uses TLS 1.3
    TLS Connection: Probably Okay
    Server Info: LiteSpeed
    PHP Version: 7.4.32
    PHP Post Max Size: 512 MB
    PHP Time Limit: 240
    PHP Max Input Vars: 5000
    PHP Max Upload Size: 512 MB
    cURL Version: 7.71.0, OpenSSL/1.1.1d
    SUHOSIN Installed: –
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    gzip: ?
    GD Graphics Library: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ? GiveWP Configuration GiveWP Version: 2.25.0
    GiveWP Cache: Enabled
    Database Updates: All DB Updates Completed.
    Database Updates: All Database Migrations Completed.
    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: 2.25.0
    Test Mode: Disabled
    Currency Code: CAD
    Currency Position: Before
    Decimal Separator: .
    Thousands Separator: ,
    Success Page: https://llamasanctuary.com/donation-confirmation/
    Failure Page: https://llamasanctuary.com/transaction-failed/
    Donation History Page: https://llamasanctuary.com/donor-dashboard/
    GiveWP Forms Slug: /donations/
    Enabled Payment Gateways: Test Donation, Offline Donation, Stripe - Credit Card, Stripe - Checkout, PayPal Standard
    Default Payment Gateway: Stripe - Credit Card
    PayPal IPN Notifications: IPN received for #5675 ( 2EU44209FK2072607 ) on 12/25/2019 at 07:34. Status VERIFIED
    Donor Email Access: Disabled
    Stripe Webhook Notifications: N/A Active GiveWP Add-ons Other Active Plugins Additional Variation Images Gallery for WooCommerce: by Emran Ahmed – 1.3.13
    Canada Post Shipping For WooCommerce: by Small Fish Analytics Inc. – 2.9.11
    Classic Editor: by WordPress Contributors – 1.6.2
    Complete Central Backup: by Dash10 Digital – 2.1.3
    Contact Form 7: by Takayuki Miyoshi – 5.7.4
    Contact Form 7 Extension For Mailchimp: by Renzo Johnson – 0.5.64
    Divi Shortcode Enabler: by Divi Booster – 1.3.7
    eCards: by Ciprian Popescu – 4.0.5
    Elegant Themes Updater: by Elegant Themes – 1.2
    Facebook Likes You!: by Piotr Sochalewski – 1.5.4
    Heartbeat Control by WP Rocket: by WP Rocket – 2.0
    PeachPay Checkout and Payments for WooCommerce: Stripe, PayPal, Square: by PeachPay, Inc. – 1.87.2
    Supreme Modules Lite - Divi Theme, Extra Theme and Divi Builder: by Supreme Modules – 2.4.2
    WooCommerce: by Automattic – 7.4.0
    Wordfence Security: by Wordfence – 7.9.0 Inactive Plugins Better Find and Replace: by CodeSolz – 1.4.6
    Broken Link Checker: by WPMU DEV – 1.11.21
    Event Booking Pro: by Moe Haydar – 3.99
    EventON: by AshanJay – 3.0.2
    Google Listings and Ads: by WooCommerce – 2.0.1
    Jetpack: by Automattic – 11.8.4
    LiteSpeed Cache: by LiteSpeed Technologies – 5.3.3
    MailPoet: by MailPoet – 4.7.0
    Newsletter: by Stefano Lissa & The Newsletter Team – 7.5.9
    WP Simple Shopping cart: by Tips and Tricks HQ, Ruhul Amin, mra13 – 4.6.3 Theme Name: Divi
    Version: 4.5.6
    Author URL: https://www.elegantthemes.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
    Thread Starter Dorgman

    (@dorgman)

    Hi Stephanieliy – I just followed the other steps you suggested for Advanced Database Updates. I then cleared cache and ran another test donation and this time it worked!

    There were quite a number of errors in the log from all the previous test donations and other people trying to donate. The errors were all similar:

    {     "Query": "\n\t\t\tSELECT DISTINCT r.form_id\n\t\t\tFROM wp_give_revenue as r\n\t\t\t\tINNER JOIN wp_give_donationmeta as dm ON r.donation_id = dm.donation_id\n\t\t\tWHERE dm.meta_key='_give_payment_mode'\n\t\t\t\tAND dm.meta_value='live'\n\t\t\t",     "Query Errors": {         "db_delta_error": [             "Table 'u539594664_migration1.wp_give_revenue' doesn't exist"         ]     } }
    I will try out a few more tests, but it looks like your database updates did the trick. Thank you!

    Hi @dorgman,
    This is great news! I’ll mark this as resolved for now, but if you bump into any more trouble you can pop me a message right here and I’ll give things another look. Happy Fundraising!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘There has been a critical error on this website’ is closed to new replies.