erroren prestashop

[vineon]

Buenas tardes hice una instalacion limpia de prestashop intale un tema que tenia en una antigua tienda y ahora me aparece esto http://proreseller.procardsmexico.com/index.php esta activado el dev_mode si lo desactivo la pagina funciona , me gustaria saber si estos errores afectan algo el funcionamiento? y si es asi como puedo corregirlos

 

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().'<br /><br /><pre>'.$sql.'</pre>');
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]

Edited October 23, 2016 by vineon (see edit history)