Give Version 2.0.2 Database breaks when running the DB update

Having the same problem :/

@astreetweb @dedlobster Sorry to hear about the issues you are having with the upgrade routines. Where are you guys hosting at? As well, do you have the Recurring Donations add-on installed alongside Give Core? If so, which version?

The site is hosted at hostmonster. No Give addons installed..
### Server Environment ###

Hosting Provider: DBH: localhost, SRV: https://www.musicamatrix.org
TLS Connection: Connection uses TLS 1.2
TLS Connection: Bad
Server Info: Apache
PHP Version: 5.6.32
PHP Post Max Size: 64 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
PHP Max Upload Size: 64 MB
cURL Version: ? 7.24.0, OpenSSL/1.0.0 – We recommend a minimum cURL version of 7.40.
SUHOSIN Installed: –
MySQL Version: 5.6.32
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
gzip: ?
GD Graphics Library: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Give Configuration ###

Give Version: 2.0.2
Give Cache: Enabled
Database Updates: 11 of 22 updates still need to run.
Give Cache: Enabled
Give Cache: ?New Donation?Donation Receipt?New Offline Donation?Offline Donation Instructions?New User Registration?User Registration Information?Email access
Upgraded From: –
Test Mode: Disabled
Currency Code: USD
Currency Position: After
Decimal Separator: .
Thousands Separator: ,
Success Page: –
Failure Page: –
Donation History Page: –
Give Forms Slug: /donations/
Enabled Payment Gateways: –
Default Payment Gateway: –
PayPal IPN Verification: Disabled
PayPal IPN Notifications: N/A
Donor Email Access: Disabled
### Session Configuration ###

Give Use Sessions: Enabled
Session: Enabled
Session Name: PHPSESSID
Cookie Path: /
Save Path: /tmp
Use Cookies: Enabled
Use Only Cookies: Enabled

### Active Give Add-ons ###

### Other Active Plugins ###

All In One SEO Pack: by Michael Torbert – 2.4.4.1
Compact Audio Player: by Tips and Tricks HQ – 1.9.6
Events Made Easy: by Franky Van Liedekerke – 2.0.18
Fast Secure Contact Form: by fastsecure – 4.0.56
Features: by WooThemes – 1.5.0
Imsanity: by Shane Bishop – 2.3.9
iThemes Security: by iThemes – 6.8.1
MainWP Child: by MainWP – 3.4.5
Quick Page/Post Redirect Plugin: by anadnet – 5.1.8
TinyMCE Advanced: by Andrew Ozz – 4.6.7
W3 Total Cache: by Frederick Townes – 0.9.6
Widget Logic: by wpchefgadget, alanft – 5.9.0
WooCommerce Helper: by WooCommerce – 1.7.2
WP Mailto Links – Manage Email Links: by Victor Villaverde Laan – 2.1.7
WP Responsive Recent Post Slider: by WP Online Support – 1.3.4

### Inactive Plugins ###

Password Protected: by Ben Huson – 2.1
Quick Paypal Payments: by aerin – 5.5.2
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.0.2
WP Featherlight: by WP Site Care – 1.2.0
WP Mail SMTP: by WPForms – 1.2.4

@astreetweb – W3TC can potentially be having issues with our upgrade process. Have you tried deactivating that and running the upgrade? If that doesn’t help can you contact us and make a mention that you’re working with me on WP.org? We can work out the issue together outside this public forum: https://givewp.com/contact-us/ select “You asked me to contact you” option.

I have a WordPress multisite instance and the DB Upgrade process kept saying that admin-ajax wasn’t working, which was not true because I could test is manually. I did the whole bypass admin-ajax check and now it’s stuck at 0% and isn’t updating. I activated on one of the other sites on the install and was prompted with the same update database notice. When I attempt to run the updater on the other site I get a notice that I’m not authorized, which doesn’t make any sense given that I’m logged into the additional site with an admin account. I’m basically at the point where I think I have to go to the database itself and manually delete everything. Even the Setting that says to delete everything when the plugin is disabled doesn’t work.

I’m hosted on SiteGround and I have not caching plugins even active at this point. I was using SiteGround’s optimization plugin but I found out recently that it isn’t even compatible with WordPress multisite.

I believe we resolved this in a different thread. Closing for now, but feel free to comment again if there’s still unfinished business. Thanks!