Field 'weathertext' doesn't have a default value
INSERT INTO vremea SET id_loc='42', daytxtshort='Beautiful with some sun', nighttxtshort='Clear', daytxtlong='Beautiful with some sun', nighttxtlong='Clear', observationdate='10/21/2020', observationtime='19:46:12', obsdate='10/22/2020', daycode='Thursday', sunrise='7:41', sunset='18:18', dayweathericon ='03', dayhightemperature ='21', daylowtemperature='5', dayrealfeelhigh ='21', dayrealfeellow='6', daywindspeed='2', daywinddirection='WSW', daywindgust='3', daymaxuv='3', dayrainamount='0.00', daysnowamount='0.00', dayprecipamount='0.00', daytstormprob='0', nightweathericon='33', nighthightemperature='21', nightlowtemperature='5', nightrealfeelhigh='12', nightrealfeellow='4', nightwindspeed ='1', nightwinddirection='WSW', nightwindgust='2', nightrainamount='0.00', nightsnowamount='0.00', nightprecipamount='0.00', nighttstormprob='0'