Hi Hartmut, Sorry to hear about your experience, and thanks for your report. Although I don't understand why the Query requests would timeout sometimes, when using v48, but not consistently all the time, the problem with v49 is understandable since your spreadsheets appear to be using an older version, and a change in v49 to make the requests more secure turns out to fail with the older spreadsheets.
I have a backward-compatibility fix that will be in the next release, though it will have a different problem with the Edge browser. Since more errors of this kind are starting to surface now, a couple months after the release of v49, I am inclined to push out this new release relatively soon, perhaps in the next few weeks. I wonder if the occasional timeout errors are also due to using the older version of spreadsheets, maybe because the servers are getting less attention or more problematic. You might be able to workaround both problems by creating new spreadsheets and copying the contents from the old spreadsheets. I don't know if there is a way to upgrade otherwise, but I expect not since the URLs are quite different. On Wed, Sep 30, 2020 at 11:27 PM Hartmut Gunther <h...@nutregy.com.au> wrote: > Daniel please also note that the time-out error is random - right now its > working fine but this morning all pages similar to > https://www.toxtest.com.au/results/hair-analysis-1-ub.html were timing > out. > thanks > > On Thursday, 1 October 2020 at 11:49:32 UTC+10 Hartmut Gunther wrote: > >> Also, here is an example of the errors in the web browser javascript >> console when I use version 49 >> >> [Error] XMLHttpRequest cannot load >> https://docs.google.com/spreadsheets/d/10US47G8dtHerH1mJLyT7IOduPUAAZEYdhhYWt26f4iE/gviz/tq?sheet=Sheet2&headers=1&tq=SELECT%20M,%20N,%20O,%20P,%20Q,%20R,%20S%20where%20BD%20=%22UB%22%20%20limit%201000%20offset%200&tqx=reqId%3A0 >> due to access control checks. >> [Error] Failed to load resource: Origin null is not allowed by >> Access-Control-Allow-Origin. (tq, line 0) >> [Error] Origin null is not allowed by Access-Control-Allow-Origin. >> [Error] XMLHttpRequest cannot load >> https://docs.google.com/spreadsheets/d/10US47G8dtHerH1mJLyT7IOduPUAAZEYdhhYWt26f4iE/gviz/tq?sheet=Sheet1&headers=9&tq=SELECT%20S,%20%20UB%20%20where%20Q%20=%20%22phosphorus%22%20%20limit%201000%20offset%200&tqx=reqId%3A29 >> due to access control checks. >> [Error] Failed to load resource: Origin null is not allowed by >> Access-Control-Allow-Origin. (tq, line 0) >> [Error] Error: Error handling Query: XhrHttpError: Request Failed, >> status=0, url= >> https://docs.google.com/spreadsheets/d/10US47G8dtHerH1mJLyT7IOduPUAAZEYdhhYWt26f4iE/gviz/tq?sheet=Sheet2&headers=1&tq=SELECT >> M, N, O, P, Q, R, S where BD ="UB" limit 1000 offset 0&tqx=reqId%3A0 >> (anonymous function) (jsapi_compiled_default_module.js:251:543) >> [Error] Error: Error handling Query: XhrHttpError: Request Failed, >> status=0, url= >> https://docs.google.com/spreadsheets/d/10US47G8dtHerH1mJLyT7IOduPUAAZEYdhhYWt26f4iE/gviz/tq?sheet=Sheet1&headers=9&tq=SELECT >> S, UB where Q = "phosphorus" limit 1000 offset 0&tqx=reqId%3A29 >> (anonymous function) (jsapi_compiled_default_module.js:251:543) >> [Error] Origin null is not allowed by Access-Control-Allow-Origin. >> [Error] XMLHttpRequest cannot load >> https://docs.google.com/spreadsheets/d/10US47G8dtHerH1mJLyT7IOduPUAAZEYdhhYWt26f4iE/gviz/tq?sheet=Sheet1&headers=9&tq=SELECT%20S,%20%20UB%20%20where%20Q%20=%20%22antimony%22%20limit%201000%20offset%200&tqx=reqId%3A2 >> due to access control checks. >> [Error] Failed to load resource: Origin null is not allowed by >> Access-Control-Allow-Origin. (tq, line 0) >> [Error] Error: Error handling Query: XhrHttpError: Request Failed, >> status=0, url= >> https://docs.google.com/spreadsheets/d/10US47G8dtHerH1mJLyT7IOduPUAAZEYdhhYWt26f4iE/gviz/tq?sheet=Sheet1&headers=9&tq=SELECT >> S, UB where Q = "antimony" limit 1000 offset 0&tqx=reqId%3A2 >> (anonymous function) (jsapi_compiled_default_module.js:251:543) >> [Error] Origin null is not allowed by Access-Control-Allow-Origin. >> >> thanks >> Hartmut >> >> On Thursday, 1 October 2020 at 11:29:24 UTC+10 Hartmut Gunther wrote: >> >>> Hello >>> Daniel LaLiberte >>> The web page here >>> https://www.toxtest.com.au/results/hair-analysis-1-ub.html >>> contains visualisation of toxicology results using google charts >>> visualisation engine (v48) . I have been using this method since 2015 (with >>> updates) and no problems. Chart pulls data from >>> https://docs.google.com/spreadsheets/. >>> In last few months the amount of time-out errors has steadily and >>> randomly increased with some results on the page refusing to load. I know >>> the page is complex and long but I've never had this problem before. Could >>> you please have a look and let me know if i'm missing something. >>> ALSO when I try to use v49 - nothing loads at all - very concerning >>> thanks so much >>> Hartmut >>> >>> -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to google-visualization-api+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/google-visualization-api/67fcd7a2-8a14-4864-9388-ae9f94594540n%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/67fcd7a2-8a14-4864-9388-ae9f94594540n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> dlalibe...@google.com <dlalibe...@google.com> Cambridge MA -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJPt9hpxhgN7HJK5UfEiwc3ecRBoXKyabvOMRsiWeUH1pQ%40mail.gmail.com.
