2016-09-19 22:55:27 Error: MYSQL query 'INSERT INTO `mystation` (`ID`, `DateTime`, `TempOutCur`, `HumOutCur`, `PressCur`, `DewCur`, `HeatIdxCur`, `WindChillCur`, `TempInCur`, `HumInCur`, `WindSpeedCur`, `WindAvgSpeedCur`, `WindDirCur`, `WindDirCurEng`, `WindGust10`, `WindDirAvg10`, `WindDirAvg10Eng`, `RainRateCur`, `RainDay`, `RainYest`, `RainMonth`, `RainYear`, `Forecast`) VALUES (NULL, '2016-09-19 22:55:27', '27.0', '89.0', '29.71', '25.0', '30.6', '27.0', '31.6', '64.0', '0.0', '1.4', '94.0', 'E', '4.7', '94.0', 'E', '0.00', '0.15', '0.00', '0.15', '0.15','Mostly cloudy and cooler. Windy with possible wind shift to the W, NW, or N.','05:32')' failed: Column count doesn't match value count at row 1 (no more tries):
I change the Sunrise from datetime to time.. still error.. hmmp
I already fixec it..
INSERT INTO `biliranisland` (`ID`, `DateTime`, `TempOutCur`, `HumOutCur`, `PressCur`, `DewCur`, `HeatIdxCur`, `WindChillCur`, `TempInCur`, `HumInCur`, `WindSpeedCur`, `WindAvgSpeedCur`, `WindDirCur`, `WindDirCurEng`, `WindGust10`, `WindDirAvg10`, `WindDirAvg10Eng`, `RainRateCur`, `RainDay`, `RainYest`, `RainMonth`, `RainYear`, `Forecast`,`Sunrise`) VALUES (NULL, '[YYYY]-[MM]-[DD] [hh]:[mm]:[ss]', '[th0temp-act]', '[th0hum-act]', '[thb0seapress-act=inHg.2]', '[th0dew-act]', '[th0heatindex-act]', '[wind0chill-act]', '[thb0temp-act]', '[thb0hum-act]', '[wind0wind-act=kmh]', '[wind0avgwind-act=kmh]', '[wind0dir-act]', '[wind0dir-act=endir]', '[wind0wind-max10=kmh]', '[wind0dir-avg10]', '[wind0dir-avg10=endir]', '[rain0rate-act=in.2]', '[rain0total-daysum=in.2]', '[rain0total-ydaysum=in.2]', '[rain0total-monthsum=in.2]', '[rain0total-yearsum=in.2]','[forecast-text]','[mbsystem-sunrise]')
missing `Sunrise` in the query..
by the way.. Time or DayTime?