[solved] Prestashop database error

[idrissohs]

This all started after I install a module product pro filter that I bought from preteamshop. now I get this error everytime I use prestashop's search module. I did uninstall the module however it didn't fix the problem

 

[PrestaShopDatabaseException]

 

Incorrect key file for table '/tmp/#sql_37c1_2.MYI'; try to repair it

 

SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,

pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name,

DATEDIFF(

product_shop.`date_add`,

DATE_SUB(

NOW(),

INTERVAL 20 DAY

)

) > 0 AS new

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

p.`id_product` = pl.`id_product`

AND pl.`id_lang` = 1 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 i.`id_image` = il.`id_image` AND il.`id_lang` = 1

LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`

LEFT

JOIN ps_stock_available stock

ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 )

WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (

DATEDIFF(

product_shop.`date_add`,

DATE_SUB(

NOW(),

INTERVAL 20 DAY

)

) > 0) AND (p.`id_product` IN (

SELECT cp.`id_product`

FROM `ps_category_group` cg

LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)

WHERE cg.`id_group` = 1))

GROUP BY product_shop.id_product

ORDER BY p.`date_add` DESC

LIMIT 5

 

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. /**[/size][/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 2052 - classes/Product.php] - [1 Arguments]
  
• [b]ProductCore::getNewProducts[/b] - [line 98 - modules/blocknewproducts/blocknewproducts.php] - [3 Arguments]
  
• [b]BlockNewProducts->hookRightColumn[/b] - [line 423 - classes/Hook.php] - [1 Arguments]
  
• [b]HookCore::exec[/b] - [line 428 - classes/controller/FrontController.php] - [2 Arguments]
  
• [b]FrontControllerCore->initContent[/b] - [line 58 - controllers/front/SearchController.php] - [size=3][0 Argument][/size]
  
• [b]SearchControllerCore->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]
   
   
  Please help and thank you[/size]
  

Edited August 7, 2013 by vekia (see edit history)

[idrissohs]

I solved the problem by going to phpadmin and running the repair query

[vekia]

thanks for information that you fixed it and of course for the solution

im going to mark this topic as [solved]

 

best regards