interactiveGraph Does Not Display

[jdstevens]

interactiveGraph stopped working on my site, http://wx.stevens.com (Desktop display). It displays the spinning update icon. It used to work. I'm not sure when it stopped working. I downloaded and reinstalled the block and experienced no change.

Operating system on the Linode server was recently updated from Ubuntu 14.04 LTS, through Ubuntu 16.04, to Ubuntu 18.04.

Dave Stevens
Bellville, TX, USA
dave@stevens.com
+1-713-419-0313

[jdstevens]

On further inspection, I find that NO graphs display.

Using Menu -> Statistics -> Temperature, I can see tables, but none of the choices will show graphs. The data are present. It appears that I may be missing something in the php installation that is required to create graphs.

I welcome suggestions. OS is Ubuntu 18.04 LTS. I use ISPConfig to manage the environment for websites.

http://wx.stevens.com

[Jachym]

Hi,
have you updated anything on your server?

[andyk1]

One thing you could look at is if you changed the background color to a light version as mine does not display correctly using my light color.

There is a tread on here somewhere, where others have had that problem and solved it by changing two of the php files in the interactivegrape block. Sorry I don't have time to find the thread for you. Maybe others can chime in.

Andy

[jdstevens]

Hi,
have you updated anything on your server?

Thank you for your reply.

I apologize for my slow reply to posts. I neglected to specify notifications for replies to my post. (Fixed now!)

On 02/04/2019, I updated OS Ubuntu 14.04 LTS -> Ubuntu 16.04 -> Ubuntu 18.04 LTS. I don't recall if the graphs were working immediately before the upgrades.

I tried reinstalling Meteotemplate using the same files as original installation. The result was the same (graphs did not work). I also built a separate server using Ubuntu 14.05. I installed Meteotemplate using the installation files on hand starting with files from 02/24/2017. Graphs still did not display.

The database is updating properly. All information displays as tables, but graphs don't plot.

I would like to install from scratch using a fresh download. I plan to use the current database, since it is updating properly. I requested a download twice, but did not receive a key. What do you suggest as my next action?

Dave
Dave@Stevens.com
http://wx.stevens.com

[Jachym]

Try executing this SQL command (ideally in PHPMyAdmin or directly on the server)

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

[jdstevens]

Wow! Your instructions were easy to follow, and effective.
interactiveGraph and combinedGraph work now!

Thank you!
Dave
http://wx.stevens.com

[Jachym]

Great

[jdstevens]

interactiveGraph is acting up again. It 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.

I'm not aware of any changes to my system that would affect interactiveGraph. All was working properly a few data ago.

??? Suggestions?