MySQL -> JpGraph Interface

[JyriT]

Multiline-standalone-graphs are working nicely
Thanks again !

[bdtripps]

Hi,
Thank you very much for the of the script. Have the standalone-graphs running here http://southwestweather.com/wx/wxMySQL7daygraphs.php

Thanks
BTrip

[tstorm]

I have noticed that the times on my graphs are two hours behind even before the time change today.  The server which I used is located 2 times zones behind mine.  I have tried to use the following in the common_en.php and wxmultigraph.php file:

$ourTZ = "EST5EDT";
putenv("TZ=$ourTZ");

You can see the graphs at http://www.harpersferry-weather.com/wxmultigraph.php

Ideas on how to fix this issue?

Thanks,
John

[TNETWeather]

$ourTZ = "EST5EDT";
putenv("TZ=$ourTZ");

According to your web server, you are using PHP/5.2.11.  It is quite possible that your provider is blocking the use of putenv as a potential security hole.

Since PHP 5.1.0, the correct method of setting the timezone has changed.  The correct way would be to use the new date_default_timezone_set command like:

date_default_timezone_set('America/New_York');

With the list of proper zones listed on the page:  http://www.php.net/manual/en/timezones.php

This may or may not be your actual problem, but it is a good place to start.

[tstorm]

Using the date_default_timezone_set('America/New_York');  didn't work.  Graphs are still off by 2 hours

John

[TNETWeather]

Sorry... was a guess.

Don't use the scripts you are using so I am not familiar with them or how they work.

[tstorm]

Need help!  Still having problems with my graphs being two hours off.  The server which I use is two time zones behind me.  I have tried the date_default_timezone_set('America/New_York'); in the comm_en.php and also the multigraph.php files.  

http://www.harpersferry-weather.com/wxmultigraph.php

Thanks,

John

Edit: Got it figured out  .  I tried multiple approaches to take in account the 2 hour time difference between where I'm located and the host server (-2 hours).  In the end I needed to add the following to my php.ini file:

date.timezone = "America/New_York";

[Herlev-DK]

Hi

I have this great script up and running now  
Can anyone help me how I get all my old data into Mysql?
Testpage:
http://www.herlev-vejret.dk/wxmultigraf.php

Steffen

[weatheroz]

Can anyone help me how I get all my old data into Mysql?

That's something that I am trying to do myself, but have found a issue with getting the old data in to the mysql db.

Old data that I have been able to import from earlier this year is incomplete, with things such as monthly/yearly rain, UV, and many other things missing.


I have posted this info to Brian in this thread :-
http://www.weather-watch.com/smf/index.php/topic,38944.0.html

Unfortunately it appears that he hasn't been able to issue a fix for it just yet, but I'm sure it'll get sorted out at some stage.

[tstorm]

Has anyone converted the charts over to flash or Highcharts with a mouse over capability?

[kalli51]

hi Krister, i try to using your Script ,i upload all to my website and if i try it comes this, use the link to view , http://ka-ra.org/webpages/multiwx_en.php   i got not a graph for the date what i select,may you have a idea what i did wrong .

best regards from Norway

Kalli 

watch  my Weatherstation  www.ka-ra.org

[kv-swe]

Hi!
When i run http://ka-ra.org/multiwx/testfile.php it returns "getmysql error" so you need to check your settings in common_en.php so it matches your database.

  Krister

[tstorm]

For some reason the graph is not coming up anymore.  I have not touch a thing with the script. Any ideas?

http://www.harpersferry-weather.com/wxmultigraph.php

Thanks,

john

[linuxfreak]

John, looks like no data after August 24th.


George

[gabba]

Hi!
When i run http://ka-ra.org/multiwx/testfile.php it returns "getmysql error" so you need to check your settings in common_en.php so it matches your database.

  Krister

Hi Krister
That's the error message I'm getting as well. I've checked the SQL database connection settings at least 5 or 6 times. I've tried resetting passwords, user permissions on the database etc., but essentially it's set up the same way as it is in WD, and WD connects and publishes the data okay to the database. JP graph appears to be set up and working okay (passes the Jpgraph install tests).Is there anything else I'm missing here?

http://www.huttweather.co.nz/jpgraph/multiwx/multigraph.php

I do have "localhost" for the $host variable, but if I change that to "huttweather.co.nz" then I get "unable to connect". Working through the get_data.php script I can see that using localhost gets me further down the script - so I'm sticking with localhost at this point. I'm not entirely sure why it would make that much of a difference - so there maybe is something in that, but I can't think why (hoster also recommendeds using localhost).

Any thoughts? (maybe something blindingly obvious?)

Cheers