Thread Starter
007me
(@007me)
This is the error:
Fatal error: Uncaught LogicException: Auth, Invalid OAuth2 access token in /home/ruegldzg/public_html/wp-content/plugins/cf7-google-sheets-connector/lib/google-sheets.php:64 Stack trace: #0 /home/ruegldzg/public_html/wp-content/plugins/cf7-google-sheets-connector/lib/google-sheets.php(384): CF7GSC_googlesheet->auth() #1 /home/ruegldzg/public_html/wp-content/plugins/cf7-google-sheets-connector/google-sheet-connector.php(242): CF7GSC_googlesheet->gsheet_print_google_account_email() #2 /home/ruegldzg/public_html/wp-content/plugins/cf7-google-sheets-connector/includes/pages/google-sheet-settings.php(36): Gs_Connector_Free_Init->google_sheet_config() #3 /home/ruegldzg/public_html/wp-content/plugins/cf7-google-sheets-connector/google-sheet-connector.php(199): include('/home/ruegldzg/...') #4 /home/ruegldzg/public_html/wp-includes/class-wp-hook.php(303): Gs_Connector_Free_Init->google_sheet_configuration('') #5 /home/ruegldzg/public_html/wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters('', Array) #6 /home/ruegldzg/publ in /home/ruegldzg/public_html/wp-content/plugins/cf7-google-sheets-connector/lib/google-sheets.php on line 64
-
This reply was modified 4 years, 9 months ago by
007me.
Hi @007me,
If you are not able to deactivate then there might be a library conflict with some other plugin using same but with different version.
Can you just have CF7 and GSheetConnector as an active plugin and check?
Also as the error is displaying Invalid auth it means you are not successfully connected.
Do the following after deactivation of the auth code.
1) Clear the log.txt file by clicking Debug Log “View” link from the plugins Integration page.
2) Open https://myaccount.google.com/permissions and remove 3rd party app access related to GSheetConnector.
3) Get the fresh auth code by clicking “Get Code” from the plugins integration page and save.
4) Check the log.txt file again, if it is empty then there is no issue and the authentication input box must display “Currently Active”.
5) Lastly test any contact form for the data being saved to the sheet. But do add the required settings i.e Sheet Id, Sheet Name, Tab Id and Tab Name.
Thanks
Abdullah
Thread Starter
007me
(@007me)
Hi Abdullah,
Already deactivated all other plugins.
Removed your app from my account on google but the plugin keeps showing that it’s currently active while it’s deleted from Google.
I can’t deactivate it.
more details:
Here’s the HAR file that is created when I try to click on Deactivate.
https://drive.google.com/file/d/1m6m70S2pHChdvGoX1Ac9WVitown_n_Qj/view?usp=sharing
Thread Starter
007me
(@007me)
Found the log.txt but it’s empty
-
This reply was modified 4 years, 9 months ago by 007me.
Thread Starter
007me
(@007me)
Where does it keeps it’s data after deletion of the plugin so I can’t start from scratch?
As you are still not able to deactivate then have a hard refresh of your browser to load an updated JS file.
Also if you have a cache plugin then do clear it.
Alternatively for quick response,
you can connect with me through website online chat or email at helpdesk@gsheetconnector.com
Thanks
Abdullah
Thread Starter
007me
(@007me)
Will email you a its not a browser issue.
I have other sites with your plugin and they works with no issue.
I am having the exact same problem. I have tried deactivating all plugins and hard refreshing. Have you found a solution to this?
Thread Starter
007me
(@007me)
@zstarmac
Not yet. Waiting for the developer to assist.
Frustrating as there’s no other free solution like this one.
I have the same situation, I tried to download my web to my localhost and create a new one and only load CF7 and CF7 Google Sheet Connector try to activate and compare SQL data then delete but same field on the main web on localhost and re-activating it, it doesn’t work either. It rotates like the case of deactivation
Thread Starter
007me
(@007me)
@westerndeal
Any update please?
Thread Starter
007me
(@007me)
Ok, found the solution on hoe to deactivate the plugin.
Uninstall the plugin.
Open the DB with PHPMyAdmin from your cPanel
Go to wp_optios table
Search for any rows that start with gs_
Delete all the rows that are mentioned in the screenshots here:
https://drive.google.com/file/d/1FGdyLAh8PuhxohGeNdlKT3oMoN0lziQN/view?usp=sharing
https://drive.google.com/file/d/1vmfmmuXSTL2WNMa6RR_hgku-1s1bZ_Y8/view?usp=sharingn
Reinstall the plugin
Reconfigure all from scratch.
That’s all.
@007me
Fantastic, thanks for the update,
While deactivation, we are removing this directly from the table,
Maybe because of some plugin conflict not removing this key from the database, will check with the latest versions and release with the update.
Regards
Abdullah
I am having the same issue, I can’t deactivate the Google Access Code after it failed authenticated. And when I look at the database > wp_options, there are no rows starting with gs_
here is the error message I get in the CMS, even tho it says the Google Access Code is currently active:
@jma666
Can you double-check the version you are using currently?
First, try using the latest version, and if the same issue exists try to roll back with a lower version and let me know further.
https://downloads.wordpress.org/plugin/cf7-google-sheets-connector.4.6.zip
Thanks
Abdullah
