IMPORTANT! The server may go down soon - possibly permanently. Please read the latest post in Announcements and News

I strongly advise all users using my server for their web site to make alternative arrangements.

Outgoing mail is disabled because of the malware on the server. No new forum registrations are currently possible, and mail to the forum administrator will not work.

Please read the posts in the Announcements section about the current status of Cumulus development now that I have retired

Please read this post before posting

Latest Cumulus release v1.9.4 (build 1099) - Nov 28 2014
Latest Cumulus MX release - v3.0.0 build 3043 Jan 20 2017. See this post for download

importcumulusfile.php Failed to bind the SQL parameters!

Discussion of version 3 of Cumulus, which runs on Windows, Linux, and OS X. All Cumulus MX queries in here, please.
david3
Posts: 50
Joined: Sat Jan 28, 2012 4:03 pm
Weather Station: Davis Vantage Vue
Operating System: Raspbian Stretch
Location: Philippines
Contact:

importcumulusfile.php Failed to bind the SQL parameters!

Postby david3 » Tue Jul 17, 2018 9:00 am

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.
Image

User avatar
mcrossley
Posts: 5194
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Stretch Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

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

Postby mcrossley » Tue Jul 17, 2018 10:18 am

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: 50
Joined: Sat Jan 28, 2012 4:03 pm
Weather Station: Davis Vantage Vue
Operating System: Raspbian Stretch
Location: Philippines
Contact:

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

Postby david3 » Tue Jul 17, 2018 10:45 am

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.
Image


Return to “Cumulus MX”

Who is online

Users browsing this forum: No registered users and 4 guests