Illegal mix of collations (latin2_general_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation '='SELECT COUNT(DISTINCT cp.`id_product`) AS total
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product)
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1)
LEFT JOIN `Atrybuty` i ON p.`reference` = i.`kodtowaru`WHERE cp.`id_category` = 190 AND stock.quantity > 0 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 and i.kroj = 'SOFT
��' LIMIT 1
at line 791 in file classes/db/Db.php
786. if ($webservice_call && $errno) {
787. $dbg = debug_backtrace();
788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790. if ($sql) {
791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792. }
793.
794. throw new PrestaShopDatabaseException($this->getMsgError());
795. }
796. }
420. $this->result = $this->_query($sql);
421. }
422. }
423.
424. if (_PS_DEBUG_SQL_) {
425. $this->displayError($sql);
426. }
427.
428. return $this->result;
429. }
430.
Argument [0]
685. $this->last_cached = true;
686. return $result;
687. }
688. }
689.
690. $this->result = $this->query($sql);
691. if (!$this->result) {
692. $result = false;
693. } else {
694. $result = $this->nextRow($this->result);
695. }
Argument [0]
718. {
719. if ($sql instanceof DbQuery) {
720. $sql = $sql->build();
721. }
722.
723. if (!$result = $this->getRow($sql, $use_cache)) {
724. return false;
725. }
726.
727. return array_shift($result);
728. }
Argument [0] Argument [1] 1
355. ($specials ? ' and i.okazja = \''.$specials.'\'' : '').
356. ($id_supplier ? 'AND p.id_supplier = '.(int)$id_supplier : '');
357.
358.
359.
360. return (int)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql);
361. }
362.
363. if ($p < 1) {
364. $p = 1;
365. }
Argument [0]
220. // The hook was not executed, standard working
221. if (!$hook_executed) {
222. $this->context->smarty->assign('categoryNameComplement', '');
223. $filtry= (string)Tools::getValue('filtry');
224. $kroj= (string)Tools::getValue('kroj');
225. $this->nbProducts = $this->category->getProducts(null, null, null, $this->orderBy, $this->orderWay, true, true, false, 1, 1, null , $filtry,false);
226. $this->pagination((int)$this->nbProducts); // Pagination must be call after "getProducts"
227.
228.
229. $this->context->smarty->assign('filtry', $this->category->getProducts($this->context->language->id, (int)$this->p, (int)$this->n, $this->orderBy, $this->orderWay, false, true, false, 1, true, null , false,true));
230.
Argument [0] Argument [1] Argument [2] Argument [3] date_upd Argument [4] asc Argument [5] 1 Argument [6] 1 Argument [7] Argument [8] 1 Argument [9] 1 Argument [10] Argument [11] Argument [12]
141. // Product sort must be called before assignProductList()
142. $this->productSort();
143.
144. $this->assignScenes();
145. $this->assignSubcategories();
146. $this->assignProductList();
147.
148. $this->context->smarty->assign(array(
149. 'category' => $this->category,
150. 'description_short' => Tools::truncateString($this->category->description, 350),
151. 'products' => (isset($this->cat_products) && $this->cat_products) ? $this->cat_products : null,
184. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {
185. $this->initHeader();
186. }
187.
188. if ($this->viewAccess()) {
189. $this->initContent();
190. } else {
191. $this->errors[] = Tools::displayError('Access denied.');
192. }
193.
194. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) {
362. if (isset($params_hook_action_dispatcher)) {
363. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
364. }
365.
366. // Running controller
367. $controller->run();
368. } catch (PrestaShopException $e) {
369. $e->displayMessage();
370. }
371. }
372.
23. * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
24. * International Registered Trademark & Property of PrestaShop SA
25. */
26.
27. require(dirname(__FILE__).'/config/config.inc.php');
28. Dispatcher::getInstance()->dispatch();