Hi,
I've been using this PS 1.5.4.1 version and had no problems until recently. I've tried repairing and optimising my database via phpadmin and still to no avail. Any ideas? Help please...
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 `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 6 AND `active` = 1 AND cg.`id_group` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC at line 607 in file classes/db/Db.php
601. WebserviceRequest::getInstance()->setError(500, '
'.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 602. } 603. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 604. { 605. if ($sql) 606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 607. throw new PrestaShopDatabaseException($this->getMsgError()); 608. } 609. } 610. 611. /**
DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 482 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 529 - classes/Category.php] - [1 Arguments]
CategoryCore->getSubCategories - [line 165 - controllers/front/CategoryController.php] - [1 Arguments]
CategoryControllerCore->assignSubcategories - [line 111 - controllers/front/CategoryController.php] - [0 Argument]
CategoryControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]
ControllerCore->run - [line 349 - classes/Dispatcher.php] - [0 Argument]
DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument]