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
Welcome to the Cumulus Support forum.
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
Custom SQL command Cumulus MX
Moderator: mcrossley
-
- Posts: 1183
- Joined: Fri 27 Jul 2012 11:29 am
- Weather Station: Chas O, Maplin N96FY, N25FR
- Operating System: rPi 3B+ with Buster (full)
Re: Custom SQL command Cumulus MX
Missing COMMA
(LogDate , Time
-
- Posts: 65
- Joined: Tue 13 Apr 2010 11:37 am
- Weather Station: Davis Vantage Pro2
- Operating System: WINDOWS 10
- Location: Sevilla, España
- Contact:
Re: Custom SQL command Cumulus MX
Not, is LogDateTime in Monthly
Gracias.
Saludos,
José Ramón
Gracias.
Saludos,
José Ramón
-
- Posts: 225
- Joined: Sat 27 Aug 2016 12:11 am
- Weather Station: Davis vantage pro 2
- Operating System: Debian
- Location: Wickliffe, Ohio
- Contact:
Re: Custom SQL command Cumulus MX
dont need the first " and you didnt end it either but still not neededjosebp wrote: ↑Fri 29 Mar 2019 6:50 pm
"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)'
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>')
Jeff
My Site http://wickliffeweather.com/
WeatherUnderground https://www.wunderground.com/personal-w ... KOHYOUNG21
My Site http://wickliffeweather.com/
WeatherUnderground https://www.wunderground.com/personal-w ... KOHYOUNG21
- mcrossley
- Posts: 12756
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Custom SQL command Cumulus MX
You are providing the table and column names but no values? See Jeff's example
-
- Posts: 65
- Joined: Tue 13 Apr 2010 11:37 am
- Weather Station: Davis Vantage Pro2
- Operating System: WINDOWS 10
- Location: Sevilla, España
- Contact:
Re: Custom SQL command Cumulus MX
Best Regards,
José Ramón