ArchiveSW - Display & Data Archive Storage

udp
nodejs
wfarchive
archivesw

#1002

I am going to open up the USB cable to measure the current flow with a Fluke 287. I’ll either get a true reading or I’ll blow up a power supply and maybe the Hub. What could possible go wrong? :slight_smile:


#1003

Just start receiving those messages:

2019-01-31 13:00:02 Starting DailyStats v1.7.15.030
2019-01-31 13:00:02 Error in updateDailyAirRecord ER_BAD_FIELD_ERROR: Unknown column ‘NaN’ in ‘field list’
2019-01-31 13:00:07 No errors encountered

Nothing was changed in database by me. database and files are up to date (latest version). Any idea what is happening?


#1004

I measured with my powerbank and that reads 0.1 A at 5.01 V (current goes only in 0.1 A units, so it can be anywhere between 0.05 and 0.15 A, assuming it rounds correctly)


#1005

I have no idea. Try running AlterTables.


#1006

I tried already, also tried to run repairtable.js but result is same. What kind of column is NaN? I will add it manualy.


#1007

NaN is not a field in any table. It’s an error meaning Not a Number.

Something else is happening to cause that error.


#1008

For last two days in DailyAir below field are empty: TempHD, TempLD, PressHD, PressLD and all fields right from PressLD. Does this saying something usefull?


#1009

Run UpdateFiles from the About tab. I added some new error output in dailystats.js that should show the error.

You can manually run dailystats from a terminal window and then look at the log file to see the output.


#1010

2019-01-31 19:04:14 Error in updateDailyAirRecord ER_BAD_FIELD_ERROR: Unknown column ‘NaN’ in ‘field list’ 2019-01-31 19:04:14UPDATE DailyAir SET insert_datestamp = NOW(), tempH = 1.33,tempHT = 1548939007,tempHD = ‘2019-01-31 13:50:07’,tempL = -0.29,tempLT = 1548907278,tempLD = ‘2019-01-31 05:01:18’,presH = 980,presHT = 1548957784,presHD = ‘2019-01-31 19:03:04’,presL = 975.9,presLT = 1548904639,presLD = ‘2019-01-31 04:17:19’,humH = 0,humHT = 1548889226,humHD = ‘2019-01-31 00:00:26’,humL = 0,humLT = 1548889226,humLD = ‘2019-01-31 00:00:26’,strikeH = 0,strikeHT = null,strikeHD = null,strikeTotal = 0,strikeTime = 0,strikeDistance = 0,dewH = NaN,dewHT = 1548889226,dewL = NaN,dewLT = 1548889226,airdenH = NaN,airdenHT = 1548889226,airdenL = NaN,airdenLT = 1548889226,denaltH = NaN,denaltHT = 1548889226,denaltL = NaN,denaltLT = 1548889226 WHERE today = ? AND serial_number = ? 2019-01-31 19:04:16 No errors encountered


#1011

Sorry for formatting, this is additionally in LOG


#1012

For some strange reason, your Humidity High and Low is 0 (zero) which is not possible.


#1013

Yes, I just discovered that, started few days ago. Dropping from 90 to 40, then decreasing to 0 over time. Currently humidity reading is 0. Maybe sensor is dead…


#1014

Contact support@weatherflow.com about the Air.

I am working on code to catch and correct for the error. Stand-by for new updated files.


#1015

New files posted, run Update Files and manually run dailystats.


#1016

Ok, thank you Gary. I sent email to support.


#1017

:-(( new error:

pi@raspberrypi:~/archivesw $ node dailystats.js
(node:8239) UnhandledPromiseRejectionWarning: TypeError: Cannot read property ‘toFixed’ of null
at Object.WeatherCalc.calcDewPoint (/home/pi/archivesw/weathercalc.js:183:27)
at res.forEach.item (/home/pi/archivesw/dailystats.js:315:13)
at Array.forEach ()
at resolve (/home/pi/archivesw/dailystats.js:313:8)
at new Promise ()
at /home/pi/archivesw/dailystats.js:310:10
at
at process._tickCallback (internal/process/next_tick.js:188:7)
(node:8239) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 2)
(node:8239) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.


#1018

I corrected that error, please try again, new files, run manually.


#1019

Something additional …

Linux raspberrypi 4.14.79-v7+ #1159 SMP Sun Nov 4 17:50:20 GMT 2018 armv7l

The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Thu Jan 31 19:50:39 2019 from 192.168.88.11
pi@raspberrypi:~ cd archivesw/ pi@raspberrypi:~/archivesw node dailystats.js
(node:9344) UnhandledPromiseRejectionWarning: TypeError: Cannot read property ‘H’ of null
at res.forEach.item (/home/pi/archivesw/dailystats.js:318:23)
at Array.forEach ()
at resolve (/home/pi/archivesw/dailystats.js:313:8)
at new Promise ()
at /home/pi/archivesw/dailystats.js:310:10
at
at process._tickCallback (internal/process/next_tick.js:188:7)
(node:9344) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 2)
(node:9344) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.


#1020

AIR was faulty, answer from WF really express! They will send me replacement unit.


#1021

Okay. New file, please try again.