Welcome to the Cumulus Support forum.

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Cumulus MX V4 beta test release 4.0.0 (build 4018) - 28 March 2024

Legacy Cumulus 1 release v1.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

importcumulusfile.php Failed to bind the SQL parameters!

Topics about the Beta trials up to Build 3043, the last build by Cumulus's founder Steve Loft. It was by this time way out of Beta but Steve wanted to keep it that way until he made a decision on his and Cumulus's future.

Moderator: mcrossley

Locked
david3
Posts: 63
Joined: Sat 28 Jan 2012 4:03 pm
Weather Station: Davis Vantage Vue
Operating System: Debian 12 64bit for rpi

importcumulusfile.php Failed to bind the SQL parameters!

Post by david3 »

I'm trying to import my dayfile.txt into a mysql database. I've got the latest version of importcumulusfile.php from the wiki and set the various paramters.

It imports dayfile.txt, connects to the database, and creates the table ok, but when it goes to insert the data it gets an error. Here's the output:

Code: Select all

Running from CLI

Script start: 17/07/18 - 16:41:43
Importing file: /{fullpath}/data/dayfile.txt, To table: Dayfile ...
Connected to database OK.
Set MySQL TZ OK.
Processing dayfile...
Table '' does not exist, creating it...
Table '' created OK.
Prepared SQL statement OK.
Inserting data...
Error: Failed to bind the SQL parameters!
These are my PHP and mysql versions:
PHP 7.2.7 (cli) (built: Jul 5 2018 23:53:16) ( NTS )
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1

Any ideas what might be happening?

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

Re: importcumulusfile.php Failed to bind the SQL parameters!

Post by mcrossley »

Could you try version 2.8 please. Version 3 seems to be causing issues for a few people and I haven't gotten to the bottom of it yet (no time!).
david3
Posts: 63
Joined: Sat 28 Jan 2012 4:03 pm
Weather Station: Davis Vantage Vue
Operating System: Debian 12 64bit for rpi

Re: importcumulusfile.php Failed to bind the SQL parameters!

Post by david3 »

Thanks! Version 2.8 worked fine.

I found I was using v3.0 before, and also tried v3.1, but got the same error. v2.8 is good, though.
Locked