Periodically receiving cURL Error 28

  • Resolved anddadmin

    (@anddadmin)


    7 years, 10 months ago

    Hello,

    After many hours of work was able to get the plugin to display my sheet data perfectly! Thank you so much for making this plugin! However have one issue that makes the operation of the plugin a bit iffy.
    My google spreadsheet is using importrange from a another sheet that is being populated using a google form. If the data on the sheet that is being used by the plug in is displaying live data (meaning using importrange), 3 times out of 5 page refreshes I receive “Error requesting data: cURL error 28: Operation timed out after 5000 milliseconds with 0 out of -1 bytes received”. on the webpage that is using the plugin.

    (I setup an automatic refresh of the page at 10 minute intervals and captured the screen). If I comment out the importrange in the sheet and just have static data, the webpage will display correctly and no cURL error appears.
    I have tried changing the timeout http options (increased to 16 Secs) various cached timings etc… but cannot seem to change this behavior.
    I am using the latest wordpress and latest inline viewer plugin.
    So it would seem that if the sheet has a delay caused by a long calculation or sheet is getting data from an external source, this causes some issue retrieving the sheet via the plugin.
    I have tested on two completely different wordpress hosts (different hosting companies) , one with only this plugin enabled, and received the same results.

    If willing to help to solve this issue can share the actual sheets I’m using via email.
    Thanks so much

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Meitar

    (@meitar)

    That error just means the plugin is waiting on Google to send you data. There’s nothing to be done on the plugin side. If your Sheet takes time to calculate, then yeah, it’s going to take time to display. That’s how time works.

    Re-engineer your sheet, increase your timeout (and your patience), or cache your data longer and accept slightly stale results.

    • This reply was modified 7 years, 10 months ago by Meitar.
    • This reply was modified 7 years, 10 months ago by Meitar.
    Thread Starter anddadmin

    (@anddadmin)

    Thanks.
    I was able to make it work by using 30 seconds timeout. Guess i’ll have to use a spinner to entertain the users.

    BTW, I checked the google sheets API V4 API explorer sample that seems to show very quick loads even from complicated sheets.
    https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchGet
    Not sure if it helps you, but if it does, great.

    Thanks again.

    Plugin Author Meitar

    (@meitar)

    This plugin doesn’t use the API at all. Thanks, though.

    Just go to this file: inline-gdocs-viewer.php and change this line <input id=”js-qt-igsv-http-timeout” name=”http_opts[timeout]” type=”number” min=”5″ max=”120″ placeholder=”5″ />

    into <input id=”js-qt-igsv-http-timeout” name=”http_opts[timeout]” type=”number” min=”5″ max=”120″ placeholder=”10″ />

    I changed the 5 seconds into 10 here, you can increase the value of the placeholder as much as you’d like. It will cause a delay in displaying your data, but at least you won’t get an error message.

    I hope this helped.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Periodically receiving cURL Error 28’ is closed to new replies.

Tags