Webcam no insert data

Post Reply
Schwieg
Newbie
Newbie
Posts: 1
Joined: Mon Oct 29, 2018 4:44 pm

Webcam no insert data

Post by Schwieg » Tue Nov 13, 2018 3:28 pm

updateWebcam.php well runs. Pictures and Thumbnails are stored. However, the data are not written in the table "webcam" at database.

with manual update I receive this message

Save interval elapsed.
Webcam image being saved.
INSERT INTO webcam (DateTime, T, H, P, R, RR, S, W, G, img) VALUES ('2018-11-13 16:13:34',10.9, 96.6, 1024.800, , , 0, 1.7, 2.9, '201811131613')
No images older than 2018-10-15 00:00:00 Loaded CRON: /var/www/html/template/load/crons/updateWebcam.php


Does somebody has any idea?



Problem solved. I use no rain sensor. -> no data in $R and $RR.

chrimu
Observer
Observer
Posts: 18
Joined: Wed Feb 28, 2018 6:16 pm
Station model: Homematic
Software: Homematic scripts

Re: Webcam no insert data

Post by chrimu » Tue Oct 15, 2019 9:23 pm

Hi,

Experiencing exactly the same problem (no $RR, thus no entries in the webcam table), is there anybody to tell me what the solution could be / bas been?
Adjust the updateWebcam.php to exclude $RRs? Drop the plugin? Anything else?

Any help most welcome!...
...before I start fiddeling with code I do not understand… :shock:

Cheers,
Christian

chrimu
Observer
Observer
Posts: 18
Joined: Wed Feb 28, 2018 6:16 pm
Station model: Homematic
Software: Homematic scripts

Re: Webcam no insert data

Post by chrimu » Tue Oct 15, 2019 9:46 pm

In reply to myself: Indeed it's writing the $RR (or probably any other unavailable parameter) to zero in updateWebcam.php:

while($row = mysqli_fetch_array($result)){
$T = $row['T'];
$H = $row['H'];
$P = $row['P'];
$R = $row['R'];
$W = $row['W'];
$G = $row['G'];
$S = $row['S'];
--> $RR = 0;

Cheers, C

Post Reply