PrestaShopDatabaseException

[hubthomas]

Hello, I have big problems with my Prestashop. I enbaled the Dev mode to check BlockNewsletter but on my index page this is what i get ...

 

Table 'ovh_prestashop.heu007product_comment' doesn't exist

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 30
	                    DAY)) > 0 AS new, product_shop.price AS orderprice, AVG(pc.grade) as avg_grade
	            FROM `heu007category_product` cp
	            LEFT JOIN `heu007product` p
	                ON p.`id_product` = cp.`id_product`
	             INNER JOIN heu007product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
	            LEFT JOIN `heu007product_attribute` pa
	            ON (p.`id_product` = pa.`id_product`)
	             LEFT JOIN heu007product_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 heu007stock_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 `heu007category_lang` cl
	                ON (product_shop.`id_category_default` = cl.`id_category`
	                AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
	            LEFT JOIN `heu007product_lang` pl
	                ON (p.`id_product` = pl.`id_product`
	                AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
	            LEFT JOIN `heu007image` i
	                ON (i.`id_product` = p.`id_product`) LEFT JOIN heu007image_shop image_shop
		ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
	            LEFT JOIN `heu007image_lang` il
	                ON (image_shop.`id_image` = il.`id_image`
	                AND il.`id_lang` = 1)
	            LEFT JOIN `heu007manufacturer` m
	                ON m.`id_manufacturer` = p.`id_manufacturer`

	            
				JOIN `heu007product_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, 2,12,13,14,15,18,64,65,16) GROUP BY product_shop.id_product  ORDER BY avg_grade DESC  LIMIT 0,10

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

786.         if ($webservice_call && $errno) {
787.             $dbg = debug_backtrace();
788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$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 325 - modules/pspagebuilder/classes/widget/producttabs.php] - [1 Arguments]
• PsWidgetProducttabs::getProducts - [line 248 - modules/pspagebuilder/classes/widget/producttabs.php] - [3 Arguments]
• PsWidgetProducttabs->renderContent - [line 360 - modules/pspagebuilder/classes/profile.php] - [1 Arguments]
• PsPagebuilderprofile->getWidgetContent - [line 367 - modules/pspagebuilder/pspagebuilder.php] - [2 Arguments]
• PsPageBuilder->buildLayoutData - [line 320 - modules/pspagebuilder/pspagebuilder.php] - [4 Arguments]
• PsPageBuilder->processHook - [line 149 - modules/pspagebuilder/pspagebuilder.php]
• PsPageBuilder->hookdisplayHeader - [line 591 - classes/Hook.php] - [1 Arguments]
• HookCore::coreCallHook - [line 546 - 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]

 

 

Don't know what to do ...

[bellini13]

looks like you are using a custom module named pspagebuilder, and this module is expecting the product comments module to be installed, and a database table to exist, which apparently is not the case.

 

Perhaps you should contact the author of the pspagebuilder module for further assistance.