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

Export to MySQL issue

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
griffo42
Posts: 247
Joined: Thu 10 Dec 2015 6:41 am
Weather Station: Davis Vantage Pro2
Operating System: Win 11 Home
Location: Brisbane, Queensland, Australia
Contact:

Export to MySQL issue

Post by griffo42 »

Can someone be good enough to tell me how to fix this problem, please.
Screenshot 2023-05-11 105208.png
Thanks
Keith
You do not have the required permissions to view the files attached to this post.
Keith
Davis Vantage Pro2 Model #6152AU - CumulusMX - Win11 - Saratoga/CUMX Default Scripts
https://www.kstwx.net/index.php
https://www.kstwx.net/cumx/index.html
Image
jlmr731
Posts: 227
Joined: Sat 27 Aug 2016 12:11 am
Weather Station: Davis vantage pro 2
Operating System: Debian
Location: Wickliffe, Ohio
Contact:

Re: Export to MySQL issue

Post by jlmr731 »

Do you have all the credentials correct in cumulus settings, and also have the dayfile table setup with in your database?
freddie
Posts: 2870
Joined: Wed 08 Jun 2011 11:19 am
Weather Station: Davis Vantage Pro 2 + Ecowitt
Operating System: GNU/Linux Ubuntu 24.04 LXC
Location: Alcaston, Shropshire, UK
Contact:

Re: Export to MySQL issue

Post by freddie »

Looks like a library mismatch of some sort. From your profile banner you appear to be using the latest version of MX. Has your ExportToMySQL been updated (to v1.8.0) to match? See the wiki for some guidance.
Freddie
Image
griffo42
Posts: 247
Joined: Thu 10 Dec 2015 6:41 am
Weather Station: Davis Vantage Pro2
Operating System: Win 11 Home
Location: Brisbane, Queensland, Australia
Contact:

Re: Export to MySQL issue

Post by griffo42 »

Yes to both.

Keith
Keith
Davis Vantage Pro2 Model #6152AU - CumulusMX - Win11 - Saratoga/CUMX Default Scripts
https://www.kstwx.net/index.php
https://www.kstwx.net/cumx/index.html
Image
freddie
Posts: 2870
Joined: Wed 08 Jun 2011 11:19 am
Weather Station: Davis Vantage Pro 2 + Ecowitt
Operating System: GNU/Linux Ubuntu 24.04 LXC
Location: Alcaston, Shropshire, UK
Contact:

Re: Export to MySQL issue

Post by freddie »

I have no other ideas, I'm afraid. Perhaps @mcrossley will be able to help.
Freddie
Image
User avatar
mcrossley
Posts: 14382
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Export to MySQL issue

Post by mcrossley »

I missed that dependency - the attached version should fix it.

@freddie, could you do the honours uploading it please? I just realised whilst doing the weeding it doesn't need to be.

Updated the download link in the Wiki
User avatar
dazza1223
Posts: 910
Joined: Sun 25 Jan 2015 8:41 pm
Weather Station: Davis Vantage Pro 2 plus
Operating System: Raspberry pi 4 (4gb)
Location: Worthing
Contact:

Re: Export to MySQL issue

Post by dazza1223 »

i will add this in the new build
Have fun and keep learning

dazza :D

https://www.davisworthing.co.uk

Image
griffo42
Posts: 247
Joined: Thu 10 Dec 2015 6:41 am
Weather Station: Davis Vantage Pro2
Operating System: Win 11 Home
Location: Brisbane, Queensland, Australia
Contact:

Re: Export to MySQL issue

Post by griffo42 »

The wild weather that we have experienced in Brisbane from a cyclone over the last few days has caused an internet outage. To correct its effect, I need to update my SQL database.

This is what I get when I run ExportToMySQL with the 3 scripts in my CumulusMX folder:

Screenshot 2025-03-10 112617.png

The scripts in my Cumulus folder are the 3 related scripts which are included in the latest release b4084.

In addition to those, I have found 2 further scripts in release v1.10.0 of ExportToMySQL referenced in the Wiki. How are these to be used?

What have I to do to update my SQL database, please?
You do not have the required permissions to view the files attached to this post.
Keith
Davis Vantage Pro2 Model #6152AU - CumulusMX - Win11 - Saratoga/CUMX Default Scripts
https://www.kstwx.net/index.php
https://www.kstwx.net/cumx/index.html
Image
User avatar
mcrossley
Posts: 14382
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Export to MySQL issue

Post by mcrossley »

Found the problem. When I changed the logging component in MX for v4.4.0 it downgraded some system components from the .Net 9.0 to the .Net 8.0 versions. The same change needs to be made in ExportToMySQL

Please unzip the attached into your CMX folder and give this version a whirl.
You do not have the required permissions to view the files attached to this post.
griffo42
Posts: 247
Joined: Thu 10 Dec 2015 6:41 am
Weather Station: Davis Vantage Pro2
Operating System: Win 11 Home
Location: Brisbane, Queensland, Australia
Contact:

Re: Export to MySQL issue

Post by griffo42 »

@mcrossley Thanks, that did it.
Keith
Davis Vantage Pro2 Model #6152AU - CumulusMX - Win11 - Saratoga/CUMX Default Scripts
https://www.kstwx.net/index.php
https://www.kstwx.net/cumx/index.html
Image
Post Reply