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` = 167
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` = 167 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` = 167 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` = 167 AND `active` = 1 AND cg.`id_group` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
479. if ($this->category !== false && Validate::isLoadedObject($this->category) && $this->category->inShop() && $this->category->isAssociatedToShop())
480. {
481. $path = Tools::getPath($this->category->id, $this->product->name, true);
482. $this->context->smarty->assign(array(
483. 'category' => $this->category,
484. 'subCategories' => $this->category->getSubCategories($this->context->language->id, true),
485. 'id_category_current' => (int)$this->category->id,
486. 'id_category_parent' => (int)$this->category->id_parent,
487. 'return_category_name' => Tools::safeOutput($this->category->name)
488. ));
489. }
Argument [0] 7 Argument [1] 1
210. $this->context->smarty->assign(array(
211. 'pictures' => $pictures,
212. 'textFields' => $text_fields));
213.
214. // Assign template vars related to the category + execute hooks related to the category
215. $this->assignCategory();
216. // Assign template vars related to the price and tax
217. $this->assignPriceAndTax();
218.
219. // Assign template vars related to the images
220. $this->assignImages();
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.