Page 1 of 1

ImportCumulusFile update

Posted: Fri 13 Jan 2023 2:58 pm
by malmeida
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?

Re: ImportCumulusFile update

Posted: Fri 13 Jan 2023 5:48 pm
by freddie
Version 4.1 is available from this post. What link did you use that returned a 404?

Re: ImportCumulusFile update

Posted: Fri 13 Jan 2023 8:08 pm
by malmeida
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.