Custom SQL command Cumulus MX

[josebp]

Hi all
I wanted to upload with the 'MYSQL' Settings:
custom SQL command to be executed at an interval in minutes the monthly files to 10 minutes, since my monthly .txt is 1 minute.
Use:
"INSERT IGNORE INTO ' Monthly' (LogDateTime,Temp,Humidity,Dewpoint,Windspeed,Windgust,Windbearing,RainRate,TodayRainSoFar,Pressure,Raincounter,InsideTemp,InsideHumidity,LatestWindGust,WindChill,HeatIndex,UVindex,SolarRad,Evapotrans,AnnualEvapTran,ApparentTemp,MaxSolarRad,HrsSunShine,CurrWindBearing,RG11rain,RainSinceMidnight,WindbearingSym,CurrWindBearingSym)'

and I get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"INSERT IGNORE INTO 'Monthly' (LogDateTime,Temp,Humidity,Dewpoint,Windspeed,Wind' at line 1

What do I do wrong?

Thanks greetings,
José Ramón

[sfws]

Missing COMMA

(LogDate , Time

[josebp]

Not, is LogDateTime in Monthly
Gracias.
Saludos,
José Ramón

[jlmr731]

"INSERT IGNORE INTO ' Monthly' (LogDateTime,Temp,Humidity,Dewpoint,Windspeed,Windgust,Windbearing,RainRate,TodayRainSoFar,Pressure,Raincounter,InsideTemp,InsideHumidity,LatestWindGust,WindChill,HeatIndex,UVindex,SolarRad,Evapotrans,AnnualEvapTran,ApparentTemp,MaxSolarRad,HrsSunShine,CurrWindBearing,RG11rain,RainSinceMidnight,WindbearingSym,CurrWindBearingSym)'

dont need the first " and you didnt end it either but still not needed

here is a small one ive used for logging windrun so it should help, for some reason i remember i had to add the Values clause, and since you are adding from Cumulus you need to add the values as web tags. I didnt do any testing but I think the single quotes are needed for each entry

INSERT INTO `wind` (`DateTime`, `windrun`) VALUES ('<#time format="yyyy-MM-dd HH:mm:ss">', '<#windrun>')

[mcrossley]

You are providing the table and column names but no values? See Jeff's example

[josebp]

Best Regards,
José Ramón