• 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://ww.wp.xz.cn/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] => [email protected]
    [site-title] => Vigor Beauty
    [site-description] => Promotion
    [site-url] => https://promotion.vigorbeauty.com.hk
    [site-admin-email] => [email protected]
    [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 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

    Thread Starter wppjl

    (@wppjl)

    Hi Abdullah,

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

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

The topic ‘[ERROR_MSG] => String could not be parsed as XML’ is closed to new replies.