Givewp: [Give 1.8.18] Getting Database error when verify the email.

[emgk]

Issue Overview

Getting WP Database error when I trying to view/access my donation using the URL sent within the donation receipt email.

WordPress database error: [Unknown column 'verify_key' in 'field list']
UPDATE wp_give_customers SET verify_key = 'zQkVhNft2wRQqFBQDED0', verify_throttle = '2017-12-20 11:29:45' WHERE id = 1 LIMIT 1

I have created video on this please check http://www.screencast.com/t/1AtKZMq6jg

Steps to Reproduce (for bugs)

1. Create Donation and send the receipt.
2. Open the payment link from receipt email in Incognito mode to access donation.
3. Put donation's email and click on "Verify Email" button.
4. You will get "Email Confirmation" email click on "View your donation history »" in incognito mode you will get the same error again.

Todos

• [ ] Tests
• [ ] Documentation

WordPress Environment

### WordPress Environment ###

Home URL: http://wpgive18.test
Site URL: http://wpgive18.test
WP Version: 4.9.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: ✔
WP Cron: ✔
Language: en_US
Permalink Structure: /%year%/%monthnum%/%day%/%postname%/
Show on Front: posts
Table Prefix Length: 3
Table Prefix Status: Acceptable
Admin AJAX: Inaccessible
Registered Post Statuses: publish, future, draft, pending, private, trash, auto-draft, inherit, refunded, failed, revoked, cancelled, abandoned, processing, preapproval

### Server Environment ###

Hosting Provider: DBH: localhost, SRV: wpgive18.test
TLS Connection: Connection uses TLS 1.2
TLS Connection: Probably Okay
Server Info: nginx/1.10.1
PHP Version: ❌ 5.3.29 - We recommend a minimum PHP version of 5.6. See: PHP Requirements in Give
PHP Post Max Size: 1,000 MB
PHP Time Limit: 900
PHP Max Input Vars: 3000
PHP Max Upload Size: 1,000 MB
cURL Version: ❌ 7.38.0, OpenSSL/1.0.2h - We recommend a minimum cURL version of 7.40.
SUHOSIN Installed: –
MySQL Version: ❌ 5.5.55 - We recommend a minimum MySQL version of 5.6. See: WordPress Requirements
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
gzip: ✔
GD Graphics Library: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Give Configuration ###

Give Version: 1.8.18
Database Updates: All DB Updates Completed.
Upgraded From: 2.0.0
Test Mode: Enabled
Currency Code: USD
Currency Position: Before
Decimal Separator: .
Thousands Separator: ,
Success Page: http://wpgive18.test/donation-confirmation/
Failure Page: http://wpgive18.test/donation-failed/
Donation History Page: http://wpgive18.test/donation-history/
Give Forms Slug: /donations/
Enabled Payment Gateways: Test Donation, Offline Donation
Default Payment Gateway: Test Donation
PayPal IPN Verification: Enabled
PayPal IPN Notifications: N/A
Admin Email Notifications: Disabled
Donor Email Access: Enabled

### Session Configuration ###

Give Use Sessions: Enabled
Session: Disabled

### Active Give Add-ons ###


### Other Active Plugins ###


### Inactive Plugins ###

Give - Recurring Donations: by WordImpress – 1.5

### Theme ###

Name: Twenty Seventeen
Version: 1.4
Author URL: https://wordpress.org/
Child Theme: No – If you're modifying Give on a parent theme you didn't build personally, then we recommend using a child theme. See: How to Create a Child Theme

[mehul0810]

@DevinWalker @ravinderk I've investigated this issue and this issue seems to be a very rare case to me. I can reproduce it in fresh install and then when a donor is created after performing a donation and the donation receipt session is expired. After that, if donor tried to access donation receipt via email access then only the issue is reproduced.

However, I would suggest to fix it early.

Please check the video for more information: https://drive.google.com/open?id=1yCZD6dxocwIssxkp5DdJFqZgc0-M1L6B

[DevinWalker]

I agree with you @mehul0810 - it's a rare case but also better we fix it quickly now rather than let it wait until 2.0. Thanks for the quick PR. I'm going to release it today.