Please read the posts in the Announcements section about the current status of Cumulus development now that I have retired

Please read this post before posting

Latest Cumulus release v1.9.4 (build 1099) - Nov 28 2014
Latest Cumulus MX release - v3.0.0 build 3043 Jan 20 2017. See this post for download

MySQL error - Solved

Discussion of version 3 of Cumulus, which runs on Windows, Linux, and OS X. All Cumulus MX queries in here, please.
User avatar
kocher
Posts: 60
Joined: Sat Apr 19, 2014 7:57 pm
Weather Station: Davis Vantage Pro2+
Operating System: Windows 10
Location: San Sebastian - Spain
Contact:

MySQL error - Solved

Postby kocher » Thu Dec 07, 2017 5:44 pm

The version of cumulusMX that I have currently installed, is 3043

The 3 tables "monthly", "dayfile" and "realtime" (retention string: 1DAY) have been created.

The 3 tables are updated correctly, but the following error appears:

Code: Select all

"Error encountered during MySQL operation.
You have an error in your SQL syntax, check the manual that corresponds to your MySQL server version for the right syntax to ude near ')' at line 1"


I attach the Mxdiags
You do not have the required permissions to view the files attached to this post.
Last edited by kocher on Thu Dec 07, 2017 9:54 pm, edited 1 time in total.
Windows 10
Davis Vantage Pro Plus
WeatherLink 6.0.2
cumulusMX
Meteotemplate

Image

User avatar
steve
Cumulus Author
Posts: 26314
Joined: Mon Jun 02, 2008 6:49 pm
Weather Station: None
Operating System: None
Location: On tour in Portugal
Contact:

Re: MySQL error

Postby steve » Thu Dec 07, 2017 7:55 pm

1 DAY not 1DAY

We stayed near San Sebastián last week - at Zarautz. Couldn’t believe that it snowed! We’ve now moved on to a site in the Picos de Europa. Raining now :(
Steve
-----
Hosting available for Cumulus web sites. See http://sandaysoft.com/forum/viewtopic.php?f=2&t=11876

Please read the posts in the Announcements section about the current status of Cumulus development since I have retired from my day job

User avatar
kocher
Posts: 60
Joined: Sat Apr 19, 2014 7:57 pm
Weather Station: Davis Vantage Pro2+
Operating System: Windows 10
Location: San Sebastian - Spain
Contact:

Re: MySQL error

Postby kocher » Thu Dec 07, 2017 9:21 pm

Thank you very much Steve

The problem is solved

steve wrote:1 DAY not 1DAY

We stayed near San Sebastián last week - at Zarautz. Couldn’t believe that it snowed! We’ve now moved on to a site in the Picos de Europa. Raining now :(



Indeed see snow near the coast in Zarauz (camping?), It is extremely rare.

I hope you enjoy a lot in your stay in Spain, especially in the area of Picos de Europa
Windows 10
Davis Vantage Pro Plus
WeatherLink 6.0.2
cumulusMX
Meteotemplate

Image


Return to “Cumulus MX”

Who is online

Users browsing this forum: No registered users and 8 guests