Welcome to the new home of the Cumulus Support forum.

Latest Cumulus release v1.9.4 (build 1099) - Nov 28 2014
Latest Cumulus MX release - v3.0.0 build 3043 Jan 20 2017. See the Wiki 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.
Post Reply
User avatar
kocher
Posts: 67
Joined: Sat 19 Apr 2014 7:57 pm
Weather Station: Davis Vantage Pro2+
Operating System: Windows 10
Location: San Sebastian - Spain
Contact:

MySQL error - Solved

Post by kocher » Thu 07 Dec 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 07 Dec 2017 9:54 pm, edited 1 time in total.
Image

User avatar
steve
Cumulus Author
Posts: 26714
Joined: Mon 02 Jun 2008 6:49 pm
Weather Station: None
Operating System: None
Location: Vienne, France
Contact:

Re: MySQL error

Post by steve » Thu 07 Dec 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

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

Re: MySQL error

Post by kocher » Thu 07 Dec 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
Image

Post Reply