WeatherStem not updating Error with sql ..?

les1397
New Member

Posts: 49

WeatherStem not updating Error with sql ..? Sept 26, 2021 5:54:40 GMT -8

Quote

Post by les1397 on Sept 26, 2021 5:54:40 GMT -8

Hi Im still new and still trying to get my station to work but worked through issues.
I cant seem to get weatherstem to update but the dash app is good and the
skyweather, also the test sensors shows they are ok.

When i go to the online weatherstem station its registered and the images changes but the sensor display and temp, speed
dont even over a whole day.

I thought it maybe the database but im not sure on the process of how it does it.
I tried to update the sql but cant as when i do the below and enter the "password" its says that error*
so i cant go to the update stage..? to see if it fixes it.

Is there a way to test the sql to know if its ok..?

Any idea please ..

WeatherSenseWireless.sql

ERROR 1068 (42000) at line 258: Multiple primary key defined *

doxidad Senior Member Posts: 272 Raspberry Pi: Yes	WeatherStem not updating Error with sql ..? Sept 26, 2021 8:17:39 GMT -8 les1397 likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by doxidad on Sept 26, 2021 8:17:39 GMT -8 Your database is already updated. The update is trying to create the primary key which is already defined.

les1397
New Member

Posts: 49

WeatherStem not updating Error with sql ..? Sept 26, 2021 9:06:12 GMT -8

Quote

Post by les1397 on Sept 26, 2021 9:06:12 GMT -8

Thanks doxidad

for the reply... So if its already updated then the database is ok..?

I just cant see why the weatherstem isnt being updated as the dash app is showing the right details and the skyweather config is set right for weatherstem.

The updated seconds on the station is a large number and never changes.. It used to work once..

Any ideas what to check ..?
Regards Les

doxidad
Senior Member

Posts: 272
Raspberry Pi: Yes

WeatherStem not updating Error with sql ..? Sept 26, 2021 16:11:40 GMT -8 les1397 likes this

Quote

Post by doxidad on Sept 26, 2021 16:11:40 GMT -8

If your log is not showing any errors inserting records in the database the database is ok. Also, the data is only inserted every 15 minutes so be aware of that.

As far as weatherstem goes - someone else may be able to help you since I don't use it.

Look in your output log for any errors or warnings.

les1397
New Member

Posts: 49

WeatherStem not updating Error with sql ..? Sept 27, 2021 7:12:53 GMT -8

Quote

Post by les1397 on Sept 27, 2021 7:12:53 GMT -8

Thanks For your reply ! Anyone..?

So im trying different things but I checked that the dash app was reading good and it is and the skyweather login is good and the key and the station is there just not updating.
I decided to stop the VNC as maybe it might have an issue and aslo stop auto loading of the dash app so only the SkyWeather auto starts..

This is the last section of the nohup file... just do know enough to tell what its doing..

duplicate found
processing FT020T Data
This is the raw data: {"time" : "2021-09-27 07:29:13", "model" : "SwitchDoc Labs FT020T AIO", "device" : 12, "id" : 0, "batterylow" : 0, "avewindspeed" : 8, "gustwindspeed" : 13, "winddirection" : 199, "cumulativerain" : 156, "temperature" : 1026, "humidity" : 37, "light" : 11356, "uv" : 5, "mic" : "CRC"}

