Access Code Does Not Submit

Hello, exactly the same problem as the person above. The plugin worked just fine two weeks ago when i integrated a test google drive. But now I can’t get to connect my production google drive for the reasons above mentionned by @Igcline.

Thank you for you support on this matter.

If it may help to pinpoint the reason for the bug. I used an older version of the plugin in my development environnement. When I migrated to my production environnement, I updated the plugin and tried to change the access code to my production google drive and it was then that I noticed that the access code would be processed non stop (infinite loop with no error trace or success message just spinning). I tried deactivating, deleting and reinstalling the plugin ver 1.6 many times hoping that the new feature in 1.6 (delete all data on uninstall would help) but nothing.

I also have the same issue. The access code doesn’t save. On further debugging it shows the admin-ajax.php 500 Internal Server Error. But admin-ajax is working for rest of the plugins and site. Please advise.

in debug view the error shown is “24 May 2017 05:11:40 PHP 5.4.45 Error fetching OAuth2 access token, message: ‘invalid_grant’ :: 400 “

Update – I have the same admin-ajax.php 500 Internal Server Error when pressing the save button.

Hi,
Sorry for the delay in responding,

I noticed, there is no issue on our development server, it works fine and gives the success message while authorizing with google.

Suggest you to please try using another browser like firefox, IE and try using another google account too, and refer the following

For your invalid grant issue refer ( https://blog.timekit.io/google-oauth-invalid-grant-nightmare-and-how-to-fix-it-9f4efaf1da35 )

Refer point #2 on the above link
Now go to this file
cf7-google-sheets-connector\lib\php-google-oauth\auth\Google_OAuth2.php
line number 33 and replace “offline” to “online” and test.

Hope this helps. Let us know !

Thanks
Abdullah

Thanks for looking into this.
I think I’ve found the problem on my end at least. My domain is being forwarded and Google does not seem to like that.
I’ll have to find a different solution.

I have tried changing browsers to Firefox and Safari as well as trying to link other google accounts to the plugin, but it did not work and I still get the same error (above mentioned). Any other suggestion to why this admin-ajax.php 500 Internal Server Error might be occuring.

Hello @arbaouii,

Can you turn on the debug log from your wp-config.php file ?

Put the following code before /* That’s all, stop editing! Happy blogging. */
define(‘WP_DEBUG’, true);
define(‘WP_DEBUG_LOG’, true);
define(‘WP_DEBUG_DISPLAY’, true);
define(‘SCRIPT_DEBUG’, true);
define(‘SAVEQUERIES’, true);

After that try to authenticate again, and then find debug.log under wp-content
and send us the log file.

Thanks
Jina Shah

Hi Jina,

Do you have an email address I can send the file to?

I found a solution to my problem. When reading the debug files I found that php was experiencing errors on the google-sheet.php on line 4 when accessing namespaces. Another research pointed out that php namespaces were supported in the languages for version 5.3.0 and higher. This got me to the main culprit, my dev server is php 5.5.x and my prod server was 5.2.x. We updated our php the prod server and the plugin worked just fine. I put this here if someone else experiences anything similar.

Thank you for the time taken on this issue. As far as I am concerned, my issue is closed.

Hi,

I am glad to hear,

Thanks for troubleshooting and posting with the solution.

Feel free to let us know if we can assist you further.