CF7 Google Sheets connector not accepting Authorization

Resolved mikeyh874
(@mikeyh874)

5 years, 9 months ago

This is the error log showing that the app is not registering my authorization:
20 July 2020 14:15:57 PHP 7.2.21Array
(
[ERROR_MSG] => Auth, Invalid OAuth2 access token
[TRACE_STK] => #0 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-content/plugins/cf7-google-sheets-connector/includes/class-gs-service.php(151): cf7gsc_googlesheet->auth()
#1 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-includes/class-wp-hook.php(287): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
#2 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters(”, Array)
#3 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
#4 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-content/plugins/contact-form-7/includes/submission.php(89): do_action(‘wpcf7_mail_sent’, Object(WPCF7_ContactForm))
#5 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-content/plugins/contact-form-7/includes/submission.php(24): WPCF7_Submission->proceed()
#6 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-content/plugins/contact-form-7/includes/contact-form.php(727): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm), Array)
#7 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-content/plugins/contact-form-7/includes/rest-api.php(298): WPCF7_ContactForm->submit()
#8 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-includes/rest-api/class-wp-rest-server.php(1015): wpcf7_rest_create_feedback(Object(WP_REST_Request))
#9 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-includes/rest-api/class-wp-rest-server.php(342): WP_REST_Server->dispatch(Object(WP_REST_Request))
#10 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-includes/rest-api.php(312): WP_REST_Server->serve_request(‘/contact-form-7…’)
#11 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-includes/class-wp-hook.php(287): rest_api_loaded(Object(WP))
#12 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters(NULL, Array)
#13 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-includes/plugin.php(544): WP_Hook->do_action(Array)
#14 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-includes/class-wp.php(388): do_action_ref_array(‘parse_request’, Array)
#15 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-includes/class-wp.php(739): WP->parse_request(”)
#16 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-includes/functions.php(1274): WP->main(”)
#17 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/wp-blog-header.php(16): wp()
#18 /home/zy4ww6k9qgot/public_html/commonlawcourtaus.org/index.php(17): require(‘/home/zy4ww6k9q…’)
#19 {main}
)

I have deleted the Google Access Code following the video you posed, and re-installed it 3 or 4 times already but I still keep getting the same result.

I have also set up the Google Sheet Settings correctly. Still, nothing works.
Can anyone help, please?

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

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

Plugin Author WesternDeal
(@westerndeal)

5 years, 9 months ago

Hello @mikeyh874

Sorry for the trouble.
The above error indicates that Authorize is not successful.
Can you go in google permission page and remove the access manually
https://myaccount.google.com/permissions

and then reauth from a plugin and then check the permission page again to confirm all the permission is granted.
for more please refer this link and let me know if still having problems.
https://mailchi.mp/44985dea65c0/reauthentication-needed-for-gsheetconnector-after-update

Thanks
Abdullah

Thread Starter mikeyh874
(@mikeyh874)

5 years, 9 months ago

I have followed your instructions to the letter but still having a problem. In fact, it’s got worse now. I cleared the Error log so that it would be easier to check what was happening. Now I do not get anything saved to the error log…. and I still cannot save data to the sheet. I even added the code to enable the error log you provided to wp-config, but the error log continues to stay blank.

Next, I created a new Sheet to record information from the Contact Us form and that worked immediately.

So, I have a feeling I might be using a field type in the Volunteers form that the Sheet doesn’t like. https://commonlawcourtaus.org/volunteer-to-serve-on-court/
These are the fields:

[text* your-name placeholder “First Name*”]

[text middle-name placeholder "Middle Name"]

[text* last-name placeholder “Last Name*”]

[text* address1 placeholder “Address1*”]

[text address2 placeholder "Address2"]

[text* town-city placeholder “Town-City*”]

[select* state include_blank “NSW” “VIC” “QLD” “TAS” “SA” “WA” “NT” “CAN”]

[text* post-code placeholder “Post-Code*”]

[text* phone placeholder “Phone*”]

[email* your-email placeholder “Email*”]

[radio voting-age label_first default:1 “I am voting age” “I am not voting age”]

Enter your Common Law Court Birth Certificate Registration Number:
[text* bc-registration-number placeholder “Birth certificate registration number*”]

Have you ever served time for a crime? If you select Yes you may be asked to give details to a confidential assessment panel. The panel’s decision will depend on the severity of the crime, time served, and your record since release.
[radio convicted-of-a-crime label_first default:1 “No” “Yes”]

I confirm that I am available to serve on a Common Law Court in the following position(s): [checkbox volunteering-for-court-position “Jury Duty” “Citizen Prosecutor” “Adjudicator” “Sheriff” “Bailiff” “Court reporter” “Court registrar”]

List days available to serve [checkbox available-to-serve “Any day” “Any weekday(s)” “Weekends only” “Monday” “Tuesday” “Wednesday” “Thursday” “Friday” “Saturday” “Sunday”]

[hidden your-subject default:subject “Court Volunteer Registration”]

[textarea your-message placeholder “Write comments/suggestions here”]

[honeypot website-388] – NOTE: This is a hidden field designed to stop spammers. I didn’t put it in the Sheet headers.

Plugin Author WesternDeal
(@westerndeal)

5 years, 9 months ago

If an error log is empty and getting data in sheet or not it means no issues with the plugin

Make sure in the sheet you are using field column headers like exactly you defined
eg.
your-name
middle-name
last-name
address1
and so on.

Thread Starter mikeyh874
(@mikeyh874)

5 years, 9 months ago

Yes, I have done that. It still didn’t work.
So then I deleted the plugin and re-installed it. Set everything up properly. And then I took out all the fields after email in the form anbd the Sheet, in case there was a problem with the formatting of the field names. I also simplified the Sheet name to ‘voluteers’, and the tab name to ‘vol1’. Tested it again. The data is still not going into the sheet.
I have deleted the sheet and re-created it and tested again. It’s still not working.
So far, I have only been successful in transferring data from a Contact form, but not from one as complex as the voluteers form.
I have run out of ideas.

Thread Starter mikeyh874
(@mikeyh874)

5 years, 9 months ago

Finally I got it to work. I’m not even sure what I did but as it’s working now I’ll close this.

Thread Starter mikeyh874
(@mikeyh874)

5 years, 9 months ago

Resolved

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

The topic ‘CF7 Google Sheets connector not accepting Authorization’ is closed to new replies.

Tags