Tick! The time is: 2021-09-27 07:29:14.559420
-------------
Current State
-------------
-------------
latest MainSensor Reading= 2021-09-27 07:29:13
MainDeviceNumber= 0
OutdoorTemperature = 17.0
OutdoorHumidity = 37
latest Indoor Sensor Reading= 2021-09-27 07:28:47
IndoorDeviceNumber= 1
IndoorTemperature = 23.06
IndoorHumidity = 37
Rain60Minutes = 0.0
SunlightVisible = 11356
SunlightUVIndex = 0.5
WindSpeed = 0.8
WindGust = 1.3
WindDirection = 199
TotalRain = 15.6
BarometricTemperature = 29.86
BarometricPressure = 86.81693
Altitude = 1481.0
BarometricPressureSeaLevel = 103.78932
BarometricTemperature = 29.86
barometricTrend = False
pastBarometricReading = 86.81025
AQI = 0.0
Hour24_AQI = 0.0
WS_AQI = 0.0
WS_Hour24_AQI = 0.0
Main Battery Status = OK
CPU Temperature = 54.768
-------------
runRainbow = False
flashStrip = False
runOLED = True
-------------
Last_Event = My Last Event
-------------
batteryVoltage 0
batteryCurrent 0
solarVoltage 0
solarCurrent 0
loadVoltage 0
loadCurrent 0
batteryPower 0
solarPower 0
loadPower 0
batteryCharge 0
SolarMAX Inside Temperature 0.0
SolarMAX Inside Humidity 0.0
SolarMAX Last Received Never
-------------
-------------
-------------
fanState = False
-------------
------Patting The Dog-------
trying database
Rain24Hour= 0.0
sv= 11356
svtype= <class 'int'>
myURL= ID=KUTFARMI58&PASSWORD=Les1397ut&dateutc=now&winddir=199&windspeedmph=1.79&windgustmph=2.90&humidity=37&tempf=62.60&dewptf=39.92&rainin=0.00&dailyrainin=0.00&baromin=30.65&indoortempf=73.51&indoorhumidity37.00=&solarradiation=89.71&UV=0.50&software=SkyWeather2
rtupdate.wunderground.com/weatherstation/updateweatherstation.php?ID=KUTFARMI58&PASSWORD=Les1397ut&dateutc=now&winddir=199&windspeedmph=1.79&windgustmph=2.90&humidity=37&tempf=62.60&dewptf=39.92&rainin=0.00&dailyrainin=0.00&baromin=30.65&indoortempf=73.51&indoorhumidity37.00=&solarradiation=89.71&UV=0.50&software=SkyWeather2
unauthorized

GET sent
CPUT= 56.92
trying database
processing FT020T Data
This is the raw data: {"time" : "2021-09-27 07:29:29", "model" : "SwitchDoc Labs FT020T AIO", "device" : 12, "id" : 0, "batterylow" : 0, "avewindspeed" : 7, "gustwindspeed" : 10, "winddirection" : 208, "cumulativerain" : 156, "temperature" : 1026, "humidity" : 38, "light" : 11366, "uv" : 4, "mic" : "CRC"}

processing FT020T Data
This is the raw data: {"time" : "2021-09-27 07:29:29", "model" : "SwitchDoc Labs FT020T AIO", "device" : 12, "id" : 0, "batterylow" : 0, "avewindspeed" : 7, "gustwindspeed" : 10, "winddirection" : 208, "cumulativerain" : 156, "temperature" : 1026, "humidity" : 38, "light" : 11366, "uv" : 4, "mic" : "CRC"}

duplicate found
------Patting The Dog-------
Processing F016TH data
This is the raw data: {"time" : "2021-09-27 07:29:40", "model" : "SwitchDoc Labs F016TH Thermo-Hygrometer", "device" : 254, "modelnumber" : 5, "channel" : 1, "battery" : "OK", "temperature_F" : 73.600, "humidity" : 37, "mic" : "CRC"}

processing FT020T Data
This is the raw data: {"time" : "2021-09-27 07:29:45", "model" : "SwitchDoc Labs FT020T AIO", "device" : 12, "id" : 0, "batterylow" : 0, "avewindspeed" : 8, "gustwindspeed" : 10, "winddirection" : 225, "cumulativerain" : 156, "temperature" : 1026, "humidity" : 38, "light" : 11400, "uv" : 8, "mic" : "CRC"}

./SkyWeather2.JSON File exists

##########################################################
SkyWeather2 Weather Station Version 027.1 - SwitchDoc Labs

Program Started at:2021-09-27 07:30:44
##########################################################

b''
----------------------
BMP280: Present
SkyCam: Not Present
OLED: Not Present
SunAirPlus/SunControl: Not Present
SolarMAX: Not Present
DustSensor: Not Present

UseBlynk: Disabled
UseWSLIGHTNING: Disabled
UseWSAQI: Disabled
UseWSSKYCAM: Disabled
UseMySQL: Enabled
UseMQTT: Enabled
Check WLAN: Not Present
WeatherUnderground: Present
UseWeatherStem: Present
----------------------
-----------------
Scheduled Jobs
-----------------

