Got error 28 from storage engine
SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `eh_category` c
INNER JOIN eh_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `eh_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 1 )
LEFT JOIN `eh_category_group` cg
ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 219
AND `active` = 1
AND cg.`id_group` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
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 c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `eh_category` c INNER JOIN eh_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `eh_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 7 AND cl.id_shop = 1 ) LEFT JOIN `eh_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 219 AND `active` = 1 AND cg.`id_group` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
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 c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `eh_category` c INNER JOIN eh_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `eh_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 7 AND cl.id_shop = 1 ) LEFT JOIN `eh_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 219 AND `active` = 1 AND cg.`id_group` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
531. WHERE `id_parent` = '.(int)$this->id.'
532. '.($active ? 'AND `active` = 1' : '').'
533. AND cg.`id_group` '.$sql_groups.'
534. GROUP BY c.`id_category`
535. ORDER BY `level_depth` ASC, category_shop.`position` ASC
536. ');
537.
538. foreach ($result as &$row)
539. {
540. $row['id_image'] = file_exists(_PS_CAT_IMG_DIR_.$row['id_category'].'.jpg') ? (int)$row['id_category'] : Language::getIsoById($id_lang).'-default';
541. $row['legend'] = 'no picture';
Argument [0] SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `eh_category` c INNER JOIN eh_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `eh_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 7 AND cl.id_shop = 1 ) LEFT JOIN `eh_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 219 AND `active` = 1 AND cg.`id_group` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
159. /**
160. * Assign sub categories templates vars
161. */
162. protected function assignSubcategories()
163. {
164. if ($subCategories = $this->category->getSubCategories($this->context->language->id))
165. {
166. $this->context->smarty->assign(array(
167. 'subcategories' => $subCategories,
168. 'subcategories_nb_total' => count($subCategories),
169. 'subcategories_nb_half' => ceil(count($subCategories) / 2)
Argument [0] 7
105. $this->context->smarty->assign('compareProducts', CompareProduct::getCompareProducts((int)$this->context->cookie->id_compare));
106.
107. $this->productSort(); // Product sort must be called before assignProductList()
108.
109. $this->assignScenes();
110. $this->assignSubcategories();
111. if ($this->category->id != 1)
112. $this->assignProductList();
113.
114. $this->context->smarty->assign(array(
115. 'category' => $this->category,
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.