I'm running two different instances of OctoberCMS, both with Octoshop and Octoshop Product Plus plugins installed. I discovered this issue when attempting to display the Categories column for the backend Product list, i.e., the default page of the Shop tab.
On my local version, if I add a second category to a product, its row simply disappears from the product list. On my development/remote version, this is happening instead:
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. (SQL: selectfeegleweb_octoshop_products
.*, (select group_concat(title separator ', ') fromfeegleweb_octoshop_categories
desc limit 25 offset 0) /nfs/c01/h14/mnt/11649/domains/itsgcollective.org/vendor/laravel/framework/src/Illuminate/Database/Connection.php line 624My problem is now that I can't get back to the Product list to turn the Categories column off and prevent this error from occurring. Obviously it would be great if I could find where this is originating in the code and change the query so that it actually displays multiple Category names under the column heading, but I figured before I got into that potentially lengthy investigation, I'd report the problem here.