Errcode: 28 problem

[djaenicke]

Hi,

My website (www.joovuu.com) is throwing up this problem when i try to visit it. A server restart seems to temporarily solve the problem but then it comes back. Any idea the problem?

 

Thank you

[PrestaShopDatabaseException]

Can't create/write to file '/tmp/#sql_4823_0.MYI' (Errcode: 28)

SELECT image_shop.id_image, p.id_product, il.legend, product_shop.active, pl.name, pl.description_short, pl.link_rewrite, cl.link_rewrite AS category_rewrite

FROM ps_product p

INNER JOIN ps_product_shop product_shop

ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)

LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1 )

LEFT JOIN ps_image i ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop

ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)

LEFT JOIN ps_image_lang il ON (il.id_image = i.id_image)

LEFT JOIN ps_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 )

WHERE p.id_product IN (14,17)

AND pl.id_lang = 2

AND cl.id_lang = 2

GROUP BY product_shop.id_product

 

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)

[color=#F20000][b]606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

[/b][/color]607. throw new PrestaShopDatabaseException($this->getMsgError());

608. }

609. }

610.

611. /**

[/font][/color]

• [b]DbCore->displayError[/b] - [line 307 - classes/db/Db.php] - [1 Arguments]
  
• [b]DbCore->query[/b] - [line 482 - classes/db/Db.php] - [1 Arguments]
  
• [b]DbCore->executeS[/b] - [line 116 - modules/blockviewed/blockviewed.php] - [1 Arguments]
  
• [b]BlockViewed->hookRightColumn[/b] - [line 178 - modules/blockviewed/blockviewed.php] - [1 Arguments]
  
• [b]BlockViewed->hookLeftColumn[/b] - [line 423 - classes/Hook.php] - [1 Arguments]
  
• [b]HookCore::exec[/b] - [line 427 - classes/controller/FrontController.php] - [1 Arguments]
  
• [b]FrontControllerCore->initContent[/b] - [line 37 - controllers/front/IndexController.php] - [size=3][0 Argument][/size]
  
• [b]IndexControllerCore->initContent[/b] - [line 167 - classes/controller/Controller.php] - [size=3][0 Argument][/size]
  
• [b]ControllerCore->run[/b] - [line 349 - classes/Dispatcher.php] - [size=3][0 Argument][/size]
  
• [b]DispatcherCore->dispatch[/b] - [line 28 - index.php] - [size=3][0 Argument][/size]
  

[PascalVG]

Did you try to (temporarily) disable the 'viewed products block' module? Might be that there may be some problem with the module, if I see the error list. If you disable this one and try for a while and see no error anymore, this may be the culprit then.

 

If so, uninstall/re-install the module and see if that helps. (Also go into configure and see if the amount of products to show > 0 )

 

Hope this helps,

pascal