After updating Cumulus from build 3089 to build 3101 I was not able to load new values in the MySQL database table of the server and I received "Failed to bind the SQL parameters!".
As I was using version 3.2 of ImportCumulusFile.php file I tried to download version 4 but I received "The requested URL was not found on this server".
Then I copied the new columns of ImportCumulusFile version 4 to my old ImportCumulusFile version 3.2 and I also included those new columns in my SQL database table but without success because the database table was not updated. Then I tried to use again the old ImportCumulusFile v3.2 without the new columns and the result was again "Failed to bind the SQL parameters!".
What can be done?
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
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
ImportCumulusFile update
Moderator: mcrossley
-
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: ImportCumulusFile update
Version 4.1 is available from this post. What link did you use that returned a 404?
-
malmeida
- Posts: 93
- Joined: Thu 06 Oct 2016 7:16 pm
- Weather Station: Maplin N96FY
- Operating System: Raspbian
Re: ImportCumulusFile update
Thank you for your answer. With your file I updated monthly table but dayfile table gave error:
“Unknown column ‘ChillHours´ in field list”.
I verify that column names of your file are different from the list “Schema for version 4.0 and later” in the page that gave me the Download error:
https://www.cumuluswiki.org/a/ImportCumulusFile
As I updated column names of MySQL database with the values of that Wiki page I got that error. Now I am going to correct the database column names with the ones from your file.
“Unknown column ‘ChillHours´ in field list”.
I verify that column names of your file are different from the list “Schema for version 4.0 and later” in the page that gave me the Download error:
https://www.cumuluswiki.org/a/ImportCumulusFile
As I updated column names of MySQL database with the values of that Wiki page I got that error. Now I am going to correct the database column names with the ones from your file.