######
creating new MQTT instance
Jobstore default:
patTheDog (trigger: interval[0:00:20], next run at: 2021-09-27 07:31:10 MST)
readWiredSensors (trigger: interval[0:00:30], next run at: 2021-09-27 07:31:20 MST)
tick (trigger: interval[0:01:00], next run at: 2021-09-27 07:31:50 MST)
publish (trigger: interval[0:08:20], next run at: 2021-09-27 07:39:10 MST)
barometricTrend (trigger: interval[0:15:00], next run at: 2021-09-27 07:45:50 MST)
writeWeatherRecord (trigger: interval[0:15:00], next run at: 2021-09-27 07:45:50 MST)
writeITWeatherRecord (trigger: interval[0:15:00], next run at: 2021-09-27 07:45:50 MST)
cleanPictures (trigger: cron[day='*', hour='3', minute='4'], next run at: 2021-09-28 03:04:00 MST)
cleanTimeLapses (trigger: cron[day='*', hour='3', minute='10'], next run at: 2021-09-28 03:10:00 MST)
buildTimeLapse (trigger: cron[day='*', hour='5', minute='30'], next run at: 2021-09-28 05:30:00 MST)
rebootPi (trigger: cron[day='5-30/5', hour='0', minute='4'], next run at: 2021-09-30 00:04:00 MST)
-----------------
connecting to broker
Connected with result code 0
starting 433MHz scanning
######
Main Weather Sensors Found
Indoor Weather Sensors Found
Tick! The time is: 2021-09-27 07:31:50.058117
Tick! The time is: 2021-09-27 07:32:50.056782
Tick! The time is: 2021-09-27 07:33:50.056611
./SkyWeather2.JSON File exists

##########################################################
SkyWeather2 Weather Station Version 027.1 - SwitchDoc Labs

Program Started at:2021-09-27 07:35:14
##########################################################

b''
----------------------
BMP280: Present
SkyCam: Not Present
OLED: Not Present
SunAirPlus/SunControl: Not Present
SolarMAX: Not Present
DustSensor: Not Present

UseBlynk: Disabled
UseWSLIGHTNING: Disabled
UseWSAQI: Disabled
UseWSSKYCAM: Disabled
UseMySQL: Enabled
UseMQTT: Enabled
Check WLAN: Not Present
WeatherUnderground: Present
UseWeatherStem: Present
----------------------
-----------------
Scheduled Jobs
-----------------

######
creating new MQTT instance
Jobstore default:
patTheDog (trigger: interval[0:00:20], next run at: 2021-09-27 07:35:40 MST)
readWiredSensors (trigger: interval[0:00:30], next run at: 2021-09-27 07:35:50 MST)
tick (trigger: interval[0:01:00], next run at: 2021-09-27 07:36:20 MST)
publish (trigger: interval[0:08:20], next run at: 2021-09-27 07:43:40 MST)
barometricTrend (trigger: interval[0:15:00], next run at: 2021-09-27 07:50:20 MST)
writeWeatherRecord (trigger: interval[0:15:00], next run at: 2021-09-27 07:50:20 MST)
writeITWeatherRecord (trigger: interval[0:15:00], next run at: 2021-09-27 07:50:20 MST)
cleanPictures (trigger: cron[day='*', hour='3', minute='4'], next run at: 2021-09-28 03:04:00 MST)
cleanTimeLapses (trigger: cron[day='*', hour='3', minute='10'], next run at: 2021-09-28 03:10:00 MST)
buildTimeLapse (trigger: cron[day='*', hour='5', minute='30'], next run at: 2021-09-28 05:30:00 MST)
rebootPi (trigger: cron[day='5-30/5', hour='0', minute='4'], next run at: 2021-09-30 00:04:00 MST)
-----------------
connecting to broker
Connected with result code 0
starting 433MHz scanning
######
Main Weather Sensors Found

doxidad Senior Member Posts: 272 Raspberry Pi: Yes	WeatherStem not updating Error with sql ..? Sept 27, 2021 8:20:15 GMT -8 SDL likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by doxidad on Sept 27, 2021 8:20:15 GMT -8 I see an unauthorized right after where weatherStem info is sent - so something is wrong with your credentials or weatherStem thinks there is.

Post by les1397 on Sept 26, 2021 5:54:40 GMT -8

Post by doxidad on Sept 26, 2021 8:17:39 GMT -8

Post by les1397 on Sept 26, 2021 9:06:12 GMT -8

Post by doxidad on Sept 26, 2021 16:11:40 GMT -8

Post by les1397 on Sept 27, 2021 7:12:53 GMT -8

Post by doxidad on Sept 27, 2021 8:20:15 GMT -8

Quick Reply