importcumulusfile.php Failed to bind the SQL parameters!
Posted: Tue 17 Jul 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:
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.
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!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.