Jump to content

PrestaShopDatabaseException


hubthomas
 Share

Recommended Posts

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.     }

 

 

Don't know what to do ...

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More