Page 1 of 1

Export to MySQL issue

Posted: Thu 11 May 2023 12:59 am
by griffo42
Can someone be good enough to tell me how to fix this problem, please.
Screenshot 2023-05-11 105208.png
Thanks
Keith

Re: Export to MySQL issue

Posted: Thu 11 May 2023 1:44 am
by jlmr731
Do you have all the credentials correct in cumulus settings, and also have the dayfile table setup with in your database?

Re: Export to MySQL issue

Posted: Thu 11 May 2023 7:51 am
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.

Re: Export to MySQL issue

Posted: Thu 11 May 2023 10:46 am
by griffo42
Yes to both.

Keith

Re: Export to MySQL issue

Posted: Thu 11 May 2023 11:11 am
by freddie
I have no other ideas, I'm afraid. Perhaps @mcrossley will be able to help.

Re: Export to MySQL issue

Posted: Fri 12 May 2023 10:01 am
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

Re: Export to MySQL issue

Posted: Fri 12 May 2023 11:45 am
by dazza1223
i will add this in the new build

Re: Export to MySQL issue

Posted: Mon 10 Mar 2025 1:41 am
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?

Re: Export to MySQL issue

Posted: Mon 10 Mar 2025 10:11 am
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.

Re: Export to MySQL issue

Posted: Tue 11 Mar 2025 1:32 am
by griffo42
@mcrossley Thanks, that did it.