You need permissions error

  • Resolved vaishnavip

    (@vaishnavip)


    4 years, 7 months ago

    Hello,

    Form is not submitted in google sheets and it’s throwing an error in error logs please find it below:

    [ERROR_MSG] => You need permission
    [TRACE_STK] => 

    #0 /wp-content/plugins/cf7-google-sheets-connector/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/DefaultServiceRequest.php(130): Google\Spreadsheet\DefaultServiceRequest->execute(Resource id #2508)
#1 /wp-content/plugins/cf7-google-sheets-connector/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/SpreadsheetService.php(37): Google\Spreadsheet\DefaultServiceRequest->get('feeds/spreadshe...')
#2 /wp-content/plugins/cf7-google-sheets-connector/lib/google-sheets.php(76): Google\Spreadsheet\SpreadsheetService->getSpreadsheets()
#3 /wp-content/plugins/cf7-google-sheets-connector/includes/class-gs-service.php(175): cf7gsc_googlesheet->add_row(Array)
#4 /wp-includes/class-wp-hook.php(287): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
#5 /wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
#6 /wp-includes/plugin.php(478): WP_Hook->do_action(Array)
#7 /wp-content/plugins/contact-form-7/includes/submission.php(91): do_action('wpcf7_mail_sent', Object(WPCF7_ContactForm))
#8 /wp-content/plugins/contact-form-7/includes/submission.php(24): WPCF7_Submission->proceed()
#9 /wp-content/plugins/contact-form-7/includes/contact-form.php(763): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm), Array)
#10 /wp-content/plugins/contact-form-7/includes/rest-api.php(321): WPCF7_ContactForm->submit()
#11 /wp-includes/rest-api/class-wp-rest-server.php(1050): wpcf7_rest_create_feedback(Object(WP_REST_Request))
#12 /wp-includes/rest-api/class-wp-rest-server.php(376): WP_REST_Server->dispatch(Object(WP_REST_Request))
#13 /wp-includes/rest-api.php(339): WP_REST_Server->serve_request('/contact-form-7...')
#14 /wp-includes/class-wp-hook.php(287): rest_api_loaded(Object(WP))
#15 /wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
#16 /wp-includes/plugin.php(544): WP_Hook->do_action(Array)
#17 /wp-includes/class-wp.php(388): do_action_ref_array('parse_request', Array)
#18 /wp-includes/class-wp.php(745): WP->parse_request('')
#19 /wp-includes/functions.php(1285): WP->main('')
#20 /wp-blog-header.php(16): wp()
#21 /index.php(17): require('/nfs/c10/h14/mn...')
#22 {main}

    Can you please help us resolving it.
    Thanks & Regards!

    • This topic was modified 4 years, 7 months ago by vaishnavip.
    • This topic was modified 4 years, 7 months ago by vaishnavip.

    The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)
  • casperbr

    (@casperbr)

    4 years, 7 months ago

    Same issue. Worked before, not anymore since some time.

    Plugin Author WesternDeal

    (@westerndeal)

    4 years, 7 months ago

    Hello @vaishnavip

    It’s showing permission error,
    This means Google Drive and Google Sheets permission is not given, while authentication with Goolge, So first you have to deactivate and then Authenticate again with google and allow both the permissions.

    If in case you are unable to deactivate then you have to do the following

    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
Reconfigure/Reauthenticate with google, along with all the permissions.

    Let me know if it helps!

    Thanks
    Abdullah

    krejkobfaglobal

    (@krejkobfaglobal)

    4 years, 7 months ago

    Hello @westerndeal,

    We have also started having this problem within the last week. We have successfully been able to deactivate and re-authenticate with google drive/sheets many times. However, this error message continues to show in the logs, we are unable to list sheets on our account (pro version) and the connected google sheets are not updated when there are new responses.

    Is there anything else we can try to get this working again?

    Thank you,
    Kevin

    Plugin Author WesternDeal

    (@westerndeal)

    4 years, 7 months ago

    Kevin, @krejkobfaglobal

    Sorry for the trouble.

    First Deactivate the Authentication, and then
    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

    To confirm authentication is deactivate,
    Then Reauthenticate with all the Google Permissions with new AUTH Code
    Make sure to deactivate plugins like a cache plugin or a backup plugin, in case if you are using them. Also, try to use Private Window.

    Then, If using the PRO version then there is a link below to fetch sheets, click on it to fetch sheets from an integrated account. Then only you can see the list of sheets in the dropdown.
    If still having a issue and using the PRO version then connect from here

    Thanks
    Abdullah

    krejkobfaglobal

    (@krejkobfaglobal)

    4 years, 7 months ago

    @westerndeal

    Thank you for your quick response.

    I was able to access PHPMyAdmin. In the wp_options table I was able to find and remove gs_close_add_interval per the linked screenshot. However, I didn’t have any records that began with gs_token, gs_verify, or gs_access_code. However, I did find a record called cf7_to_spreadsheet_google_token which seemed to have all these other pieces of information inside a json object. I did remove this record but when I refreshed the plugin page I was still required to manually click the deactivate button. Unfortunately, it looks like your method for confirming deactivation didn’t make it into the write-up.

    After re-adding the new google sheets token I could still not see any change in the usage of the plugin. It still was unable to list the spreadsheets in the dropdown and submissions were not updated in google sheets.

    Was I unable to find these records because I was on an old version of the plugin? Is there instructions I should follow to verify that editing the database deactivated successfully?

    Thanks again!

    krejkobfaglobal

    (@krejkobfaglobal)

    4 years, 7 months ago

    I also wanted to quickly double-check that I am in the right place for the plug-in I am using. I know forum is for “CF7 Google Sheets Connector”, however in WordPress the plug-in is called “Contact Form 7 – Google Sheet Integration”. This is the same thing, right?

    korynorthrop

    (@korynorthrop)

    4 years, 6 months ago

    I am having the same issue as the other posters and have been unable to resolve it following the directions given by the plugin author.

    Plugin Author WesternDeal

    (@westerndeal)

    4 years, 6 months ago

    @krejkobfaglobal
    CF7 Google Sheets Connector
    This is the plugin you are using. And another plugin name you listed might be another plugin, so deactivate the other one, Otherwise, if the google API library is different then it will cause conflict issues.

    @korynorthrop
    1. Make sure you are allowing Google Drive permission and Google Sheet permission and let me know the exact error you are getting.
    Try using the lower version and let me know
    https://downloads.wordpress.org/plugin/cf7-google-sheets-connector.4.6.zip

    Thanks
    Abdullah

    korynorthrop

    (@korynorthrop)

    4 years, 6 months ago

    @westerndeal I got it working, it wasn’t made clear that the “Google Sheet ID” and “Google Tab ID” were both required when making the connection between a CF7 form and the desired Google Sheet. All is working fine now.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘You need permissions error’ is closed to new replies.