• Resolved arndtk

    (@arndtk)


    Hello, I have been using the plugin for a long time and am very satisfied with it, thanks for that!

    Unfortunately, I now suddenly have the problem that I can no longer use Give because it keeps producing a critical error.
    When I try to call up the forms or even when I try to create a new form, I get the error.

    The error also appears on the pages on which I have integrated Give. I have now removed it from there for the time being.

    What could be the reason? Could someone take a look at the problem?

    Thanks and best regards
    Arndt

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support alexwcoleman

    (@alexwcoleman)

    Hello!

    Glad you reached out. Happy to help!

    Some additional information will help figure out a plan of action ??. Can you provide the PHP error that was generated? If you don’t know how to get to the PHP error logs you can ask your host where to find the PHP error logs on the server, then copy/paste or attach the relevant error in your reply.

    Also, please send along your System Info.

    Navigate to Donations >> Tools >> System Info (tab) and click the button to “Get System Report” and copy/paste that in your reply here. Here’s a screencast of how to get System Info: https://screencast-o-matic.com/watch/c3eD0gVFgnc

    That will give me additional more context to be able to help.

    Looking forward to getting to the bottom of this – have a good day!

    Thread Starter arndtk

    (@arndtk)

    Hi and sorry for my late reply!

    Here’s my error log:

    [20-Mar-2024 07:27:51 UTC] WordPress database error Table 'usr_p285924_5.wp_give_formmeta' doesn't exist for query
    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
    made by require_once('wp-admin/admin.php'), do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Give_Shortcode_Generator->init, Give_Shortcode_Generator->get_fields, Give_Shortcode_Generator->generate_fields, Give_Shortcode_Generator->generate_post, get_posts, WP_Query->query, WP_Query->get_posts
    [20-Mar-2024 07:27:51 UTC] WordPress database error Table 'usr_p285924_5.wp_give_formmeta' doesn't exist for query SELECT DISTINCT ID AS id, post_title AS title, post_date AS createdAt, post_modified AS updatedAt, post_status AS status, give_formmeta_attach_meta_formEarnings.meta_value AS formEarnings, give_formmeta_attach_meta_formSales.meta_value AS formSales, give_formmeta_attach_meta_donationLevels.meta_value AS donationLevels, give_formmeta_attach_meta_setPrice.meta_value AS setPrice, give_formmeta_attach_meta_priceOption.meta_value AS priceOption, give_formmeta_attach_meta_goalOption.meta_value AS goalOption FROM wp_posts LEFT JOIN wp_give_formmeta give_formmeta_attach_meta_formEarnings ON ID = give_formmeta_attach_meta_formEarnings.form_id AND give_formmeta_attach_meta_formEarnings.meta_key = '_give_form_earnings' LEFT JOIN wp_give_formmeta give_formmeta_attach_meta_formSales ON ID = give_formmeta_attach_meta_formSales.form_id AND give_formmeta_attach_meta_formSales.meta_key = '_give_form_sales' LEFT JOIN wp_give_formmeta give_formmeta_attach_meta_donationLevels ON ID = give_formmeta_attach_meta_donationLevels.form_id AND give_formmeta_attach_meta_donationLevels.meta_key = '_give_donation_levels' LEFT JOIN wp_give_formmeta give_formmeta_attach_meta_setPrice ON ID = give_formmeta_attach_meta_setPrice.form_id AND give_formmeta_attach_meta_setPrice.meta_key = '_give_set_price' LEFT JOIN wp_give_formmeta give_formmeta_attach_meta_priceOption ON ID = give_formmeta_attach_meta_priceOption.form_id AND give_formmeta_attach_meta_priceOption.meta_key = '_give_price_option' LEFT JOIN wp_give_formmeta give_formmeta_attach_meta_goalOption ON ID = give_formmeta_attach_meta_goalOption.form_id AND give_formmeta_attach_meta_goalOption.meta_key = '_give_goal_option' WHERE post_type = 'give_forms' AND post_status IN ('publish','draft','pending','private','upgraded') ORDER BY id DESC LIMIT 30 made by require_once('wp-admin/admin.php'), require_once('wp-admin/admin-header.php'), do_action('admin_enqueue_scripts'), WP_Hook->do_action, WP_Hook->apply_filters, Give\Helpers\Hooks::Give\Helpers{closure}, call_user_func_array, Give\DonationForms\V2\DonationFormsAdminPage->loadScripts, Give\DonationForms\V2\DonationFormsAdminPage->preloadDonationForms, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Give\DonationForms\V2\Endpoints\ListDonationForms->handleRequest, Give\DonationForms\V2\Endpoints\ListDonationForms->getForms, Give\Framework\Models\ModelQueryBuilder->getAll, Give\Framework\Database\DB::__callStatic, Give\Framework\Database\DB::runQueryWithErrorChecking, Give\Framework\Database\DB::Give\Framework\Database{closure}, call_user_func_array
    [20-Mar-2024 07:27:51 UTC] PHP Fatal error: Uncaught Give\Framework\Database\Exceptions\DatabaseQueryException: Database Query in /html/wild_park_2024/wp-content/plugins/give/src/Framework/Database/DB.php:247
    Stack trace: 0 /html/wild_park_2024/wp-content/plugins/give/src/Framework/Database/DB.php(86): Give\Framework\Database\DB::runQueryWithErrorChecking(Object(Closure)) 1 /html/wild_park_2024/wp-content/plugins/give/src/Framework/Models/ModelQueryBuilder.php(100): Give\Framework\Database\DB::__callStatic('…', Array) 2 /html/wild_park_2024/wp-content/plugins/give/src/DonationForms/V2/Endpoints/ListDonationForms.php(174): Give\Framework\Models\ModelQueryBuilder->getAll() 3 /html/wild_park_2024/wp-content/plugins/give/src/DonationForms/V2/Endpoints/ListDonationForms.php(122): Give\DonationForms\V2\Endpoints\ListDonationForms->getForms() 4 /html/wild_park_2024/wp-includes/rest-api/class-wp-rest-server.php(1193): Give\DonationForms\V2\Endpoints\ListDonationForms->handleRequest(Object(WP_REST_Request)) 5 /html/wild_park_2024/wp-includes/rest-api/class-wp-rest-server.php(1041): WP_REST_Server->respond_to_request(Object(WP_REST_Request), '…', Array, NULL) 6 /html/wild_park_2024/wp-includes/rest-api.php(551): WP_REST_Server->dispatch(Object(WP_REST_Request)) 7 /html/wild_park_2024/wp-content/plugins/give/src/DonationForms/V2/DonationFormsAdminPage.php(184): rest_do_request(Object(WP_REST_Request)) 8 /html/wild_park_2024/wp-content/plugins/give/src/DonationForms/V2/DonationFormsAdminPage.php(100): Give\DonationForms\V2\DonationFormsAdminPage->preloadDonationForms() 9 [internal function]: Give\DonationForms\V2\DonationFormsAdminPage->loadScripts('…') 10 /html/wild_park_2024/wp-content/plugins/give/src/Helpers/Hooks.php(43): call_user_func_array(Array, Array) 11 /html/wild_park_2024/wp-includes/class-wp-hook.php(324): Give\Helpers\Hooks::Give\Helpers{closure}('…') 12 /html/wild_park_2024/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(NULL, Array) 13 /html/wild_park_2024/wp-includes/plugin.php(517): WP_Hook->do_action(Array) 14 /html/wild_park_2024/wp-admin/admin-header.php(118): do_action('…', '…') 15 /html/wild_park_2024/wp-admin/admin.php(239): require_once('…') 16 /html/wild_park_2024/wp-admin/edit.php(10): require_once('…') 17 {main} thrown in /html/wild_park_2024/wp-content/plugins/give/src/Framework/Database/DB.php on line 247
    [20-Mar-2024 07:27:55 UTC] WordPress database error Table 'usr_p285924_5.wp_give_formmeta' doesn't exist for query
    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
    made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Give_Shortcode_Generator->init, Give_Shortcode_Generator->get_fields, Give_Shortcode_Generator->generate_fields, Give_Shortcode_Generator->generate_post, get_posts, WP_Query->query, WP_Query->get_posts
    Thread Starter arndtk

    (@arndtk)

    And system info:

    WordPress Environment
    
    Home URL: https://www.wildpark-lev.de
    Site URL: https://www.wildpark-lev.de
    WP Version: 6.4.3
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: de_DE
    Permalink Structure: /%postname%/
    Show on Front: page
    Page on Front: Home (#7)
    Page for Posts: Nicht festgelegt
    Table Prefix Length: wp_
    Table Prefix Length: 3
    Table Prefix Status: Acceptable
    Admin AJAX: Nicht zugreifbar
    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
    
    TLS Connection: Verbindung verwendet TLS 1.3
    TLS Connection: Probably Okay
    Server Info: Apache
    PHP Version: 8.3.3
    PHP Post Max Size: 32 MB
    PHP Time Limit: 240
    PHP Max Input Vars: 1500
    PHP Max Upload Size: 32 MB
    cURL Version: 7.88.1, OpenSSL/3.0.11
    SUHOSIN Installed: –
    MySQL Version: 8.0.25
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    gzip: ?
    GD Graphics Library: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ? GiveWP Configuration
    
    GiveWP Version: 3.6.0
    GiveWP Cache: Aktiviert
    Database Updates: Alle Datenbank-Updates erfolgreich abgeschlossen.
    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: Aktiviert
    GiveWP Cache: ?Neue Spende?Spendenquittung?Donation Processing Receipt?Neue Offline-Spende?Anweisung für überweisungen?Neue Benutzerregistrierung?Informationen zur Benutzerregistrierung?Donation Note?E-Mail-Zugang
    Upgraded From: 3.5.1
    Test Mode: Deaktiviert
    Currency Code: EUR
    Currency Position: Nachher
    Decimal Separator: .
    Thousands Separator: ,
    Success Page: https://www.wildpark-lev.de/spenden-bestatigung/
    Failure Page: https://www.wildpark-lev.de/spende-gescheitert/
    Donation History Page: https://www.wildpark-lev.de/spendenverlauf/
    GiveWP Forms Slug: /donations/
    Enabled Payment Gateways: überweisung
    Default Payment Gateway: überweisung
    
    
    Plugin Support alexwcoleman

    (@alexwcoleman)

    Hi! Thanks for the information. I can see from the site’s System Info that a few database tables are missing – any table preceded with a red X means the table is missing.

    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/

    The error you sent sounds like there are donations with a missing donation form and possibly a missing donor as well. Usually those are old donations (but not exclusively ??). The best way to check for them is to view the list of donations in Legacy View and start at the oldest donations and move forward. A missing form will be listed as Untitled and the donor will say “no donor” or “donor missing”.

    The Legacy View button is in the top right-hand corner of the page where you view donations at Donations >> Donations. Then, navigate to the oldest page and move forward. The easiest course of action here is to delete those donations. Deleting those donations should get rid of that error.

    For the missing database tables I’d like you to uninstall GiveWP (make sure to take a backup first, but also choose not to delete any GiveWP data.

    Please keep us updated here. Have a good day!


    Thread Starter arndtk

    (@arndtk)

    Hi Alex,

    thanks for your reply. I have done it as you described, but I still get the critical error when calling up the forms. ??

    Here’s my latest report. Some of the tables are still missing …

    WordPress Environment
    
    Home URL: https://www.wildpark-lev.de
    Site URL: https://www.wildpark-lev.de
    WP Version: 6.4.3
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: de_DE
    Permalink Structure: /%postname%/
    Show on Front: page
    Page on Front: Home (#7)
    Page for Posts: Nicht festgelegt
    Table Prefix Length: wp_
    Table Prefix Length: 3
    Table Prefix Status: Acceptable
    Admin AJAX: Nicht zugreifbar
    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: db002004.mydbserver.com, SRV: www.wildpark-lev.de
    TLS Connection: Verbindung verwendet TLS 1.3
    TLS Connection: Probably Okay
    Server Info: Apache
    PHP Version: 8.3.3
    PHP Post Max Size: 32 MB
    PHP Time Limit: 240
    PHP Max Input Vars: 1500
    PHP Max Upload Size: 32 MB
    cURL Version: 7.88.1, OpenSSL/3.0.11
    SUHOSIN Installed: –
    MySQL Version: 8.0.25
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    gzip: ?
    GD Graphics Library: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ? GiveWP Configuration GiveWP Version: 3.6.1
    GiveWP Cache: Aktiviert
    Database Updates: Alle Datenbank-Updates erfolgreich abgeschlossen.
    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: Aktiviert
    GiveWP Cache: ?Neue Spende?Spendenquittung?Donation Processing Receipt?Neue Offline-Spende?Anweisung für überweisungen?Neue Benutzerregistrierung?Informationen zur Benutzerregistrierung?Donation Note?E-Mail-Zugang
    Upgraded From: 3.6.0
    Test Mode: Deaktiviert
    Currency Code: EUR
    Currency Position: Nachher
    Decimal Separator: .
    Thousands Separator: ,
    Success Page: https://www.wildpark-lev.de/spenden-bestatigung/
    Failure Page: https://www.wildpark-lev.de/spende-gescheitert/
    Donation History Page: https://www.wildpark-lev.de/spendenverlauf/
    GiveWP Forms Slug: /donations/
    Enabled Payment Gateways: überweisung
    Default Payment Gateway: überweisung
    PayPal IPN Notifications: N/A
    Donor Email Access: Aktiviert
    Stripe Webhook Notifications: N/A Active GiveWP Add-ons Other Active Plugins Bloom: von Elegant Themes – 1.3.12
    Disable Comments: von WPDeveloper – 2.4.5
    Divi Bars: von Divi Life — Tim Strifler – 1.8.9
    Divi Blog Extras: von Elicus – 2.6.6
    Divi MadMenu: von Ivan Chiurcci – 1.9.11
    Divi Modal Popup: von Elicus – 1.1.0
    Divi Next Dual Button: von Divi Next – 2.2
    Divi Plus: von Elicus – 1.11.0
    Email Address Encoder: von Till Krüss – 1.0.23
    eRecht24 legal texts for WordPress: von eRecht24, Weslink GmbH – 3.3.10
    Flexible Checkout Fields: von WP Desk – 4.1.4
    FooEvents Bookings: von FooEvents – 1.7.2
    FooEvents for WooCommerce: von FooEvents – 1.19.0
    FooEvents PDF Tickets: von FooEvents – 1.10.1
    German Market: von MarketPress – 3.35.1
    Gravity Divi - Gravity Forms Styler for Divi: von Divi Codex – 2.1.0
    Gravity Forms: von Gravity Forms – 2.8.5
    Loco Translate: von Tim Whitlock – 2.6.6
    Login/Signup Popup: von XootiX – 2.6.2
    Login/Signup Popup - Custom Fields Add-on: von XootiX – 1.0
    MainWP Child: von MainWP – 5.0
    Multi-Step Checkout Pro for WooCommerce: von SilkyPress – 2.36
    NinjaFirewall (WP Edition): von The Ninja Technologies Network – 4.5.11
    OMGF: von Daan from Daan.dev – 5.8.3
    OMGF Pro: von Daan from Daan.dev – 3.10.1
    Post SMTP: von Post SMTP – 2.8.11
    Real Cookie Banner: von devowl.io – 4.6.1
    ShortPixel Image Optimizer: von ShortPixel - Convert WebP/AVIF & Optimize Images – 5.5.5
    Simple Divi Shortcode: von Fabrice ESQUIROL - Creaweb2b – 1.2
    Sofort Banking for WooCommerce: von Sven Wagener – 1.4.5
    StoreCustomizer: von Kaira – 2.5.5
    UpdraftPlus - Backup/Restore: von UpdraftPlus.Com, DavidAnderson – 1.24.1
    WooCommerce: von Automattic – 8.6.1
    WooCommerce Min/Max Quantities: von WooCommerce – 2.4.20
    Woocommerce Side Cart Premium: von XootiX – 3.1
    WP Armour - Honeypot Anti Spam: von Dnesscarkey – 2.1.18
    WP Armour Extended - Honeypot Anti Spam: von Dnesscarkey – 1.26
    WP Rocket: von WP Media – 3.15.9
    Yoast SEO: von Team Yoast – 22.2 Inactive Plugins FooEvents Custom Attendee Fields: von FooEvents – 1.7.0 Active MU Plugins NinjaFirewall WP (mu-plugin): von The Ninja Technologies Network – 1.0 Theme Name: Divi-Mastermind-Child-Theme
    Version: 1.0.0
    Author URL: https://divimastermind.com/
    Child Theme: Ja
    Parent Theme Name: Divi
    Parent Theme Version: 4.24.2
    Parent Theme Author URL: https://www.elegantthemes.com
    Thread Starter arndtk

    (@arndtk)

    Hi.

    Any chance to check it again? That would be great.

    Thanks and regards
    Arndt

    Plugin Support Matheus Martins

    (@matheusfd)

    Hi, @arndtk.

    We would like to dig deeper to understand what is happening. Can you reach out to us via our contact form at https://givewp.com/contact-us/? Use the option that says “I am responding to a request to contact you.” Provide the link to this thread as context, your system info, etc. and we will happily help you.

    I’m marking it as resolved here, and when a fix is provided, I’ll update this post.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Critical error’ is closed to new replies.