Page 1 of 1

Webcam no insert data

Posted: Tue Nov 13, 2018 3:28 pm
by Schwieg
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.

Re: Webcam no insert data

Posted: Tue Oct 15, 2019 9:23 pm
by chrimu
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

Re: Webcam no insert data

Posted: Tue Oct 15, 2019 9:46 pm
by chrimu
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