[PrestaShopDatabaseException]

[jlan62]

Bonjour à tous,

 

J'ai le problème suivant en activant le mode débug.

Merci pour votre aide

 

 

Table 'scrapboo_sb01.ps_product_comment_usefulness' doesn't exist
 

			SELECT pc.`id_product_comment`,			(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment` AND pcu.`usefulness` = 1) as total_useful,			(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment`) as total_advice, 			IF(c.id_customer, CONCAT(c.`firstname`, ' ',  LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title			  FROM `ps_product_comment` pc			LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer`			WHERE pc.`id_product` = 2453 AND pc.`validate` = 1			ORDER BY pc.`date_add` DESC			

at line 646 in file classes/db/Db.php

641. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);642. 		}643. 		elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))644. 		{645. 			if ($sql)646. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');647. 			throw new PrestaShopDatabaseException($this->getMsgError());648. 		}649. 	}650. 651. 	/**

• DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 516 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 114 - modules/productcomments/ProductComment.php] - [1 Arguments]
• ProductComment::getByProduct - [line 749 - modules/productcomments/productcomments.php] - [1 Arguments]
• ProductComments->hookProductTab - [line 512 - classes/Hook.php] - [1 Arguments]
• HookCore::exec - [line 275 - controllers/front/ProductController.php] - [2 Arguments]
• ProductControllerCore->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

[jlan62]

Bonjour,

 

J'ai résolu mon problème. Il s'agissait d'une erreur au niveau du module "commentaires produits".

Je l'ai réinitialisé.

 

@+