The dupe key is fine. I will research a better method to add an index but for this version it’s not an issue. I am spending most of the time finding ways to speed up the code and not produce data for scripts not used.
There are some that only use Archive to store data so no need to waste processor power to preform tasks not needed.
Gary
Again, It’s all good. I love the display. Your doing a great job on this project, Its better than all the other third-party apps in my opinion.Thanks again for your hard work!!!
I don’t see it as better, but different. It’s the only product that is 100% Internet independent of WeatherFlow servers. It does all it’s work from only the UDP data.
I built this to tie into my home automation system and it does much more than what you see. It communicates with the irrigation system, the alarm system, the HVAC system (which includes all the fans in the house), the energy monitoring system and a few other small systems.
I continue to add features such as tipping buckets, temperature probes and humidity probes. I’m considering adding light probes while I await for the Breathe.
And all the while I am having fun developing this thing.
The date/time will flash red on the display when there are updates to processes that need to be restarted.
You may now clear this alert by clicking or touching on date/time.
Heh, saw the red blinking and naturally clicked on it. Tada, it now is all happy. Good stuff!
I glad to hear it worked for you. I see there is an issue with first light. It seems it’s getting set to 0 at midnight instead of null. I’ll get that fixed this morning.
Fortunately I am running out of issues to fix.
Sorry Gary. I just tried to do a clean install with the script and got the following error.
Server won’t start
Well, that was rather silly of me. Yes, I made a bugger. The quick fix is to use nano to create version.json and simply add {} to the file and save it.
Or do this:
wget -N http://fsoft.com/archivesw/1.7.13.025/util.js
from a terminal window and then run: node updatefiles
My apology for the error.
Ran the wget command and tried updatefiles and got this error.
When you ran wget, did is actually download a new file? Did util.js update?
Yep, It downloaded version 1.7.13.025
Try creating a dummy version.json file with only “{}” as the text. Do not add the quotes.
That seemed to work. I’ll yet you know if anything else pops up.
Thanks!
I am still concerned because the new util.js should handle that.
Something is missing.
I can test the script again anytime.
Just let me know.
When you are fully up again, you can delete version.json and run updatefiles. It should create the file.
I deleted the file version.json and ran update files. It recreated the file as you thought it would.
Thank you. Now I have to find why it did not work the first time.
I have uploaded a new altertables.js to the server.
The version number has not changed because I don’t want users seeing it and running it without warning.
This version contains a LOT of changes and may take up to 10 minutes to run. The application will examine every table and every index and make corrections. Some indexes will be dropped permanently , some will be dropped and recreated and others will be newly created.
The changes correct mistakes I made and bring your database fully up-to-date. After you run the application, check the AlterTables.log for any errors. There are some indexes that require unique records and if you have duplicates the creation will error. If you find this to be the case, contact me and I’ll help you find the issues.
I am finding that I spend more time writing code to check for errors and correct issues than writing the application code itself. The entire application is growing and I want this to be rock solid by the end of the year.
Thank you, to all that have helped improve this application. It’s been a pleasure working with you and I look forward to providing you with the stability you desire.
Gary
took less then a minute this morning
2018-11-11 08:51:17 Starting AlterTables v1.7.13.025
2018-11-11 08:51:17 MariaDB connected
2018-11-11 08:51:17 Droping table index: DailySky
2018-11-11 08:51:17 Dropped table index: DailySky serial_numnber
2018-11-11 08:51:17 Droping table index: PrecipEvent
2018-11-11 08:51:17 Dropped table index: PrecipEvent serial_numner
2018-11-11 08:51:17 Droping table index: SkyObservation
2018-11-11 08:51:25 Dropped table index: SkyObservation timestamp_serial_number_hub_sn
2018-11-11 08:51:25 Droping table index: StrikeEvent
2018-11-11 08:51:25 Dropped table index: StrikeEvent timespamp
2018-11-11 08:51:25 Checking table index: AirBackfill
2018-11-11 08:51:25 Creating table index: AirBackfill strike_count
2018-11-11 08:51:25 Creating table index: AirBackfill strike_distance
2018-11-11 08:51:25 Checking table index: AirObservation
2018-11-11 08:51:25 Creating table index: AirBackfill battery
2018-11-11 08:51:31 Creating table index: AirObservation strike_count
2018-11-11 08:51:38 Creating table index: AirObservation strike_distance
2018-11-11 08:51:46 Creating table index: AirObservation battery
2018-11-11 08:51:46 Checking table index: DailyAir
2018-11-11 08:51:46 Checking table index: DailySensor
2018-11-11 08:51:46 Checking table index: DailySky
2018-11-11 08:51:46 Creating table index: DailySky serial_number
2018-11-11 08:51:46 Checking table index: DeviceEvents
2018-11-11 08:51:46 Checking table index: DeviceStatus
2018-11-11 08:52:02 Altering table index: DeviceStatus hub_sn_serial_number
2018-11-11 08:52:02 Checking table index: FWUpdate
2018-11-11 08:52:02 Checking table index: HubEvents
2018-11-11 08:52:02 Checking table index: HubStatus
2018-11-11 08:52:02 Checking table index: PrecipEvent
2018-11-11 08:52:02 Creating table index: PrecipEvent serial_number
2018-11-11 08:52:02 Checking table index: RapidWind
2018-11-11 08:52:02 Checking table index: SkyBackfill
2018-11-11 08:52:02 Altering table index: SkyBackfill serial_number_timestamp
2018-11-11 08:52:02 Checking table index: SkyObservation
2018-11-11 08:52:10 Creating table index: SkyObservation serial_number_timestamp_hub_sn
2018-11-11 08:52:10 Checking table index: StrikeEvent
2018-11-11 08:52:10 Creating table index: StrikeEvent timestamp
2018-11-11 08:52:10 Checking table index: Xrain
2018-11-11 08:52:10 Checking table index: Z_version
2018-11-11 08:52:10 Process changes complete
2018-11-11 08:52:10 Update version complete
2018-11-11 08:52:10 Wrote config.json
2018-11-11 08:52:10 Update config complete
2018-11-11 08:52:10 MariaDB disconnected