error in prestashop

[vineon]

i have this error in prestashop front page i have enabled dev mode here  my page http://proreseller.procardsmexico.com/index.php

 

here th error

SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,

pl.`available_later`, 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, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
INTERVAL 2999999
DAY)) > 0 AS new, product_shop.price AS orderprice, AVG(pc.grade) as avg_grade
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
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_attribute` pa
ON (p.`id_product` = pa.`id_product`)
LEFT JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.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 (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`


JOIN `ps_product_comment` pc ON (cp.id_product = pc.id_product AND pc.validate = 1)


WHERE product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND cp.id_category IN (0, 12) GROUP BY product_shop.id_product ORDER BY avg_grade DESC LIMIT 0,6

at line 791 in file classes/db/Db.php
786. if ($webservice_call && $errno) {
787. $dbg = debug_backtrace();
788. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790. if ($sql) {
791. throw new PrestaShopDatabaseException($this->getMsgError().'
 

'.$sql.'

');
792. }
793.
794. throw new PrestaShopDatabaseException($this->getMsgError());
795. }
796. }
DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 333 - themes/pf_imart/modules/pspagebuilder/classes/widget/categories_sub_products.php] - [1 Arguments]
PsWidgetCategories_sub_products::getProducts - [line 216 - themes/pf_imart/modules/pspagebuilder/classes/widget/categories_sub_products.php] - [3 Arguments]
PsWidgetCategories_sub_products->renderContent - [line 360 - modules/pspagebuilder/classes/profile.php] - [1 Arguments]
PsPagebuilderprofile->getWidgetContent - [line 368 - modules/pspagebuilder/pspagebuilder.php] - [2 Arguments]
PsPageBuilder->buildLayoutData - [line 321 - modules/pspagebuilder/pspagebuilder.php] - [4 Arguments]
PsPageBuilder->processHook - [line 150 - modules/pspagebuilder/pspagebuilder.php]
PsPageBuilder->hookdisplayHeader - [line 587 - classes/Hook.php] - [1 Arguments]
HookCore::coreCallHook - [line 542 - classes/Hook.php] - [3 Arguments]
HookCore::exec - [line 579 - classes/controller/FrontController.php] - [1 Arguments]
FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php]
IndexControllerCore->initContent - [line 189 - classes/controller/Controller.php]
ControllerCore->run - [line 367 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]

 

[prestamonste]

Hi,

 

Please check table ps_product_comment exist or not. Maybe your database doesn't exist this table.