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.