interactiveGraph Shows Only Spinning Icon

[jdstevens]

interactiveGraph only displays the spinning icon.

The database is updating every five minutes. I can view it with Sequel Pro. Other blocks are displaying proper data. graphCombined is showing valid information.

??? Suggestions?

[John B]

Hello, JDS,

It seems at first blush that, if everything else is working as it should, then there might be something in your block set up for the InteractiveGraph that is out of kilter; perhaps an entry which is outside its built-in parameters.

You will find an image of the bottom section of my set up page here:
http://www.johnsblaxlandweather.id.au/I ... active.jpg

The image is missing the top of the page, but that is only relating to colours.

By all means click on the 'banner' at the bottom of this post to visit my site and see the interactive graph in use.

Regards,
John

[jdstevens]

Thank you for the reply.

The graph has worked in the past. I'm not aware of any changes that caused the interactiveGraph to stop working. The settings are all default settings. Most other blocks and functions that query the database work properly. I have deleted and reinstalled the interactiveGraph, and it still fails.

I went through functions under the "Weather Station" menu. Most work. Some don't. It appears that the database in populated and function. However, the modules are not consistently working properly. I am considering reinstalling Meteotemplate from scratch. I'll keep the existing database and other infrastructure.

[jdstevens]

"interactiveGraph" continues to show only spinning icon. I've not figured out the problem. I had a suggestion that there is a bad parameter, but I've found no faulty inputs. The database is being updated. The "graphCombined" shows correct information.

http://wx.stevens.com

[Asobig]

From the debug screen in Chrome i see an error in parsing the Temperature parameter.

[jdstevens]

Thank you for looking for the problem with "interactiveGraph" on my site. Unfortunately, I don't know what to do with the information you provided. All parameters for the block are default parameters. I have deleted and reinstalled the block. Other blocks exhibit no problem displaying temperature information from the database. The "graphCombined" displays the temperature, and other information, in a different display.

???

[jdstevens]

Fixed. I ran the following command that was provided by Jachym three months ago:

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

I ran the command immediately after he provided it. It fixed interactiveGraph and combinedGraph. Neither was working.

Later, interactiveGraph quit working, while combinedGraph continued to work. I mistakenly assumed that there was a new problem when interactiveGraph failed, while combinedGraph continued to work. My assumption was wrong. Immediately after running the command again, interactiveGraph started working, and combinedGraph continues to work.

http://wx.stevens.com

[John B]

Well done, jds, a sterling job, sir. Give yourself a gold star and accept my congratulations.