Support » Plugin: GiveWP - Donation Plugin and Fundraising Platform » Error when updating GIVEwp database

  • Resolved becreativezone

    (@becreativezone)


    [An error of type E_ERROR was caused in line 32 of the file..]
    The site does not appear to be broken nor the page with the WPGIVE form. https://becreative.zone/donate But the back office WPadmin panel says the plugin update is still going…. 0% updated, with a PAUSE button. How do I stop this update? I think when I paused it, that action might have caused the fatal error. But it looks to be still updating.

    A message from my hosting….

    Since WordPress 5.2 there is a built-in feature that detects when a plugin or theme causes a fatal error on your site, and notifies you with this automated email.

    In this case, WordPress caught an error with one of your plugins, Give – Donation Plugin.

    When seeking help with this issue, you may be asked for some of the following information:
    WordPress version 5.6.2
    Current theme: Divi (version 4.8.2)
    Current plugin: Give - Donation Plugin (version 2.10.1) PHP version 7.3.27
    
    Error Details
    =============
    An error of type E_ERROR was caused in line 32 of the file /homepages/11/d659860083/htdocs/clickandbuilds/BeCreativeZone/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php. Error message: Uncaught Give\Framework\Database\Exceptions\DatabaseQueryException: Query failed in database in /homepages/11/d659860083/htdocs/clickandbuilds/BeCreativeZone/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php:32
    Stack trace:
    #0 /homepages/11/d659860083/htdocs/clickandbuilds/BeCreativeZone/wp-content/plugins/give/src/Framework/Database/DB.php(122): Give\Framework\Database\Exceptions\DatabaseQueryException::create(Array)
    #1 /homepages/11/d659860083/htdocs/clickandbuilds/BeCreativeZone/wp-content/plugins/give/src/Framework/Database/DB.php(81): Give\Framework\Database\DB::runQueryWithErrorChecking(Object(Closure))
    #2 /homepages/11/d659860083/htdocs/clickandbuilds/BeCreativeZone/wp-content/plugins/give/src/Log/LogRepository.php(51): Give\Framework\Database\DB::__callStatic('insert', Array)
    #3 /homepages/11/d659860083/htdocs/clickandbuilds/BeCreativeZone/wp-content/plugins/give/src/Log/LogModel.php(238): Give\Log\LogRepository->insertLog(Object(Give\Log\LogModel))
    #4 /homepages/11/

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • I am having the same problem with the database stalling at 0%.

    Any further ideas?

    Plugin Support Matheus Martins

    (@matheusfd)

    Hey @becreativezone,

    Glad you reached out. I can help you with that.

    For a bit of context, the latest GiveWP update included some database upgrades in order to provide new features right now and for the future, but some hosts running an outdated version of MySQL prevented the upgrade from being completed correctly.

    The first thing you need to check right now is your MySQL version (or MariaDB version, depending on the server you are using). You need to contact your host ask and them to update your MySQL version to 5.7 or later, otherwise, GiveWP will not be able to create the needed database tables.

    After that, do the following:
    1. First, I’d 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.
    4. Last, navigate back to Donations > Settings > Advanced and disable Advanced Database Updates.

    Please let us know if you have further questions on this or need any additional assistance!

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