The errors you are seeing now are at least unrelated to the query errors you saw before, so that's progress.
The error about the "Container is not defined" is due to creating the chart object when the container element is not yet defined. I don't see where that is happening in your page, but perhaps that gives you enough of a clue. The other error about the spreadsheet doesn't make any sense to me. "Refused to execute" sounds like it might be due to some incompatibility in the query with the new spreadsheet, but that is just a wild guess. On Sat, Oct 3, 2020 at 12:38 AM Hartmut Gunther <h...@nutregy.com.au> wrote: > Thanks also for that Daniel. > I have implemented a new spreadsheet as indicated in addition to tidying > up the page for any javascript errors and simplifying code significantly. > Page speeds up greatly, however still get the load error - mostly on the > first time page is loaded - however on subsequent attempts seems fine. > > These are the type of errors I get from the javascript console - > > [Error] Failed to load resource: the server responded with a status of 429 > () (tq, line 0) > [Error] Failed to load resource: the server responded with a status of 429 > () (tq, line 0) > [Error] Failed to load resource: the server responded with a status of 429 > () (tq, line 0) > *[Error] Refused to execute > https://docs.google.com/spreadsheets/d/121gNWbe0b67RYplm8_nC2WX1ykyX3PIsbWO1uHnHmbc/gviz/tq?sheet=Sheet1&headers=9&tq=SELECT%20S,%20%20U%20%20where%20Q%20=%20%22sulphur%22%20%20limit%201000%20offset%200&tqx=reqId%3A32 > <https://docs.google.com/spreadsheets/d/121gNWbe0b67RYplm8_nC2WX1ykyX3PIsbWO1uHnHmbc/gviz/tq?sheet=Sheet1&headers=9&tq=SELECT%20S,%20%20U%20%20where%20Q%20=%20%22sulphur%22%20%20limit%201000%20offset%200&tqx=reqId%3A32> > as script because "X-Content-Type-Options: nosniff" was given and its > Content-Type is not a script MIME type.* > > Is it also possible that these come up due to a slow connection to my > server that hosts my website? These errors appear to indicate an > exponential backup intervention ? > > And finally - When the page works fine and loads fast there is still this > last residual error message (from the js console) that I can't seem to find > in my code - looks like a google js issue although I'm not sure > Error: Container is not defined - > https://www.gstatic.com/charts/48.1/js/jsapi_compiled_default_module.js > > *Example of recently updated page is here* - > https://www.toxtest.com.au/results/hair-analysis-2-u.html > > > *Also still can't load above page using v49 at all* > > > thanks Daniel > > Hartmut > > > > > On Saturday, 3 October 2020 at 00:03:40 UTC+10 Daniel LaLiberte wrote: > >> Yes, starting with a new spreadsheet document, even in the same account, >> should use the latest version of spreadsheets. I don't think that happens >> if you just copy a spreadsheet, however. >> >> On Thu, Oct 1, 2020 at 10:55 PM Hartmut Gunther <ha...@nutregy.com.au> >> wrote: >> >>> Thanks so much for the reply Daniel. >>> Just wanted to clarify - you mean to simply make a new spreadsheet >>> within my existing google docs account (and not create a whole new account) >>> >>> thanks again >>> >>> Hartmut >>> >>> On Friday, 2 October 2020 at 00:50:20 UTC+10 Daniel LaLiberte wrote: >>> >>>> 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 <ha...@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-visualizati...@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 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-visualizati...@googlegroups.com. >>> >> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/google-visualization-api/5724efaa-cf30-45fd-868c-e3cd3a0579d8n%40googlegroups.com >>> <https://groups.google.com/d/msgid/google-visualization-api/5724efaa-cf30-45fd-868c-e3cd3a0579d8n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> >> >> -- >> Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> >> 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/712f722e-dd44-4210-94c9-0506ab7c95f1n%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/712f722e-dd44-4210-94c9-0506ab7c95f1n%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/CAOtcSJOX89NR%2BP3za5jRm_fFGuJQQtU09GFE35tLuVuRyD88Gw%40mail.gmail.com.
