Help! PrestaShopDatabaseException

[otaktakcenter]

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]