Hi @manishbizspoint,
Can you change the value of CURLOPT_SSL_VERIFYPEER to false and check.
It is placed in following files
cf7-google-sheets-connector/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/DefaultServiceRequest.php
cf7-google-sheets-connector/lib/php-google-oauth/io/Google_CurlIO.php
If this works than again replace back to true and ask your hosting provider to enable CURL for you.
Hope this helps. Let us know.
Hi Abdullah WesternDeal
Great …
Thank you very much, It worked..!!
Hi Abdullah WesternDeal ,
Another problem!!
Now I am able to save Google Accesscode, but not able to Sync CF7Form data to google Sheet.
I could notice in error log /plugins/cf7-google-sheets-connector/logs/log.txt
17 August 2018 10:00:33 PHP 5.6.5 Error fetching OAuth2 access token, message: ‘invalid_grant’ :: 400
17 August 2018 10:01:16 PHP 5.6.5 Error fetching OAuth2 access token, message: ‘invalid_grant’ :: 400
please help to resolve this
Another problem!!
Now I am able to save Google Accesscode, but not able to Sync CF7Form data to google Sheet.
I could notice in error log /plugins/cf7-google-sheets-connector/logs/log.txt
17 August 2018 10:00:33 PHP 5.6.5 Error fetching OAuth2 access token, message: ‘invalid_grant’ :: 400
17 August 2018 10:01:16 PHP 5.6.5 Error fetching OAuth2 access token, message: ‘invalid_grant’ :: 400
Checked with Host provider , cURL is enabled.
Following are few things which you can tryout :
1) Try to authenticate with some other google account and also another browser.
If still issue than
2) Open Following file
cf7-google-sheets-connector\lib\php-google-oauth\auth\Google_OAuth2.php
around line number 33 and replace “offline” to “online” and test.
3) Few more things you can read on following blog which could help you to solve your issue and you can connect with google sheet.
https://blog.timekit.io/google-oauth-invalid-grant-nightmare-and-how-to-fix-it-9f4efaf1da35
Do let us know further..!!
Thanks
-
This reply was modified 7 years, 7 months ago by
WesternDeal.
Hi,
Thanks for your reply,
I tried changing Google_OAuth2.php file – line no 33 replace “offline” to “online” and tested.
following is the error:
3 September 2018 12:22:59 PHP 5.6.5Array
(
[ERROR_MSG] => HTTP Error: (0) Problem with the SSL CA cert (path? access rights?)
[TRACE_STK] => #0 /webcorp1/www/corpusers/f/u/futurecndlabs.com/wp-content/plugins/cf7-google-sheets-connector/lib/php-google-oauth/auth/Google_OAuth2.php(263): CF7GSC_Google_CurlIO->makeRequest(Object(CF7GSC_Google_HttpRequest))
Hello @swethanarayan,
Are you still having same issue ?
For the above issue, you need to Delete the OLD keys and Validate with New Authenticate Key, hope it will work, let us know.
Thanks
Abdullah
Hi Abdullah,
Thank you very much, I raised request to my client to ‘Delete the OLD keys and Validate with New Authenticate Key’.
Thanks for your valuable time
@swethanarayan
Thanks for your quick response.
Its a great pleasure to assist you, We are also going to launch PRO version shortly with more functionalities and user friendly features.
Please share your experience with 5 stars ratings to aware other user.
https://wordpress.org/support/plugin/cf7-google-sheets-connector/reviews/
Thanks & Regards
Abdullah
