GIVE can’t update the database because AJAX is not functioning

+1 on this issue.

My hosting company is FlyWheel. They have given my account access to admin-ajax.php. I have cleared site and browser caches, and yet I still see the message:
“Give needs to upgrade the database but cannot because AJAX is not functioning properly. Please contact your host and ask them to ensure admin-ajax.php is accessible.”

I am testing this plugin out for possible use with a fundraiser happening soon. Any ideas of fixes to try are most welcome.

@humanfrequencies @kikilin – Hey guys, sorry to hear about the trouble with the update. The AJAX function that we use to test whether it’s available or not is here: https://github.com/WordImpress/Give/blob/master/includes/ajax-functions.php#L27

This function should be reviewed accurately testing if admin-ajax is working on your server and is accessible to run the updates. However, it appears that your hosts are saying it’s accessible and this is throwing a false positive.

I would hope that the host would then refer to this function and point out how it’s incompatible with their system. Do you guys have any specifics from their support on how this function could be returning false in their environments?

As well, if you guys go under WP-Admin > Donations > Tools what does the “Admin AJAX” value say?

@kikilin
Can you check your access.log?
I set up a dummy website on the flywheel and I am seeing that my ajax request blocked.

175.100.170.248 - flywheel [23/Jan/2018:04:46:45 +0000] "GET https://givetestdemo.flywheelsites.com/wp-admin/admin-ajax.php?action=give_test_ajax HTTP/1.1" 400 1 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36" givetestdemo.flywheelsites.com miss fwhash:1w2y17y2py VISIT

I just sent the support team of my hosting provider the reply, thanks so much for helping us.

And, my ADMIN AJAX says it is: INACCESSIBLE.

@DevinWalker – My Admin AJAX: Inaccessible
I’ve passed on your message to Flywheel support.

@humanfrequencies – Thanks for going as far as creating a dummy site on Flywheel. Yesterday folks at Flywheel created a rule in Nginx so that my account could access admin-ajax.php, though the warning message continues to show. Can you tell me how to find the access.log on Flywheel? Does it require shell access? I’ve also passed on your message to the support team there.

Hi, a client has the same problem (I’m the host in this case).

Tools->Admin AJAX: inaccessible.

But the request isn’t even sent, I checked Developer Tools – nothing in Network tab (except the native WordPress admin-ajax.php after 60 seconds, returning HTTP 200) and nothing in Console tab (where “request blocked” entries sometimes appear).

Obviously nothing in access log, because the request isn’t being sent.

Access-Control-Allow-Origin: * header has been added (confirmed in Developer Tools)

Give 2.0.0, WordPress 4.9.2,

I was liking all of the plugin’s abilities, but after my site host tried to help with this AJAX issue by adding a Nginx conf, I kept experiencing extremely slow page loads (ave 1 minute!) or 504 Time Out messages. I’ve decided to abandon my try-out of the Give plugin for now and move on to other options.

HI folks,

We’ve got these issues pretty much resolved in version 2.0.1 which will be released VERY soon today.

Please udpate and if you have additional issues after that please create a NEW ticket (new tickets get better undivided attention).

We stand behind our work both with our code and our support. You won’t be sorry for sticking with Give. 2.0.1 and onwards will impress you for sure.

Thanks!

@webdevmattcrom – That is fantastic news. Thanks for keeping us informed.

Yes, we’ve heard back already from many users that 2.0.1 resolved their update issues completely.

There’s always gotchas in WordPress though, so if you have problems, please create a NEW ticket here with as much detail as you can provide for us.

Thanks!

It’s not working for me on 2.0.4, and I had to roll back to the last 1.9 release because the nonprofit’s yearly fundraiser is in one week and the plugin has been broken since I updated plugins last. Users were getting a message about no access to admin-ajax.php when they tried to donate (Sorry, I don’t have the specific message, I just found that you had a support forum here).

Tools page says it’s inaccessible, but I don’t see why. It’s running on my own server (Mac OS Server 5.2 on OS 10.11)

No weird cross-domain calls going on, but I enabled Access-Control-Allow-Origin * anyway, not that it helped. I backed up everything and put in the code to force the site to think ajax works, but it just sits there and spins. If I stop it, for a fraction of a second I get a message like XMLHttpRequest cannot load due to access control checks. I never see any attempts to connect outside the box, just admin-ajax continually getting called.

I disabled every plugin except give, deleted all .htaccess files — nothing.

I’m hoping the downgrade will work (I was able to donate a dollar but I didn’t check across browser or anything) til the fundraising events, but any advice you can offer on resolving the issue for real afterwards would be much appreciated.

Thanks!

Next time you try 2.0+, see if this plugin helps you: https://f.gdr.name/fix-wpgive-ajax.zip – it implements the last section of https://givewp.com/documentation/core/frequent-troubleshooting-issues/admin-ajax-blocked/ (“AJAX is Definitely Working on My Site”)

Be sure to try all the other solutions from the documentation first, though