Most graphs/options not responding

[Ron]

I'm having a problem with most of the graphs in meteotemplate not working.
Current Data page works fine. Past that, it gets sort of hit and miss.
Interactive graph page loads, but sits with the spinning indicator.

Selection_006.png (19.93 KiB) Viewed 7274 times

I scrolled up, and noticed this at the bottom of the page of the Interactive graph.

Selection_007.png (9.94 KiB) Viewed 7274 times

The Weather/Outlook page loads, but no icons/buttons respond. no graphs seen.

The only graph I can see working, is the station climate.

graph.png (45.73 KiB) Viewed 7274 times

Things I have tried;
Removed it from the server, reinstalled twice to make sure all files were replaced.
Tested with 2 different computers (Linux)
Tested with Google Chrome, Firefox, and Chromium
I then did an installation on another domain I have. Works exactly the same way. Still the odd "ok" box and to-from at the bottom of the page.
I tried the installations after clearing cache, rebooting machine, clearing cookies.
I tried installing and leaving off the Interactive header.
I also did as basic an install as possible as far as optional options.
Each time I reinstalled, the files were removed from server, database deleted and new one set up.
Java script is enabled, no popup blocker, no ad-blocker.

Could it be that when I downloaded the template file, it corrupted for some unknown reason? and that is why totally replacing the files on each install makes no difference?

I'm stumped, the template loads without hesitation. No problem changing any settings.
The database is updating as it should.

Any help appreciated to figure it out. I really like the program.
Link to the site is http://www.castlekeepdanes.com/weewx2/t ... esktop.php
Thanks,
Ron

[Jachym]

Hi,
the problem could be the sql_mode group by setting.
See http://johnemb.blogspot.cz/2014/09/addi ... modes.html

Removes SQL Mode ONLY_FULL_GROUP_BY only

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

[Ron]

Thanks for the response. I really appreciate it. I ran the command you gave and got this error,
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
MySQL said: Documentation

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

It didn't clear the problem.

The strange elements are still at the bottom of the Interactive Graph page. (Okay box, and the words to: and from:)
Is there any chance that it is caused by corrupted files that occurred when I uploaded them to the server.? I don't mind starting from scratch, as I have not done that much on it.

I'm not real good at SQL I must confess. I can use phpMyadmin for some things, but I am not that up on sql commands. I knew how to run the provided command you gave me using myphpadmin, but that's about it.

Thanks for the time and help you provide.

[Ron]

Sorry for the double post, but I wanted to save time and work. I thank all of you for the help given. The problem was in the "Page Name". I had, Ron's Country Weather. Something Jachym said in a post about an @ character causing problems I found yesterday, popped back in my head this evening as I sat staring at the screen. I removed the "apostrophe" from my name, and everything went back to normal!

I duplicated this on two different servers. With an apostrophe in the Page Name, anywhere in that block, many pages exhibited failed loading, no graphs, and some buttons would not work to select options.

Removing the apostrophe also cleared up the strange "ok" block and text that was showing at the bottom of the screen that was outside of the page layout.

Thank you Jachym and everyone for all the help. Maybe this will help someone in the future. Now it's time for me to start enjoying it.

Ron

[Jachym]

Hi,
ok, glad you solved the problem, it is strange, the settings page should replace apostrophes with their corresponding HTML symbol, not sure why it doesnt do this...