You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') GROUP BY fv.`id_nffilter_value` ORDER BY f.priority DESC, f.id_nffilter ASC...' at line 7
SELECT pfv.*, fv.*, fvl.*, fl.name AS f_name, fl.private_name AS f_private_name
FROM `ps_product_nf_filter_value` AS pfv
LEFT JOIN `ps_nf_filter_value` AS fv ON (fv.`id_nffilter_value` = pfv.`id_nffilter_value`)
LEFT JOIN `ps_nf_filter_value_lang` AS fvl ON (fvl.`id_nffilter_value` = pfv.`id_nffilter_value` AND fvl.id_lang = 4)
LEFT JOIN `ps_nf_filter_lang` AS fl ON (fl.`id_nffilter` = fv.`id_nffilter` AND fl.id_lang = 4)
LEFT JOIN `ps_nf_filter` f ON (f.`id_nffilter` = fv.`id_nffilter`)
WHERE `id_product` IN () GROUP BY fv.`id_nffilter_value` ORDER BY f.priority DESC, f.id_nffilter ASC, fl.name ASC, fvl.name ASC
at line 635 in file classes/db/Db.php
629. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
630. }
631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
632. {
633. if ($sql)
634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
635. throw new PrestaShopDatabaseException($this->getMsgError());
636. }
637. }
638.
639. /**
319. if ($sql instanceof DbQuery)
320. $sql = $sql->build();
321.
322. $this->result = $this->_query($sql);
323. if (_PS_DEBUG_SQL_)
324. $this->displayError($sql);
325. return $this->result;
326. }
327.
328. /**
329. * Execute an INSERT query
Argument [0] SELECT pfv.*, fv.*, fvl.*, fl.name AS f_name, fl.private_name AS f_private_name FROM `ps_product_nf_filter_value` AS pfv LEFT JOIN `ps_nf_filter_value` AS fv ON (fv.`id_nffilter_value` = pfv.`id_nffilter_value`) LEFT JOIN `ps_nf_filter_value_lang` AS fvl ON (fvl.`id_nffilter_value` = pfv.`id_nffilter_value` AND fvl.id_lang = 4) LEFT JOIN `ps_nf_filter_lang` AS fl ON (fl.`id_nffilter` = fv.`id_nffilter` AND fl.id_lang = 4) LEFT JOIN `ps_nf_filter` f ON (f.`id_nffilter` = fv.`id_nffilter`) WHERE `id_product` IN () GROUP BY fv.`id_nffilter_value` ORDER BY f.priority DESC, f.id_nffilter ASC, fl.name ASC, fvl.name ASC
495. {
496. $this->last_cached = true;
497. return $result;
498. }
499.
500. $this->result = $this->query($sql);
501.
502. if (!$this->result)
503. $result = false;
504. else
505. {
Argument [0] SELECT pfv.*, fv.*, fvl.*, fl.name AS f_name, fl.private_name AS f_private_name FROM `ps_product_nf_filter_value` AS pfv LEFT JOIN `ps_nf_filter_value` AS fv ON (fv.`id_nffilter_value` = pfv.`id_nffilter_value`) LEFT JOIN `ps_nf_filter_value_lang` AS fvl ON (fvl.`id_nffilter_value` = pfv.`id_nffilter_value` AND fvl.id_lang = 4) LEFT JOIN `ps_nf_filter_lang` AS fl ON (fl.`id_nffilter` = fv.`id_nffilter` AND fl.id_lang = 4) LEFT JOIN `ps_nf_filter` f ON (f.`id_nffilter` = fv.`id_nffilter`) WHERE `id_product` IN () GROUP BY fv.`id_nffilter_value` ORDER BY f.priority DESC, f.id_nffilter ASC, fl.name ASC, fvl.name ASC
133. LEFT JOIN `' . _DB_PREFIX_ . 'nf_filter_lang` AS fl ON (fl.`id_nffilter` = fv.`id_nffilter` AND fl.id_lang = ' . $id_lang . ')
134. LEFT JOIN `' . _DB_PREFIX_ . 'nf_filter` f ON (f.`id_nffilter` = fv.`id_nffilter`)
135. WHERE `id_product` IN (' . implode(',',$id_products).')'
136. .' GROUP BY fv.`id_nffilter_value`'
137. .' ORDER BY f.priority DESC, f.id_nffilter ASC, fl.name ASC, fvl.name ASC';
138. $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
139. Cache::store($cache_id, $result);
140. }
141. return Cache::retrieve($cache_id);
142. }
143. }
Argument [0] SELECT pfv.*, fv.*, fvl.*, fl.name AS f_name, fl.private_name AS f_private_name FROM `ps_product_nf_filter_value` AS pfv LEFT JOIN `ps_nf_filter_value` AS fv ON (fv.`id_nffilter_value` = pfv.`id_nffilter_value`) LEFT JOIN `ps_nf_filter_value_lang` AS fvl ON (fvl.`id_nffilter_value` = pfv.`id_nffilter_value` AND fvl.id_lang = 4) LEFT JOIN `ps_nf_filter_lang` AS fl ON (fl.`id_nffilter` = fv.`id_nffilter` AND fl.id_lang = 4) LEFT JOIN `ps_nf_filter` f ON (f.`id_nffilter` = fv.`id_nffilter`) WHERE `id_product` IN () GROUP BY fv.`id_nffilter_value` ORDER BY f.priority DESC, f.id_nffilter ASC, fl.name ASC, fvl.name ASC
38.
39. $idProducts = array();
40. foreach ($prTemp as $pr) {
41. $idProducts[] = $pr['id_product'];
42. }
43. $filters = NFFitlerValue::getProductsValues($idProducts);
44. // var_dump($filters);
45. $filtersSorted = array();
46. foreach ($filters as $f) {
47. if (!isset($filtersSorted[$f['id_nffilter']])) {
48. $filtersSorted[$f['id_nffilter']] = array(
Argument [0] Array ( )
112.
113. $this->productSort(); // Product sort must be called before assignProductList()
114.
115. $this->assignScenes();
116. $this->assignSubcategories();
117. $this->assignProductList();
118.
119. $this->context->smarty->assign(array(
120. 'category' => $this->category,
121. 'description_short' => Tools::truncateString($this->category->description, 350),
122. 'products' => (isset($this->cat_products) && $this->cat_products) ? $this->cat_products : null,
174.
175. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))
176. $this->initHeader();
177.
178. if ($this->viewAccess())
179. $this->initContent();
180. else
181. $this->errors[] = Tools::displayError('Access denied.');
182.
183. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className)))
184. $this->initFooter();
368. // Execute hook dispatcher
369. if (isset($params_hook_action_dispatcher))
370. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
371.
372. // Running controller
373. $controller->run();
374. }
375. catch (PrestaShopException $e)
376. {
377. $e->displayMessage();
378. }
22. * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
23. * International Registered Trademark & Property of PrestaShop SA
24. */
25.
26. require(dirname(__FILE__).'/config/config.inc.php');
27. Dispatcher::getInstance()->dispatch();