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 -- 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/CAOtcSJNoGzXqpAgC3Ogg19Ze9X50kKKpmCH05Ow6wEqyxVAjRA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
