I am having trouble running the following prepared statement in Laravel:
$pdo = DB::connection()->getPdo(); $ps_TempTable_PushCsv = $pdo->prepare( "LOAD DATA LOCAL INFILE '123' INTO TABLE `123` CHARACTER SET utf8mb4 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\ '" ); $ps_TempTable_PushCsv->execute(); $ps_TempTable_PushCsv->closeCursor(); $rowCount = $ps_TempTable_PushCsv->rowCount();
I get the following error:
[2017-06-08 03:41:35] local.ERROR: PDOException: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
This is the entry-point of my controller, so there are definitely no prior queries running.