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 4017) - 17 March 2024

Legacy Cumulus 1 release v1.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

MySQL error - Solved

Topics about the Beta trials up to Build 3043, the last build by Cumulus's founder Steve Loft. It was by this time way out of Beta but Steve wanted to keep it that way until he made a decision on his and Cumulus's future.

Moderator: mcrossley

Locked
User avatar
kocher
Posts: 233
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 »

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: 26702
Joined: Mon 02 Jun 2008 6:49 pm
Weather Station: None
Operating System: None
Location: Vienne, France
Contact:

Re: MySQL error

Post by steve »

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: 233
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 »

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
Locked