why does dark theme not stay dark all the time? I notice in my web browser that during refresh it changes to the bright theme, then I have to back and switch it again
Still canāt figure out how to setup historical data. Am I supposed to setup the mysql settings in WD as well as the database and table setup on my ftp server?
In easyweather you define the most used theme, in your case ādarkā. If a visitor changes that to light, that temporary change is stored in a cookie in his/her browser. Some users set the use of cookies in their browser to false, so the temporary setting is not kept between refreshes
You can not do that with a setting. Only by changing the scripts themselves. Be aware that all other links to menu items are lost then also
3. Can I use a tablet to display the above link and have it display in landscape mode, similar to desktop appearance?
It should always display exactly the same way as on a desktop when you hold the tablet in landscape mode. It can switch to āphone modeā when holding the tablet vertically. There is a minimum width for phone-type-devices, below that width only the important blocks are shown one below each other.
With āhistorical data.ā do you mean: the graphs? They get their data either from your own WU data. Or from the data-table on your webserver.
Using the webserver to store historical data correctly, you should also run the cron-jobs: every 10 minutes plus just before and just after midnight.
Storing the information in the database-table and generating your own daily, monthly and yearly .csv files is described in:
Wim
P.S. Now your scripts seems to work, you should install the updates also. http://wd34.weather-template.com/ ==> Downloads ==> Third row Updated scripts up to 2019-01-19
In this link http://wd34.weather-template.com/documentation/WD34-SQL-2019-01.pdf, it says to import the file w34_util_weatherstation_mysql. I donāt have that file in pwsWD. I only have w34_util_weatherstation_sql. I can see my table has been created in phpmyadmin but it is empty. In WD when I run mysql, it says āno databaseā selected. So I selected the database, but the List of Tables field is blank, so I canāt select āweatherstationā as the table. See pic.
@jzinckgra: Your screenshots would be easier to capture/post and a lot easier to read if you use the Windows Snipping Tool* which is included in Win 7/8/10. Also .png is usually a better format to use for graphical pages than .jpg which uses data compression optimized for real photographic images.
Now called Snip 'n Sketch in latest Win 10 Iām toldā¦
No. Itās beause the image is shrunk down very small on a big canvas (the white area), Iām not familiar with using paint so I donāt know how that occurs :dontknow:
not sure why you are trying to use WDās mysql program?
it wont be able to update the weather34 mysql data if that is what you are trying to doā¦its not intended or needed to do that
Brian,
In easyweathersetup, under historical data: āWhich script will load the weather-data to your databse?ā Do you know if I select āstationcron job will do database loadā or āWdapi script will do database loadā
To load your data to the sql-table on your server you use a script which runs 24/7 at a fixed interval, say every 5 or 10 minutes.
You can choose either of the two:
If you use WDapi you can use that one. A small drawback: if you are uploading very fast, f.i. every 5 seconds, the table will grow rapidly.
If you use the 10 minute station-cron you can use that one. That is the valid choice for clientraw upload also.
Just before midnicht the second cron will calculate the high-lows of today and store a line with those totals in the Yearly and Monthly .CSV files.
To clean the daily sql-table the third cron job will delete all rows from the sql table just after midnight.
To use all, this the PC with WeatherDisplay should run 24/7 and not be restarted during 11:45 PM and 00:15 AM as some users tend to do.
I thought I had this figured out:), on my popup temp block, my timestamp for most recent temp is incorrect. The X-axis reports the wrong time. http://www.weather911.net/pwsWD/index.php
Connect failed: Access denied for user 'Jzinckgr_weatherstation'@'162.144.12.159' (using password: YES)
Some answers point to the privileges again:
Maybe your Database is not at address 162.144.12.159 Probably that is the ip-number when you look to the database from your home.
The scripts run already at your server, so most of the times it is ālocalhostā or sometimes ā127.0.0.1ā
But as I have no experience with your hosting company I am not sure what the problem could be or how your settings should read. Sorry, for this someone else has to answer these questions.
Succes, Wim