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 ') AND `is_no_index` = '1' LIMIT 1' at line 1SELECT page_id FROM `icode_pw_seo_no_index` WHERE `page_name` = 'product' AND `page_id` IN() AND `is_no_index` = '1' 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] SELECT page_id FROM `icode_pw_seo_no_index` WHERE `page_name` = 'product' AND `page_id` IN() AND `is_no_index` = '1' LIMIT 1
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] SELECT page_id FROM `icode_pw_seo_no_index` WHERE `page_name` = 'product' AND `page_id` IN() AND `is_no_index` = '1' LIMIT 1
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] SELECT page_id FROM `icode_pw_seo_no_index` WHERE `page_name` = 'product' AND `page_id` IN() AND `is_no_index` = '1' LIMIT 1 Argument [1] 1
72. $this->addColorsToProductList($products);
73.
74. $prdIds = array();
75. $db = DB::getInstance();
76. foreach ($products as &$prd) {
77. $isNoIndex = $db->getValue("SELECT page_id FROM `icode_pw_seo_no_index` WHERE `page_name` = 'product' AND `page_id` IN(".implode(",", $prdIds).") AND `is_no_index` = '1'");
78. if($isNoIndex) {
79. $prd["nofollow"] = 1;
80. }
81. }
82.
Argument [0] SELECT page_id FROM `icode_pw_seo_no_index` WHERE `page_name` = 'product' AND `page_id` IN() AND `is_no_index` = '1'
75. {
76. parent::initContent();
77.
78. if (Validate::isLoadedObject($this->manufacturer) && $this->manufacturer->active && $this->manufacturer->isAssociatedToShop()) {
79. $this->productSort();
80. $this->assignOne();
81. $this->setTemplate(_PS_THEME_DIR_.'manufacturer.tpl');
82. } else {
83. $this->assignAll();
84. $this->setTemplate(_PS_THEME_DIR_.'manufacturer-list.tpl');
85. }
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.
144. // echo '</pre>';
145.
146.
147.
148.
149. Dispatcher::getInstance()->dispatch();
150.
151.
152.