Got error 28 from storage engineSELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pa.`id_product_attribute`,
pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`,
pl.`meta_title`, pl.`name`, image_shop.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`,
DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
NOW(),
INTERVAL 20 DAY
)
) > 0 AS new,
(product_shop.`price` * ((100 + (t.`rate`))/100)) AS orderprice
FROM `eh_product` p
INNER JOIN eh_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `eh_product_attribute` pa
ON (p.`id_product` = pa.`id_product`)
LEFT JOIN eh_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `eh_product_lang` pl
ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 7 AND pl.id_shop = 1 )
LEFT JOIN `eh_image` i
ON (i.`id_product` = p.`id_product`) LEFT JOIN eh_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN `eh_image_lang` il
ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
LEFT JOIN `eh_tax_rule` tr
ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`
AND tr.`id_country` = 37
AND tr.`id_state` = 0
AND tr.`zipcode_from` = 0)
LEFT JOIN `eh_tax` t
ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `eh_tax_lang` tl
ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 7)
LEFT JOIN `eh_manufacturer` m
ON (m.`id_manufacturer` = p.`id_manufacturer`)
LEFT
JOIN eh_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 )
WHERE p.`id_manufacturer` = 291
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND (product_attribute_shop.default_on = 1 OR product_attribute_shop.default_on IS NULL)
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `eh_category_group` cg
LEFT JOIN `eh_category_product` cp
ON (cp.`id_category` = cg.`id_category`) INNER JOIN `eh_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE cg.`id_group` = 1
)
AND ((image_shop.id_image IS NOT NULL OR i.id_image IS NULL) OR (image_shop.id_image IS NULL AND i.cover=1))
ORDER BY pl.name asc
LIMIT 0,50
at line 605 in file classes/db/Db.php
599. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
600. }
601. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
602. {
603. if ($sql)
604. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
605. throw new PrestaShopDatabaseException($this->getMsgError());
606. }
607. }
608.
609. /**
301. if ($sql instanceof DbQuery)
302. $sql = $sql->build();
303.
304. $this->result = $this->_query($sql);
305. if (_PS_DEBUG_SQL_)
306. $this->displayError($sql);
307. return $this->result;
308. }
309.
310. /**
311. * Execute an INSERT query
Argument [0] SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 20 DAY ) ) > 0 AS new, (product_shop.`price` * ((100 + (t.`rate`))/100)) AS orderprice FROM `eh_product` p INNER JOIN eh_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `eh_product_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN eh_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `eh_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 7 AND pl.id_shop = 1 ) LEFT JOIN `eh_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN eh_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `eh_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7) LEFT JOIN `eh_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 37 AND tr.`id_state` = 0 AND tr.`zipcode_from` = 0) LEFT JOIN `eh_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `eh_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 7) LEFT JOIN `eh_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN eh_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 ) WHERE p.`id_manufacturer` = 291 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND (product_attribute_shop.default_on = 1 OR product_attribute_shop.default_on IS NULL) AND p.`id_product` IN ( SELECT cp.`id_product` FROM `eh_category_group` cg LEFT JOIN `eh_category_product` cp ON (cp.`id_category` = cg.`id_category`) INNER JOIN `eh_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1 WHERE cg.`id_group` = 1 ) AND ((image_shop.id_image IS NOT NULL OR i.id_image IS NULL) OR (image_shop.id_image IS NULL AND i.cover=1)) ORDER BY pl.name asc LIMIT 0,50
476. {
477. $this->last_cached = true;
478. return $result;
479. }
480.
481. $this->result = $this->query($sql);
482. if (!$this->result)
483. return false;
484.
485. $this->last_cached = false;
486. if (!$array)
Argument [0] SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 20 DAY ) ) > 0 AS new, (product_shop.`price` * ((100 + (t.`rate`))/100)) AS orderprice FROM `eh_product` p INNER JOIN eh_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `eh_product_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN eh_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `eh_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 7 AND pl.id_shop = 1 ) LEFT JOIN `eh_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN eh_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `eh_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7) LEFT JOIN `eh_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 37 AND tr.`id_state` = 0 AND tr.`zipcode_from` = 0) LEFT JOIN `eh_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `eh_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 7) LEFT JOIN `eh_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN eh_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 ) WHERE p.`id_manufacturer` = 291 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND (product_attribute_shop.default_on = 1 OR product_attribute_shop.default_on IS NULL) AND p.`id_product` IN ( SELECT cp.`id_product` FROM `eh_category_group` cg LEFT JOIN `eh_category_product` cp ON (cp.`id_category` = cg.`id_category`) INNER JOIN `eh_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1 WHERE cg.`id_group` = 1 ) AND ((image_shop.id_image IS NOT NULL OR i.id_image IS NULL) OR (image_shop.id_image IS NULL AND i.cover=1)) ORDER BY pl.name asc LIMIT 0,50
373. )
374. AND ((image_shop.id_image IS NOT NULL OR i.id_image IS NULL) OR (image_shop.id_image IS NULL AND i.cover=1))
375. ORDER BY '.$alias.pSQL($order_by).' '.pSQL($order_way).'
376. LIMIT '.(((int)$p - 1) * (int)$n).','.(int)$n;
377.
378. $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
379.
380. if (!$result)
381. return false;
382.
383. if ($order_by == 'price')
Argument [0] SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 20 DAY ) ) > 0 AS new, (product_shop.`price` * ((100 + (t.`rate`))/100)) AS orderprice FROM `eh_product` p INNER JOIN eh_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `eh_product_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN eh_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `eh_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 7 AND pl.id_shop = 1 ) LEFT JOIN `eh_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN eh_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `eh_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7) LEFT JOIN `eh_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 37 AND tr.`id_state` = 0 AND tr.`zipcode_from` = 0) LEFT JOIN `eh_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `eh_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 7) LEFT JOIN `eh_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN eh_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 ) WHERE p.`id_manufacturer` = 291 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND (product_attribute_shop.default_on = 1 OR product_attribute_shop.default_on IS NULL) AND p.`id_product` IN ( SELECT cp.`id_product` FROM `eh_category_group` cg LEFT JOIN `eh_category_product` cp ON (cp.`id_category` = cg.`id_category`) INNER JOIN `eh_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1 WHERE cg.`id_group` = 1 ) AND ((image_shop.id_image IS NOT NULL OR i.id_image IS NULL) OR (image_shop.id_image IS NULL AND i.cover=1)) ORDER BY pl.name asc LIMIT 0,50
93. {
94. $nbProducts = $this->manufacturer->getProducts($this->manufacturer->id, null, null, null, $this->orderBy, $this->orderWay, true);
95. $this->pagination((int)$nbProducts);
96. $this->context->smarty->assign(array(
97. 'nb_products' => $nbProducts,
98. 'products' => $this->manufacturer->getProducts($this->manufacturer->id, $this->context->language->id, (int)$this->p, (int)$this->n, $this->orderBy, $this->orderWay),
99. 'path' => ($this->manufacturer->active ? Tools::safeOutput($this->manufacturer->name) : ''),
100. 'manufacturer' => $this->manufacturer,
101. 'comparator_max_item' => Configuration::get('PS_COMPARATOR_MAX_ITEM'))
102. );
103. }
Argument [0] 291 Argument [1] 7 Argument [2] 1 Argument [3] 50 Argument [4] position Argument [5] asc
74. parent::initContent();
75.
76. if (Validate::isLoadedObject($this->manufacturer) && $this->manufacturer->active && $this->manufacturer->isAssociatedToShop())
77. {
78. $this->productSort();
79. $this->assignOne();
80. $this->setTemplate(_PS_THEME_DIR_.'manufacturer.tpl');
81. }
82. else
83. {
84. $this->assignAll();
161.
162. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))
163. $this->initHeader();
164.
165. if ($this->viewAccess())
166. $this->initContent();
167. else
168. $this->errors[] = Tools::displayError('Access denied.');
169.
170. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className)))
171. $this->initFooter();
342. // Execute hook dispatcher
343. if (isset($params_hook_action_dispatcher))
344. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
345.
346. // Running controller
347. $controller->run();
348. }
349. catch (PrestaShopException $e)
350. {
351. $e->displayMessage();
352. }
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();
28.