Support » Plugin: CF7 Google Sheets Connector » Plugin is not working

  • Resolved nguyenrom

    (@nguyenrom)


    Dear mate,

    1. I have done Get code step, but I dont see anything in logs.

    2. I have tried with demo, it’s not working!

    11 October 2016 22:53:37 	 PHP 7.0.11Array
    (
        [date] => 11 October 2016 22:53:34
        [Name] => ABC
        [Email] => ABC@ABC.ABC
        [Website] => ABC.COM
        [Subcribe] => AAA
        [ERROR_MSG] => Error in Google Request
        [TRACE_STK] => #0 /srv/.................../wp-content/plugins/cf7-google-sheets-connector/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/DefaultServiceRequest.php(147): Google\Spreadsheet\DefaultServiceRequest->execute(Resource id #26)
    #1 /srv/.................../wp-content/plugins/cf7-google-sheets-connector/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/ListFeed.php(79): Google\Spreadsheet\DefaultServiceRequest->post('https://spreads...', '<entry xmlns="h...')
    #2 /srv/.................../wp-content/plugins/cf7-google-sheets-connector/lib/google-sheets.php(80): Google\Spreadsheet\ListFeed->insert(Array)
    #3 /srv/.................../wp-content/plugins/cf7-google-sheets-connector/includes/class-gs-service.php(109): googlesheet->add_row(Array)
    #4 /srv/.................../wp-includes/plugin.php(524): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
    #5 /srv/.................../wp-content/plugins/contact-form-7/includes/submission.php(163): do_action('wpcf7_mail_sent', Object(WPCF7_ContactForm))
    #6 /srv/.................../wp-content/plugins/contact-form-7/includes/submission.php(28): WPCF7_Submission->submit()
    #7 /srv/.................../wp-content/plugins/contact-form-7/includes/contact-form.php(623): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm))
    #8 /srv/.................../wp-content/plugins/contact-form-7/includes/controller.php(57): WPCF7_ContactForm->submit(true)
    #9 /srv/.................../wp-content/plugins/contact-form-7/includes/controller.php(18): wpcf7_ajax_json_echo()
    #10 /srv/.................../wp-includes/plugin.php(524): wpcf7_control_init('')
    #11 /srv/.................../wp-settings.php(432): do_action('wp_loaded')
    #12 /srv/.................../wp-config.php(45): require_once('/srv/users/serv...')
    #13 /srv/.................../wp-load.php(39): require_once('/srv/users/serv...')
    #14 /srv/.................../wp-blog-header.php(13): require_once('/srv/users/serv...')
    #15 /srv/.................../index.php(17): require('/srv/users/serv...')
    #16 {main}
    )
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author westerndeal

    (@westerndeal)

    Hello,
    Thanks for using the plugin,

    It looks that “Error in Google Request” which means request is not sent to google,
    1. Can you Please verify that you have created the spreadsheet with correct names with the CF7
    2. Make sure that you are working LIVE [Hosted Site] it’s not going to work on localhost.
    Please do refer FAQ for configuring and let me know back, would be happy to assist you further,

    [ Signature moderated ]

    • This reply was modified 4 years, 6 months ago by Jan Dembowski.
    Thread Starter nguyenrom

    (@nguyenrom)

    Dear Abdullah,

    1. I have tried but still error: [ERROR_MSG] => Error in Google Request
    2. I setup VPS in Vultr + Serverpilot.

    Thank you!

    Thread Starter nguyenrom

    (@nguyenrom)

    Hi Westerndeal, I have send my information to your email! Thank you so much…

    Thread Starter nguyenrom

    (@nguyenrom)

    Sorry for reply later πŸ™

    Plugin Author westerndeal

    (@westerndeal)

    Thank you,

    I have gone through with the issue and solved,

    Made a Mistake in configuration,
    Never use Capital Letters like Name, Email etc for contact form text-box, text area or any other fields
    Special Characters, Underscores and Capital letters are not allowed,

    Please do refer and let me know, if i can assist you further,

    Many Thanks
    Abdullah !!

    Thread Starter nguyenrom

    (@nguyenrom)

    Thank Abdullah, plugin working great πŸ˜€

    I’m having problems with the plugin parsing XML as follows:

    21 December 2016 09:55:15 PHP 5.6.28Array
    (
    [date] => 21 December 2016 09:55:15
    [select] => Cultivator
    [firstname] => DANA
    [lastname] => danaphree
    [company] => test company
    [website] => http://danapros.com
    [youremail] => leon@financialdreamteam.com
    [message] => testing google inte again
    [tel637] => 3104255788
    [ERROR_MSG] => String could not be parsed as XML
    [TRACE_STK] => #0 D:\home\cannabiniers.com\wwwroot\wp-content\plugins\cf7-google-sheets-connector\lib\asimlqt\php-google-spreadsheet-client\src\Google\Spreadsheet\SpreadsheetFeed.php(45): SimpleXMLElement->__construct(”)
    #1 D:\home\cannabiniers.com\wwwroot\wp-content\plugins\cf7-google-sheets-connector\lib\asimlqt\php-google-spreadsheet-client\src\Google\Spreadsheet\SpreadsheetService.php(39): Google\Spreadsheet\SpreadsheetFeed->__construct(false)
    #2 D:\home\cannabiniers.com\wwwroot\wp-content\plugins\cf7-google-sheets-connector\lib\google-sheets.php(73): Google\Spreadsheet\SpreadsheetService->getSpreadsheets()
    #3 D:\home\cannabiniers.com\wwwroot\wp-content\plugins\cf7-google-sheets-connector\includes\class-gs-service.php(109): googlesheet->add_row(Array)
    #4 [internal function]: Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
    #5 D:\home\cannabiniers.com\wwwroot\wp-includes\class-wp-hook.php(298): call_user_func_array(Array, Array)
    #6 D:\home\cannabiniers.com\wwwroot\wp-includes\class-wp-hook.php(323): WP_Hook->apply_filters(”, Array)
    #7 D:\home\cannabiniers.com\wwwroot\wp-includes\plugin.php(453): WP_Hook->do_action(Array)
    #8 D:\home\cannabiniers.com\wwwroot\wp-content\plugins\contact-form-7\includes\submission.php(161): do_action(‘wpcf7_mail_sent’, Object(WPCF7_ContactForm))
    #9 D:\home\cannabiniers.com\wwwroot\wp-content\plugins\contact-form-7\includes\submission.php(28): WPCF7_Submission->submit()
    #10 D:\home\cannabiniers.com\wwwroot\wp-content\plugins\contact-form-7\includes\contact-form.php(645): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm))
    #11 D:\home\cannabiniers.com\wwwroot\wp-content\plugins\contact-form-7\includes\controller.php(57): WPCF7_ContactForm->submit(true)
    #12 D:\home\cannabiniers.com\wwwroot\wp-content\plugins\contact-form-7\includes\controller.php(18): wpcf7_ajax_json_echo()
    #13 [internal function]: wpcf7_control_init(”)
    #14 D:\home\cannabiniers.com\wwwroot\wp-includes\class-wp-hook.php(298): call_user_func_array(‘wpcf7_control_i…’, Array)
    #15 D:\home\cannabiniers.com\wwwroot\wp-includes\class-wp-hook.php(323): WP_Hook->apply_filters(”, Array)
    #16 D:\home\cannabiniers.com\wwwroot\wp-includes\plugin.php(453): WP_Hook->do_action(Array)
    #17 D:\home\cannabiniers.com\wwwroot\wp-settings.php(470): do_action(‘wp_loaded’)
    #18 D:\home\cannabiniers.com\wwwroot\wp-config.php(89): require_once(‘D:\\home\\cannabi…’)
    #19 D:\home\cannabiniers.com\wwwroot\wp-load.php(37): require_once(‘D:\\home\\cannabi…’)
    #20 D:\home\cannabiniers.com\wwwroot\wp-blog-header.php(13): require_once(‘D:\\home\\cannabi…’)
    #21 D:\home\cannabiniers.com\wwwroot\index.php(17): require(‘D:\\home\\cannabi…’)
    #22 {main}
    )

    Any help would be greatly appreciated. Thanks advance!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Plugin is not working’ is closed to new replies.