Welcome to the Cumulus Support forum.

Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 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

If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080

Edit Dayfile - Update MySQL on Edit

From build 3044 the development baton passed to Mark Crossley. Mark has been responsible for all the Builds since. He has made the code available on GitHub. It is Mark's hope that others will join in this development, but at the very least he welcomes your ideas for future developments (see Cumulus MX Development suggestions).

Moderator: mcrossley

Post Reply
Mapantz
Posts: 1992
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 11 x64
Location: Dorset - UK
Contact:

Edit Dayfile - Update MySQL on Edit

Post by Mapantz »

I edited a value using the Dayfile editor in CMX, but it fails to update the SQL table.

Code: Select all

2023-06-29 00:37:39.956 EditDayFile: Failed, to update MySQL. Error = Input string was not in a correct format.
2023-06-29 00:37:39.956 EditDayFile: SQL Update statement = 
Editing the Monthly log file updates the Monthly SQL table fine.
Image
User avatar
billy
Posts: 260
Joined: Mon 30 Nov 2015 10:54 am
Weather Station: WLL / Davis VP2+
Operating System: RPi-4 bookworm
Location: Gooseberry Hill, Western Australia

Re: Edit Dayfile - Update MySQL on Edit

Post by billy »

Yes, I get the same message. My MySQL dayfile is standard ... , except for it's name ... and the routine daily upload works fine.
User avatar
mcrossley
Posts: 14388
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Edit Dayfile - Update MySQL on Edit

Post by mcrossley »

I'll investigate....
User avatar
mcrossley
Posts: 14388
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Edit Dayfile - Update MySQL on Edit

Post by mcrossley »

Fixed in the next build.
Post Reply