Fatal error: Uncaught Database\QueryException

  • Resolved peppermintcom

    (@peppermintcom)


    3 years, 5 months ago

    I encounter the same problem as another WP member here, when I try to test the payment gateway with “test donation” or any other way to pay, this is the message I get

    Fatal error: Uncaught Give\Framework\Database\Exceptions\DatabaseQueryException: Query failed in database in /home/francelih/www/site/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php:32 Stack trace: #0 /home/francelih/www/site/wp-content/plugins/give/src/Framework/Database/DB.php(122): Give\Framework\Database\Exceptions\DatabaseQueryException::create(Array) #1 /home/francelih/www/site/wp-content/plugins/give/src/Framework/Database/DB.php(81): Give\Framework\Database\DB::runQueryWithErrorChecking(Object(Closure)) #2 /home/francelih/www/site/wp-content/plugins/give/src/Revenue/Repositories/Revenue.php(43): Give\Framework\Database\DB::__callStatic('insert', Array) #3 /home/francelih/www/site/wp-content/plugins/give/src/Revenue/DonationHandler.php(29): Give\Revenue\Repositories\Revenue->insert(Array) #4 [internal function]: Give\Revenue\DonationHandler->handle(22671) #5 /home/francelih/www/site/wp-content/plugins/give/src/Helpers/Hooks.php(37): call_user_func_array(Array, Array) #6 /home/fr in /home/francelih/www/site/wp-content/plugins/give/src/Framework/Database/Exceptions/DatabaseQueryException.php on line 32

    I tried to enable database update but I get immediately the same message, with no possibility to change anything.

    Here is the system information :

    ### WordPress Environment ###

Home URL: https://www.france-libre.net
Site URL: https://www.france-libre.net/site
WP Version: 5.8.1
WP Multisite: –
WP Memory Limit: 512 Mo
WP Debug Mode: ?
WP Cron: ?
Language: fr_FR
Permalink Structure: /%postname%/
Show on Front: page
Page on Front: Accueil (#19723)
Page for Posts: Blog (#6428)
Table Prefix Length: wffl_
Table Prefix Length: 5
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, refunded, failed, revoked, cancelled, abandoned, processing, preapproval, tribe-ea-success, tribe-ea-failed, tribe-ea-schedule, tribe-ea-pending, tribe-ea-draft, tribe-ignored

### Server Environment ###

Hosting Provider: DBH: francelihdb2.mysql.db, SRV: www.france-libre.net
TLS Connection: Connexion utilisé TLS 1.3
TLS Connection: Probably Okay
Server Info: Apache
PHP Version: 7.4.21
PHP Post Max Size: 130 Mo
PHP Time Limit: 165
PHP Max Input Vars: 16000
PHP Max Upload Size: 128 Mo
cURL Version: 7.64.0, OpenSSL/1.1.1d
SUHOSIN Installed: –
MySQL Version: 5.6.50
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
gzip: ?
GD Graphics Library: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### GiveWP Configuration ###

GiveWP Version: 2.14.0
GiveWP Cache: Activé
Database Updates: Toutes les mises à jours de la base de données sont terminéees.
Database Updates: All Database Migrations Completed.
Database Tables: ? wffl_give_donors? wffl_give_donormeta? wffl_give_comments? wffl_give_commentmeta? wffl_give_sessions? wffl_give_formmeta? wffl_give_sequential_ordering? wffl_give_donationmeta? wffl_give_revenue
GiveWP Cache: Activé
GiveWP Cache: ?Nouveau don?Re?u de dons?Nouveau don hors-ligne?Instructions pour le don hors ligne?Enregistrement d’un nouvel utilisateur?Information d'enregistrement de l'utilisateur?Commentaire sur le don?Accès aux mails
Upgraded From: 2.13.4
Test Mode: Désactivé
Currency Code: EUR
Currency Position: Après
Decimal Separator: ,
Thousands Separator: .
Success Page: https://www.france-libre.net/donation-confirmation-4/
Failure Page: https://www.france-libre.net/donation-failed-4/
Donation History Page: https://www.france-libre.net/donor-dashboard-3/
GiveWP Forms Slug: /donations/
Enabled Payment Gateways: Don de Test, Stripe - Carte de crédit, Stripe - Checkout, Stripe - SEPA Direct Debit, Don hors ligne
Default Payment Gateway: Don de Test
PayPal IPN Verification: Activé
PayPal IPN Notifications: N/A
Donor Email Access: Activé
Stripe Webhook Notifications: N/A

### Active GiveWP Add-ons ###

Give - PDF Receipts: ? Autorisé – par GiveWP – 2.3.12

### Other Active Plugins ###

Akismet Anti-Spam: par Automattic – 4.2
Broken Link Checker: par WPMU DEV – 1.11.16
Compact Audio Player: par Tips and Tricks HQ – 1.9.7
Contact Form 7: par Takayuki Miyoshi – 5.4.2
Envato Market: par Envato – 2.0.6
GDPR Cookie Consent: par WebToffee – 2.0.6
Google Analytics for WordPress by MonsterInsights: par MonsterInsights – 8.1.0
Groppe Core: par VictorThemes – 2.6.1
Inscription Newsletter Opt-in pour SendBlaster et WordPress: par Max – 1.1.6
iThemes Security: par iThemes – 8.0.2
MC4WP: Mailchimp for WordPress: par ibericode – 4.8.6
One Click Demo Import: par OCDI – 3.0.2
Really Simple CAPTCHA: par Takayuki Miyoshi – 2.1
Recent Tweets Widget: par Noah Kagan – 1.6.8
Slider Revolution: par ThemePunch – 6.5.8
The Events Calendar: par The Events Calendar – 5.9.1
WooCommerce: par Automattic – 5.7.1
WooCommerce Monetico Gateway: par Nicolas Maillard – 2.1.3
WooCommerce Quantity Increment: par Automattic, WooThemes – 1.1.0
WooCommerce Weight Based Shipping: par weightbasedshipping.com – 5.3.15
WordPress Importer: par wordpressdotorg – 0.7
WP-PageNavi: par Lester 'GaMerZ' Chan – 2.94.0
WPBakery Page Builder: par Michael M - WPBakery.com – 6.7.0

### Inactive Plugins ###

Classic Editor: par WordPress Contributors – 1.6.2
FG Joomla to WordPress Premium: par Frédéric GILLES – 1.32.0

### Theme ###

Name: Groppe
Version: 2.8
Author URL: https://victorthemes.com/
Child Theme: Non – Si vous modifiez Give sur un thème parent que vous n’avez pas personnellement créé, nous vous recommandons d’utiliser un thème enfant. Voir Comment créer un thème enfant

    I tried to reach you via your support platform but your support form is not running correctly, the message is never sent…

    PLease help me, this is an urgent request for one of my customer
    Thanks in advance !

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

Viewing 1 replies (of 1 total)
  • Plugin Support Matheus Martins

    (@matheusfd)

    Hey @peppermintcom,

    ?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 prevented the upgrade from being completed correctly.

    To fix it, 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.
    5. 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!

    You are a paid customer and want to talk to us via priority support, please drop us a message here https://givewp.com/contact-us/, select the I am responding to a request to contact you option and add a link to this ticket and I’ll help you.

Viewing 1 replies (of 1 total)
  • The topic ‘Fatal error: Uncaught Database\QueryException’ is closed to new replies.