Unbuffered Queries

[rlc]

Hi,

I am having errors containing "Fatal error: Uncaught Cannot execute queries while other unbuffered queries are active. I have read about PDO and closeCursor but I don't know how to implement it in PrestaShop.

 

Help much appreciated.

[giancarlo.spadini]

I have the same problem. Have you found a solution at end?

 

[PrestaShopDatabaseException]

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.

INSERT INTO `ps_life365_import` (`id_external`, `date_import`, `id_product_ps`) VALUES (6924, CURRENT_TIMESTAMP, 13);