Support » Plugin: CF7 Google Sheets Connector » [ERROR_MSG] => String could not be parsed as XML

  • Resolved wppjl

    (@wppjl)


    Hi guys,

    My form data cannot get into my sheet.

    There is a same topic but no solution at the end.
    https://wordpress.org/support/topic/error_msg-string-could-not-be-parsed-as-xml/

    I have already checked that cURL is enabled using phpinfo().
    cURL support enabled
    cURL Information 7.62.0

    What can I do?

    Thanks

    Error log:
    21 Oct 2019 14:20:05 PHP 7.3.8Array
    (
    [date] => 2019-10-21
    [time] => 14:20
    [serial-number] =>
    [remote-ip] => 218.255.146.226
    [user-agent] => Mozilla/5.0 (Windows NT 6.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36
    [url] => https://promotion.vigorbeauty.com.hk/
    [post-id] => 135
    [post-name] => liftera-v-lift
    [post-title] => Liftera-V Lift
    [post-url] => https://promotion.vigorbeauty.com.hk/
    [post-author] => admin
    [post-author-email] => wppjl@hotmail.com
    [site-title] => Vigor Beauty
    [site-description] => Promotion
    [site-url] => https://promotion.vigorbeauty.com.hk
    [site-admin-email] => wppjl@hotmail.com
    [user-login] =>
    [user-email] =>
    [user-url] =>
    [user-first-name] =>
    [user-last-name] =>
    [user-nickname] =>
    [user-display-name] =>
    [your-choice] => $150 Liftera-V
    [your-name] => test3
    [your-tel] => 12345678
    [your-sex] => Male
    [your-agreement] => 1
    [ERROR_MSG] => String could not be parsed as XML
    [TRACE_STK] => #0 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-content/plugins/cf7-google-sheets-connector/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/SpreadsheetFeed.php(44): SimpleXMLElement->__construct(”)
    #1 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-content/plugins/cf7-google-sheets-connector/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/SpreadsheetService.php(37): Google\Spreadsheet\SpreadsheetFeed->__construct(false)
    #2 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-content/plugins/cf7-google-sheets-connector/lib/google-sheets.php(76): Google\Spreadsheet\SpreadsheetService->getSpreadsheets()
    #3 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-content/plugins/cf7-google-sheets-connector/includes/class-gs-service.php(175): cf7gsc_googlesheet->add_row(Array)
    #4 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-includes/class-wp-hook.php(286): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
    #5 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters(”, Array)
    #6 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-includes/plugin.php(453): WP_Hook->do_action(Array)
    #7 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-content/plugins/contact-form-7/includes/submission.php(214): do_action(‘wpcf7_mail_sent’, Object(WPCF7_ContactForm))
    #8 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-content/plugins/contact-form-7/includes/submission.php(34): WPCF7_Submission->submit()
    #9 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-content/plugins/contact-form-7/includes/contact-form.php(740): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm), Array)
    #10 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-content/plugins/contact-form-7/includes/rest-api.php(280): WPCF7_ContactForm->submit()
    #11 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-includes/rest-api/class-wp-rest-server.php(936): wpcf7_rest_create_feedback(Object(WP_REST_Request))
    #12 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-includes/rest-api/class-wp-rest-server.php(321): WP_REST_Server->dispatch(Object(WP_REST_Request))
    #13 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-includes/rest-api.php(266): WP_REST_Server->serve_request(‘/contact-form-7…’)
    #14 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-includes/class-wp-hook.php(286): rest_api_loaded(Object(WP))
    #15 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters(”, Array)
    #16 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-includes/plugin.php(515): WP_Hook->do_action(Array)
    #17 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-includes/class-wp.php(375): do_action_ref_array(‘parse_request’, Array)
    #18 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-includes/class-wp.php(715): WP->parse_request(”)
    #19 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-includes/functions.php(960): WP->main(”)
    #20 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/wp-blog-header.php(16): wp()
    #21 /home/vigorbeaut/domains/promotion.vigorbeauty.com.hk/public_html/index.php(17): require(‘/home/vigorbeau…’)
    #22 {main}
    )

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Abdullah WesternDeal

    (@westerndeal)

    Hi @wppj,

    The error “String could not be parsed as XML” displayed in the log file has a few reasons behind it.

    As your CURl is already enabled. It seems your SSL is not verified or your site is not SSL verified. SSL verification is required for security reasons due to HTTP requests and responses.

    For a temporary fix, unless your SSL is not verified you can change the value of parameter CURLOPT_SSL_VERIFYPEER to false in the following files but this would not be secure.

    cf7-google-sheets-connector/lib/cf7gsc/IO/Curl.php

    cf7-google-sheets-connector/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/DefaultServiceRequest.php

    Note: The changes will be overwritten if the plugin is updated.

    Hope this helps. Let us know.

    Thanks
    Abdullah

    Hi Abdullah,

    The temporary fix works for me.
    Thanks for your help.

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