all products disappeared from shop front

[GraceGoh]

Hi,

 

All my products cannot be displayed in my shop front.  This includes featured products.  I did not do any upgrade, development or make any changes to back office.  Nor did I change my hardware platform.  What's happening ?  I am using 1.5.4.1.  

 

Getting anxious ...

[GraceGoh]

and i just checked all my categories disappeared from the back office.  But in front office, the categories are still displayed on the left hand side .... and without any products when I click on each category ...

[selectshop.at]

activate debug-modus and post the errors:

 

rework your file /config/defines.inc.php and change the false to true.

/* Debug only */
define('_PS_MODE_DEV_', true);
if (_PS_MODE_DEV_)

Edited April 1, 2014 by selectshop.at (see edit history)

[GraceGoh]

[PrestaShopDatabaseException]

Got error 28 from storage engine
 

        SELECT SQL_CALC_FOUND_ROWS
        a.`id_category`,`name`,`description`,sa.position as position,`active`
        , sa.position position
        FROM `ps_category` a
        LEFT JOIN `ps_category_lang` b ON (b.`id_category` = a.`id_category` AND b.`id_lang` = 1 AND b.`id_shop` = 1)
         LEFT JOIN `ps_category_shop` sa ON (a.`id_category` = sa.`id_category` AND sa.id_shop = 1)
        
        WHERE 1 AND `id_parent` = 2
        
        
        ORDER BY sa.`position` asc LIMIT 0,50
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.     /**

Edited April 2, 2014 by GraceGoh (see edit history)

[GraceGoh]

Hi,

 

Thanks all.  I have resolved this issue.  It's a memory problem.  Will mark as closed.