Support » Plugin: CF7 Google Sheets Connector » After updating WordPress 5.6.1, the plugin stopped working

  • Resolved ventio

    (@ventio)


    After updating WordPress 5.6.1, the plugin stopped working.
    The enabled plugin does not send data to the sheet and causes that after pressing the “Send” button, the form does not display information about sending and does not clear the form.
    Where to look for the cause?

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

    (@westerndeal)

    Hello @ventio

    Thanks for your message.
    Can you check the debug log under integration to see what errors are showing ??

    make sure debug is enabled from wp-config.php

    Thanks
    Abdullah

    Plugin Author westerndeal

    (@westerndeal)

    @ventio
    We have tested in 5.6.1 and it works perfectly, It looks no issues is found.

    let me know with the error log and screenshot from your side.
    Also, make sure to reauthenticate with google once.

    Thanks
    Abdullah

    Thread Starter ventio

    (@ventio)

    i don’t have a debug log.
    I decided to de-attach the plug and reconnect it. Deactivation was correct, but an attempt to reactivate by pasting the code and pressing the “Save” button causes the ball to spin endlessly. Activation cannot be completed

    Plugin Author westerndeal

    (@westerndeal)

    You can see the debug log here
    https://www.gsheetconnector.com/wp-content/uploads/2019/02/view-button.png

    if it’s empty then you must have to enable debug from wp-config.php while adding

    define( 'WP_DEBUG', true );

    Either all the 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 );
    Thread Starter ventio

    (@ventio)

    log:

    4 lutego 2021 13:36:16 	 PHP 7.4.14Array
    (
        [ERROR_MSG] => Auth, Invalid OAuth2 access token
        [TRACE_STK] => #0 /home/ventio/domains/marka.plus/public_html/wp-content/plugins/cf7-google-sheets-connector/includes/class-gs-service.php(179): cf7gsc_googlesheet->auth()
    #1 /home/ventio/domains/marka.plus/public_html/wp-includes/class-wp-hook.php(287): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
    #2 /home/ventio/domains/marka.plus/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
    #3 /home/ventio/domains/marka.plus/public_html/wp-includes/plugin.php(484): WP_Hook->do_action(Array)
    #4 /home/ventio/domains/marka.plus/public_html/wp-content/plugins/contact-form-7/includes/submission.php(91): do_action('wpcf7_mail_sent', Object(WPCF7_ContactForm))
    #5 /home/ventio/domains/marka.plus/public_html/wp-content/plugins/contact-form-7/includes/submission.php(24): WPCF7_Submission->proceed()
    #6 /home/ventio/domains/marka.plus/public_html/wp-content/plugins/contact-form-7/includes/contact-form.php(763): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm), Array)
    #7 /home/ventio/domains/marka.plus/public_html/wp-content/plugins/contact-form-7/includes/rest-api.php(321): WPCF7_ContactForm->submit()
    #8 /home/ventio/domains/marka.plus/public_html/wp-includes/rest-api/class-wp-rest-server.php(1160): wpcf7_rest_create_feedback(Object(WP_REST_Request))
    #9 /home/ventio/domains/marka.plus/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/ventio/domains/marka.plus/public_html/wp-includes/rest-api/class-wp-rest-server.php(440): WP_REST_Server->dispatch(Object(WP_REST_Request))
    #11 /home/ventio/domains/marka.plus/public_html/wp-includes/rest-api.php(354): WP_REST_Server->serve_request('/contact-form-7...')
    #12 /home/ventio/domains/marka.plus/public_html/wp-includes/class-wp-hook.php(287): rest_api_loaded(Object(WP))
    #13 /home/ventio/domains/marka.plus/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters(NULL, Array)
    #14 /home/ventio/domains/marka.plus/public_html/wp-includes/plugin.php(551): WP_Hook->do_action(Array)
    #15 /home/ventio/domains/marka.plus/public_html/wp-includes/class-wp.php(388): do_action_ref_array('parse_request', Array)
    #16 /home/ventio/domains/marka.plus/public_html/wp-includes/class-wp.php(745): WP->parse_request('')
    #17 /home/ventio/domains/marka.plus/public_html/wp-includes/functions.php(1291): WP->main('')
    #18 /home/ventio/domains/marka.plus/public_html/wp-blog-header.php(16): wp()
    #19 /home/ventio/domains/marka.plus/public_html/index.php(17): require('/home/ventio/do...')
    #20 {main}
    Plugin Author westerndeal

    (@westerndeal)

    Alternatively,
    Go to your Google account permission access section,
    https://myaccount.google.com/permissions

    there you will get Third-party apps with account access.
    Under Third-party apps with account access, You will see various connections, which you authenticated. You will notice GSheetConnector connection as well, click on it and remove access manually while clicking and then again reauthenticate from plugin settings & let me know if it helps.

    Thanks
    Abdullah

    Plugin Author westerndeal

    (@westerndeal)

    Yes, Auth, Invalid OAuth2 access token
    It means Authentication is not active. ReaAuthenticate again once.

    Thread Starter ventio

    (@ventio)

    1. I went to https://myaccount.google.com/permissions then deleted the GSheetConnector connection.
    2. I have disabled “CF7 Google Sheet Connector” on the website
    3. I turned on the “CF7 Google Sheet Connector”
    4. I ran the Debug Log
    5. I clicked “Get code”
    6. I have allowed access
    7. I pasted the generated code and clicked ‘save’
    8. The wheel is spinning and cannot save

    log: [ERROR_MSG] => Auth, Invalid OAuth2 access token

    what else can I do?

    Plugin Author westerndeal

    (@westerndeal)

    @ventio
    Are you using any other CF7 Addon?
    If yes deactivate other addons and try, might be a conflict with some other addons like redirection, etc, please check once.

    “Auth, Invalid OAuth2 access token” is because the authentication key is not saved.

    Thread Starter ventio

    (@ventio)

    I searched and it turned out that your plug is in conflict with the official plug from Facebook (https://pl.wordpress.org/plugins/official-facebook-pixel/)
    After disabling the Facebook plugin, everything returned to normal.
    How can we fix this problem?

    Plugin Author westerndeal

    (@westerndeal)

    Hi @ventio,

    There as been an issue with the guzzle library.

    We did updated that for pro version of our plugin to latest and it conflicted with Facebook plugin as they were having lower version. So unfortunately due to such issues we revert back and also not update it for the free version.

    There are many other plugins who has not yet updated the versions and conflicting with each other.

    We will provide update in next version or release beta/development version.

    Plugin Author westerndeal

    (@westerndeal)

    @ventio
    We have released version 4.6 with a library update
    can you check in your environment, it’s now compatible with
    https://wordpress.org/plugins/official-facebook-pixel/

    Make sure, if having any issue on your side, you can roll back to 4.5 from here
    https://downloads.wordpress.org/plugin/cf7-google-sheets-connector.4.5.zip

    Thread Starter ventio

    (@ventio)

    Works perfectly. Thank you

    Plugin Author westerndeal

    (@westerndeal)

    Fantastic, Thanks for the update.
    I am marking this ticket as resolved, if in case you have any issues, you can create a new ticket.

    Alternatively, it would be great, if you can rate the plugin with 5 stars and reviews with title, Compatible with WP 5.6.1
    So that users get a clear idea.

    Much appreciated.
    Abdullah

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘After updating WordPress 5.6.1, the plugin stopped working’ is closed to new replies.