As you expected...New months, perfect charts! Thank You, Dan! Have a great 4th!
On Fri, Jul 1, 2016 at 6:54 AM, 'Daniel LaLiberte' via Google Visualization API <[email protected]> wrote: > The update for v45 (on the jsapi loader) finally did go out, but > unfortunately too late to fix the end of the month bug. I can tell it went > out by examining the code itself. > > On Thu, Jun 30, 2016 at 6:01 PM, Daniel LaLiberte <[email protected]> > wrote: > >> OK, wrong again. Both my previous examples actually fail in the same way, >> when I load "1.0", but they both succeed when I load "1.1". So the fix >> for the Date problem is correct, but it actually appears that the push to >> production has not quite finished, or perhaps I made a mistake in how it >> was done. If it does finish completely, it may be too late for people to >> see by the end of today. >> >> If you want to see the fix now, you can switch to loading "1.1". Or you >> can switch to loading from gstatic. >> >> In any event, I'll make sure this is fixed properly in plenty of time >> before the next end of month. >> >> On Thu, Jun 30, 2016 at 1:06 PM, Daniel LaLiberte <[email protected]> >> wrote: >> >>> OK, here is an example that fails: >>> https://jsfiddle.net/dlaliberte/a8w94w70/ >>> Still not sure why, and what is different from the case that works. But >>> at least it is reproducible. >>> >>> On Thu, Jun 30, 2016 at 12:04 PM, Daniel LaLiberte < >>> [email protected]> wrote: >>> >>>> I take it back. All the charts look the same to me, but I was reading >>>> them wrong. Had my coffee now, and everything appears to be working >>>> correctly. Check this example out: >>>> https://jsfiddle.net/dlaliberte/g1cxenea/ >>>> >>>> What am I missing? You may be getting cached copies of the code, so >>>> try flushing your cache. If it still fails for you, please show me a >>>> relatively simple example where it fails and I will check it out. Thanks. >>>> >>>> On Thu, Jun 30, 2016 at 10:07 AM, Daniel LaLiberte < >>>> [email protected]> wrote: >>>> >>>>> The update appears complete, but I don't see the date working. >>>>> >>>>> Furthermore, I don't see dates working properly even on the gstatic >>>>> server. So I am confused. Sorry about all this. >>>>> >>>>> Perhaps what we thought was a fix really wasn't doing it right after >>>>> all. >>>>> >>>>> Even if I start reverting this update, it won't finish until tomorrow, >>>>> at which time the date problem will be "fixed" again anyway for another >>>>> month. >>>>> >>>>> >>>>> On Thu, Jun 30, 2016 at 6:23 AM, Brandon Matthews < >>>>> [email protected]> wrote: >>>>> >>>>>> Awesome....I hope You Haven't Applied the Fix Yet Because right now, >>>>>> 2016 is now infected, lol: >>>>>> >>>>>> >>>>>> >>>>>> <https://lh3.googleusercontent.com/-wKbv7Z3uUsg/V3TyowKmE8I/AAAAAAAACfA/-x7kt-pja3gTQfHKDJ-EDwjJApwe0wKnQCLcB/s1600/googa.JPG> >>>>>> >>>>>> >>>>>> <https://lh3.googleusercontent.com/-cTkPDxGc2h4/V3TysQujWhI/AAAAAAAACfI/jQV0u4hHR9Al8fdZweeWNwsD6x79urWrACLcB/s1600/googb.JPG> >>>>>> >>>>>> >>>>>> <https://lh3.googleusercontent.com/-FG7LdNsqp8g/V3TyxByBjBI/AAAAAAAACfQ/cBkUePjymAkdBstSnfXEGs2dlJTXri4KQCLcB/s1600/googc.JPG> >>>>>> ... >>>>>> >>>>>> >>>>>> I know you're on it....just busting em on ya... >>>>>> >>>>>> >>>>>> Thank You for always being helpful; I couldnt have done anything like >>>>>> this without your guidance..Just sayin...sniff sniff... >>>>>> >>>>>> >>>>>> Dom >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> On Wednesday, June 29, 2016 at 2:36:21 PM UTC-4, Daniel LaLiberte >>>>>> wrote: >>>>>>> >>>>>>> Hi Dom, >>>>>>> >>>>>>> There is a bug that shows up at end of every month, but I forgot >>>>>>> that February doesn't have a day 29. I am about to push out an update >>>>>>> that >>>>>>> should resolve this, but I thought I had an extra day. Sorry. Should >>>>>>> be >>>>>>> fixed in a few hours. >>>>>>> >>>>>>> On Wed, Jun 29, 2016 at 2:27 PM, Brandon Matthews < >>>>>>> [email protected]> wrote: >>>>>>> >>>>>>>> >>>>>>>> <https://lh3.googleusercontent.com/-zYYQiyo7oj8/V3QNO4PV7PI/AAAAAAAACew/JQLYoewpyoIzyeYJ4KBf2vdUFy5-0kpSgCLcB/s1600/goog5.JPG> >>>>>>>> >>>>>>>> >>>>>>>> <https://lh3.googleusercontent.com/-oEHGqMCQqGA/V3QAaMSi9BI/AAAAAAAACeg/rZyk2FmEscs9EtNvyPFhYr4kwcPeyunZACLcB/s1600/goog4.JPG> >>>>>>>> Hi Dan & Co.! >>>>>>>> >>>>>>>> Hope all are well! >>>>>>>> >>>>>>>> I too have just fallen victim to this bug that's going around, that >>>>>>>> is wreaking havoc with the chart displays: >>>>>>>> >>>>>>>> I saw this occur earlier in the year, over a weekend, but the >>>>>>>> following Monday it resolved on its own: Chalked it up to some update >>>>>>>> being >>>>>>>> run or such ...in that instance, 2016 was affected also, but this time >>>>>>>> it >>>>>>>> seems to be only 2014 and 2015: >>>>>>>> >>>>>>>> >>>>>>>> <https://lh3.googleusercontent.com/-3rg9UrjFB2o/V3P-eHUZn4I/AAAAAAAACd8/clzPhHuLX_Q8hkcLNtYu-1FSEauz-9z-gCLcB/s1600/goog.JPG> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Zoom in 2014: No Feb Data: Feb Data intertwined with March >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> <https://lh3.googleusercontent.com/-y-7U1gnE3w0/V3P-u-eMuEI/AAAAAAAACeE/Xc57QdGrbIsiV-EhK-glHIIrLs-NlxD6QCLcB/s1600/goog1.JPG> >>>>>>>> >>>>>>>> >>>>>>>> Zoom in 2015 : No Feb Data: Feb Data intertwined with March >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> <https://lh3.googleusercontent.com/-4Aa77-CwflU/V3P-08NfdTI/AAAAAAAACeM/B5JD3bZr0NQkyfd9q9wT4XR8UmKuHs77ACLcB/s1600/goog2.JPG> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Zoom in 2016, Normal >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> <https://lh3.googleusercontent.com/-kT-peFluQsU/V3P-7Vde_cI/AAAAAAAACeU/atCfeMXcb0Qz8OUXvcJ_NfU1pITFtmVrQCLcB/s1600/goog3.JPG> >>>>>>>> >>>>>>>> >>>>>>>> Different Charts, Different MySQL Database. Same results: >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> <https://lh3.googleusercontent.com/-oEHGqMCQqGA/V3QAaMSi9BI/AAAAAAAACeg/rZyk2FmEscs9EtNvyPFhYr4kwcPeyunZACLcB/s1600/goog4.JPG> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Here's a basic mysql script - variable names changed to protect the >>>>>>>> innocent >>>>>>>> >>>>>>>> >>>>>>>> <?php >>>>>>>> >>>>>>>> >>>>>>>> include("conn.php"); >>>>>>>> >>>>>>>> >>>>>>>> $query="SELECT EXTRACT(YEAR FROM `date`) AS 'year', >>>>>>>> >>>>>>>> EXTRACT(MONTH FROM `date`) AS 'month', >>>>>>>> >>>>>>>> EXTRACT(DAY FROM `date`) AS 'day', >>>>>>>> >>>>>>>> `close`, >>>>>>>> >>>>>>>> `anot_code`, >>>>>>>> >>>>>>>> `alerts` >>>>>>>> >>>>>>>> FROM `mySQL_db_2014` >>>>>>>> >>>>>>>> WHERE `symbol`='MNKD' >>>>>>>> >>>>>>>> UNION ALL >>>>>>>> >>>>>>>> SELECT EXTRACT(YEAR FROM `date`) AS 'year', >>>>>>>> >>>>>>>> EXTRACT(MONTH FROM `date`) AS 'month', >>>>>>>> >>>>>>>> EXTRACT(DAY FROM `date`) AS 'day', >>>>>>>> >>>>>>>> `close`, >>>>>>>> >>>>>>>> `anot_code`, >>>>>>>> >>>>>>>> `alerts` >>>>>>>> >>>>>>>> FROM `mySQL_db_2015` >>>>>>>> >>>>>>>> WHERE `symbol`='MNKD' >>>>>>>> >>>>>>>> FROM `mySQL_db_2015` >>>>>>>> >>>>>>>> WHERE `symbol`='MNKD' >>>>>>>> >>>>>>>> UNION ALL >>>>>>>> >>>>>>>> SELECT EXTRACT(YEAR FROM `date`) AS 'year', >>>>>>>> >>>>>>>> EXTRACT(MONTH FROM `date`) AS 'month', >>>>>>>> >>>>>>>> EXTRACT(DAY FROM `date`) AS 'day', >>>>>>>> >>>>>>>> `close`, >>>>>>>> >>>>>>>> `anot_code`, >>>>>>>> >>>>>>>> `alerts` >>>>>>>> >>>>>>>> FROM `mySQL_db_2016` >>>>>>>> >>>>>>>> WHERE `symbol`='MNKD' ORDER BY `year` ASC, `month` ASC, `day` >>>>>>>> ASC"; >>>>>>>> >>>>>>>> >>>>>>>> $tabletr=array(); >>>>>>>> >>>>>>>> >>>>>>>> $table['cols']=array( >>>>>>>> >>>>>>>> array('label' => 'Date', 'type' => >>>>>>>> 'date','role' => 'domain'), >>>>>>>> >>>>>>>> array('label' => 'Close', 'type' => 'number', >>>>>>>> 'role' => 'data'), >>>>>>>> >>>>>>>> array('label' => '', 'type' =>'string', >>>>>>>> 'role' => 'annotation'), >>>>>>>> >>>>>>>> array('label' => '', 'type' =>'string', >>>>>>>> 'role' => 'annotationText') >>>>>>>> >>>>>>>> ); >>>>>>>> >>>>>>>> $table['rows']=$rows; >>>>>>>> >>>>>>>> >>>>>>>> $chartdata=mysql_query($query); >>>>>>>> >>>>>>>> >>>>>>>> while($r=mysql_fetch_assoc($chartdata)) { >>>>>>>> >>>>>>>> $temp=array(); >>>>>>>> >>>>>>>> $r['date']= >>>>>>>> array($r['year'], $r['month']-1, $r['day']); >>>>>>>> >>>>>>>> $r['date']=implode(",", >>>>>>>> $r[('date')]); >>>>>>>> >>>>>>>> $temp[]=array('v' >>>>>>>> =>"Date(".$r['date'].")"); >>>>>>>> >>>>>>>> $temp[]=array('v' => >>>>>>>> (float) $r['close']); >>>>>>>> >>>>>>>> $temp[]=array('v' => >>>>>>>> $r['anot_code']); >>>>>>>> >>>>>>>> $temp[]=array('v' => >>>>>>>> $r['alerts']); >>>>>>>> >>>>>>>> $rows[]=array('c' => >>>>>>>> $temp); >>>>>>>> >>>>>>>> }; >>>>>>>> >>>>>>>> $table['rows']=$rows; >>>>>>>> >>>>>>>> $jsondata=json_encode($table); >>>>>>>> >>>>>>>> echo $jsondata; >>>>>>>> >>>>>>>> ?> >>>>>>>> >>>>>>>> >>>>>>>> Use this link for resulting json data: better than sticking 3 years >>>>>>>> of data here: >>>>>>>> >>>>>>>> >>>>>>>> http://www.stockshortdata.com/functions/googtest.php >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> ...but here's a screenshot of the 2014 return: Feb $ March >>>>>>>> highlighted: >>>>>>>> >>>>>>>> >>>>>>>> <https://lh3.googleusercontent.com/-zYYQiyo7oj8/V3QNO4PV7PI/AAAAAAAACew/JQLYoewpyoIzyeYJ4KBf2vdUFy5-0kpSgCLcB/s1600/goog5.JPG> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> ...and a chart script if you'd like: >>>>>>>> >>>>>>>> <script type='text/javascript'> >>>>>>>> google.load('visualization','1',{packages:['annotationchart']}); >>>>>>>> google.setOnLoadCallback(drawChrt); >>>>>>>> function drawChrt() { >>>>>>>> var data=new >>>>>>>> google.visualization.DataTable(<?=$jsonanot?>); >>>>>>>> var options={ >>>>>>>> title:'MNKD:Short Volume Alert >>>>>>>> Price Chart', >>>>>>>> width:'96%', >>>>>>>> height:'400', >>>>>>>> displayAnnotations:'true', >>>>>>>> displayAnnotationsFilter:'true' >>>>>>>> }; >>>>>>>> var chart =new >>>>>>>> google.visualization.AnnotationChart(document.getElementById( >>>>>>>> 'alerts_div')); >>>>>>>> chart.draw(data,options); >>>>>>>> }; >>>>>>>> </script> >>>>>>>> >>>>>>>> I recall reading that it may be a leap year issue, but as I >>>>>>>> mentioned, the problem resolved itself by the time I sat don to work >>>>>>>> that >>>>>>>> Monday... >>>>>>>> >>>>>>>> Any ideas and does this perhaps help isolate the bug? >>>>>>>> >>>>>>>> If the problem is on Google's end, and you want to troubleshoot it, >>>>>>>> the above charts can be located at the following pages: >>>>>>>> >>>>>>>> Annotation Chart: http://www.stockshortdata.com/ >>>>>>>> >>>>>>>> Line Chart: http://www.stockshortdata.com/dow/ >>>>>>>> >>>>>>>> If you can resolve it on your end again, you'll see it there when >>>>>>>> you do. >>>>>>>> >>>>>>>> Thanks in advance for any solution suggestions as well... >>>>>>>> >>>>>>>> Dom >>>>>>>> >>>>>>>> -- >>>>>>>> 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 >>>>>>>> [email protected]. >>>>>>>> To post to this group, send email to >>>>>>>> [email protected]. >>>>>>>> Visit this group at >>>>>>>> https://groups.google.com/group/google-visualization-api. >>>>>>>> To view this discussion on the web visit >>>>>>>> https://groups.google.com/d/msgid/google-visualization-api/4cd512a5-8bf1-4f22-9354-9606259b38b8%40googlegroups.com >>>>>>>> <https://groups.google.com/d/msgid/google-visualization-api/4cd512a5-8bf1-4f22-9354-9606259b38b8%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>> . >>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Daniel LaLiberte >>>>>>> <https://plus.google.com/100631381223468223275?prsrc=2> >>>>>>> [email protected] 5CC, 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 >>>>>> [email protected]. >>>>>> To post to this group, send email to >>>>>> [email protected]. >>>>>> Visit this group at >>>>>> https://groups.google.com/group/google-visualization-api. >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/google-visualization-api/b5ab4150-af6a-4119-905b-fb16f0b2d3d9%40googlegroups.com >>>>>> <https://groups.google.com/d/msgid/google-visualization-api/b5ab4150-af6a-4119-905b-fb16f0b2d3d9%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Daniel LaLiberte >>>>> <https://plus.google.com/100631381223468223275?prsrc=2> >>>>> [email protected] <[email protected]> 5CC, Cambridge MA >>>>> >>>> >>>> >>>> >>>> -- >>>> Daniel LaLiberte >>>> <https://plus.google.com/100631381223468223275?prsrc=2> >>>> [email protected] <[email protected]> 5CC, Cambridge MA >>>> >>> >>> >>> >>> -- >>> Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> >>> [email protected] <[email protected]> 5CC, Cambridge MA >>> >> >> >> >> -- >> Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> >> [email protected] <[email protected]> 5CC, Cambridge MA >> > > > > -- > Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> > [email protected] <[email protected]> 5CC, Cambridge MA > > -- > You received this message because you are subscribed to a topic in the > Google Groups "Google Visualization API" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/google-visualization-api/hdp_NgVG6q8/unsubscribe > . > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > https://groups.google.com/group/google-visualization-api. > To view this discussion on the web visit > https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJPn5zp58bwJZ2T%3D_gs_WDE7PeVEVXgioGzuBs8uN70G0g%40mail.gmail.com > <https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJPn5zp58bwJZ2T%3D_gs_WDE7PeVEVXgioGzuBs8uN70G0g%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CALyjH2NXb0xA1Y_aA_L4ZhXRH_9is1rFm746PzfHxA-Zj3knaA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
