Support » Plugin: CF7 Google Sheets Connector » The data does not appear in the table.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author westerndeal

    (@westerndeal)

    Hello @ikatod

    Sorry for the trouble
    Thanks for the screenshot, are you sure SheetID is entered correctly?
    Please confirm it once and enter again.
    And ReAuthenticate once again and check

    Also, check the debug log view once if it’s found empty then you have to enable debug mode from wp-config.php.

    Let me know further.

    Abdullah

    Thread Starter ikatod

    (@ikatod)

    Google Sheet Id – yes
    And ReAuthenticate once again and check – yes )

    Also, check the debug log view once if it’s found empty then you have to enable debug mode from wp-config.php.

    Where can I find it?

    Thread Starter ikatod

    (@ikatod)

    8 марта 2021 13:31:16 PHP 7.4.11Array
    (
    [ERROR_MSG] => Auth, Invalid OAuth2 access token
    [TRACE_STK] => #0 /home/ikatod/domains/myteam.art/public_html/wp-content/plugins/cf7-google-sheets-connector/includes/class-gs-service.php(179): CF7GSC_googlesheet->auth()
    #1 /home/ikatod/domains/myteam.art/public_html/wp-includes/class-wp-hook.php(287): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
    #2 /home/ikatod/domains/myteam.art/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters(”, Array)
    #3 /home/ikatod/domains/myteam.art/public_html/wp-includes/plugin.php(484): WP_Hook->do_action(Array)
    #4 /home/ikatod/domains/myteam.art/public_html/wp-content/plugins/contact-form-7/includes/submission.php(96): do_action(‘wpcf7_mail_sent’, Object(WPCF7_ContactForm))
    #5 /home/ikatod/domains/myteam.art/public_html/wp-content/plugins/contact-form-7/includes/submission.php(24): WPCF7_Submission->proceed()
    #6 /home/ikatod/domains/myteam.art/public_html/wp-content/plugins/contact-form-7/includes/contact-form.php(763): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm), Array)
    #7 /home/ikatod/domains/myteam.art/public_html/wp-content/plugins/contact-form-7/includes/rest-api.php(321): WPCF7_ContactForm->submit()
    #8 /home/ikatod/domains/myteam.art/public_html/wp-includes/rest-api/class-wp-rest-server.php(1160): wpcf7_rest_create_feedback(Object(WP_REST_Request))
    #9 /home/ikatod/domains/myteam.art/public_html/wp-includes/rest-api/class-wp-rest-server.php(1007): WP_REST_Server->respond_to_request(Object(WP_REST_Request), ‘/contact-form-7…’, Array, NULL)
    #10 /home/ikatod/domains/myteam.art/public_html/wp-includes/rest-api/class-wp-rest-server.php(440): WP_REST_Server->dispatch(Object(WP_REST_Request))
    #11 /home/ikatod/domains/myteam.art/public_html/wp-includes/rest-api.php(354): WP_REST_Server->serve_request(‘/contact-form-7…’)
    #12 /home/ikatod/domains/myteam.art/public_html/wp-includes/class-wp-hook.php(287): rest_api_loaded(Object(WP))
    #13 /home/ikatod/domains/myteam.art/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters(NULL, Array)
    #14 /home/ikatod/domains/myteam.art/public_html/wp-includes/plugin.php(551): WP_Hook->do_action(Array)
    #15 /home/ikatod/domains/myteam.art/public_html/wp-includes/class-wp.php(388): do_action_ref_array(‘parse_request’, Array)
    #16 /home/ikatod/domains/myteam.art/public_html/wp-includes/class-wp.php(745): WP->parse_request(”)
    #17 /home/ikatod/domains/myteam.art/public_html/wp-includes/functions.php(1291): WP->main(”)
    #18 /home/ikatod/domains/myteam.art/public_html/wp-blog-header.php(16): wp()
    #19 /home/ikatod/domains/myteam.art/public_html/index.php(17): require(‘/home/ikatod/do…’)
    #20 {main}
    )

    Thread Starter ikatod

    (@ikatod)

    These are old mistakes. There are no new ones. The log is already clean

    Plugin Author westerndeal

    (@westerndeal)

    Oh.. I See

    Might be Auth is not saving properly so having issues.
    Can you roll back to this version and check?
    https://downloads.wordpress.org/plugin/cf7-google-sheets-connector.4.5.zip

    If still having issues, it requires debugging while adding all the following debug statements

    // Enable WP_DEBUG mode
    define( 'WP_DEBUG', true );
    
    // Enable Debug logging to the /wp-content/debug.log file
    define( 'WP_DEBUG_LOG', true );
    
    // Disable display of errors and warnings
    define( 'WP_DEBUG_DISPLAY', false );
    @ini_set( 'display_errors', 0 );
    
    // Use dev versions of core JS and CSS files (only needed if you are modifying these core files)
    define( 'SCRIPT_DEBUG', true );

    Then, check the wp-content directory, debug.log will generate when you fill the form and submit it from the frontend, let me know what error it shows.

    Thanks
    Abdullah

    Thread Starter ikatod

    (@ikatod)

    If still having issues, it requires debugging while adding all the following debug statements

    Can you tell me where I should add this?
    I installed the old version. The log is still clean.

    Thread Starter ikatod

    (@ikatod)

    https://take.ms/DQGQx Could that be a problem?

    Plugin Author westerndeal

    (@westerndeal)

    Hi @ikatod,

    The error “Auth, Invalid OAuth2 access token” means you are not successfully authenticated with your account.

    For this,

    1) Clear the log.txt file from the integration page.
    2) Deactivate the authentication.
    3) Now open up https://myaccount.google.com/permissions and look for 3rd party app access and remove access related to GSheetconnector for WP Contact Forms. Don’t worry if it dosen’t show you the access related to GSheetconnector.
    4) Get the fresh authentication key and integrate again.

    If your log.txt file still display same error then try to connect with another Google account.

    Hope this helps. Let us know.

    Thanks
    Abdullah

Viewing 8 replies - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.