error with checkout
-
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 ThemeThe page I need help with: [log in to see the link]
- You must be logged in to reply to this topic.