Got error 28 from storage engineSELECT DISTINCT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description_short`, pl.`link_rewrite`, pl.`name`, pl.`available_now`, pl.`available_later`,
MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` manufacturer_name, 1 position,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-03-19 00:00:00",
INTERVAL 1 DAY
)
) > 0 new
FROM
`ps_tag` t
STRAIGHT_JOIN `ps_product_tag` pt ON (pt.`id_tag` = t.`id_tag` AND t.`id_lang` = 1)
STRAIGHT_JOIN `ps_product` p ON (p.`id_product` = pt.`id_product`)
INNER JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1
)
LEFT JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
LEFT JOIN `ps_category_product` cp ON (cp.`id_product` = p.`id_product`)
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = cp.`id_category`)
LEFT JOIN `ps_category_shop` cs ON (cp.`id_category` = cs.`id_category` AND cs.`id_shop` = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 )
WHERE product_shop.`active` = 1
AND cs.`id_shop` = 1
AND cg.`id_group` = 1
AND t.`name` LIKE '%luxea%'
GROUP BY product_shop.id_product
ORDER BY position DESC
LIMIT 0,6
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 DISTINCT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description_short`, pl.`link_rewrite`, pl.`name`, pl.`available_now`, pl.`available_later`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` manufacturer_name, 1 position, DATEDIFF( p.`date_add`, DATE_SUB( "2024-03-19 00:00:00", INTERVAL 1 DAY ) ) > 0 new FROM `ps_tag` t STRAIGHT_JOIN `ps_product_tag` pt ON (pt.`id_tag` = t.`id_tag` AND t.`id_lang` = 1) STRAIGHT_JOIN `ps_product` p ON (p.`id_product` = pt.`id_product`) INNER JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_category_product` cp ON (cp.`id_product` = p.`id_product`) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = cp.`id_category`) LEFT JOIN `ps_category_shop` cs ON (cp.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND cs.`id_shop` = 1 AND cg.`id_group` = 1 AND t.`name` LIKE '%luxea%' GROUP BY product_shop.id_product ORDER BY position DESC LIMIT 0,6
638. throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');
639. }
640. return $this->execute($sql, $use_cache);
641. }
642.
643. $this->result = $this->query($sql);
644.
645. if (!$this->result) {
646. $result = false;
647. } else {
648. if (!$array) {
Argument [0] SELECT DISTINCT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description_short`, pl.`link_rewrite`, pl.`name`, pl.`available_now`, pl.`available_later`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` manufacturer_name, 1 position, DATEDIFF( p.`date_add`, DATE_SUB( "2024-03-19 00:00:00", INTERVAL 1 DAY ) ) > 0 new FROM `ps_tag` t STRAIGHT_JOIN `ps_product_tag` pt ON (pt.`id_tag` = t.`id_tag` AND t.`id_lang` = 1) STRAIGHT_JOIN `ps_product` p ON (p.`id_product` = pt.`id_product`) INNER JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_category_product` cp ON (cp.`id_product` = p.`id_product`) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = cp.`id_category`) LEFT JOIN `ps_category_shop` cs ON (cp.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND cs.`id_shop` = 1 AND cg.`id_group` = 1 AND t.`name` LIKE '%luxea%' GROUP BY product_shop.id_product ORDER BY position DESC LIMIT 0,6
853. '.$sql_groups.'
854. AND t.`name` LIKE \'%'.pSQL($tag).'%\'
855. GROUP BY product_shop.id_product
856. ORDER BY position DESC'.($orderBy ? ', '.$orderBy : '').($orderWay ? ' '.$orderWay : '').'
857. LIMIT '.(int)(($pageNumber - 1) * $pageSize).','.(int)$pageSize;
858. if (!$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql, true, false)) {
859. return false;
860. }
861.
862. return Product::getProductsProperties((int)$id_lang, $result);
863. }
Argument [0] SELECT DISTINCT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description_short`, pl.`link_rewrite`, pl.`name`, pl.`available_now`, pl.`available_later`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` manufacturer_name, 1 position, DATEDIFF( p.`date_add`, DATE_SUB( "2024-03-19 00:00:00", INTERVAL 1 DAY ) ) > 0 new FROM `ps_tag` t STRAIGHT_JOIN `ps_product_tag` pt ON (pt.`id_tag` = t.`id_tag` AND t.`id_lang` = 1) STRAIGHT_JOIN `ps_product` p ON (p.`id_product` = pt.`id_product`) INNER JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_category_product` cp ON (cp.`id_product` = p.`id_product`) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = cp.`id_category`) LEFT JOIN `ps_category_shop` cs ON (cp.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND cs.`id_shop` = 1 AND cg.`id_group` = 1 AND t.`name` LIKE '%luxea%' GROUP BY product_shop.id_product ORDER BY position DESC LIMIT 0,6 Argument [1] 1 Argument [2]
116. 'search_query' => $original_query,
117. 'homeSize' => Image::getSize(ImageType::getFormatedName('home'))));
118. } elseif (($tag = urldecode(Tools::getValue('tag'))) && !is_array($tag)) {
119. $nbProducts = (int)(Search::searchTag($this->context->language->id, $tag, true));
120. $this->pagination($nbProducts);
121. $result = Search::searchTag($this->context->language->id, $tag, false, $this->p, $this->n, $this->orderBy, $this->orderWay);
122. Hook::exec('actionSearch', array('expr' => $tag, 'total' => count($result)));
123.
124. $this->addColorsToProductList($result);
125.
126. $this->context->smarty->assign(array(
Argument [0] 1 Argument [1] luxea Argument [2] Argument [3] 1 Argument [4] 6 Argument [5] Argument [6]
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();