Jump to content

Blank page and error after modul installation


Recommended Posts

Hello,

 

I bought a template at the prestashop store and I installed it in the admin area. The template should be installed by themeinstallator upload, but this didn´t work. I installed it by FTP upload, so I see a preview of my template in the modules area.

 

Unfortunately there is a white page when I go on the site (customers view). I tried to get an error message like the users in this thread: http://www.prestashop.com/forums/topic/292094-solved-blank-product-page/

 

And this i what I got:

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY RAND() LIMIT 0, 3' at line 22
 

		SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,		pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate`, m.`name` AS manufacturer_name,		DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new		FROM `pq_product` p		LEFT JOIN `pq_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1)		LEFT JOIN `pq_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)		LEFT JOIN `pq_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)		LEFT JOIN `pq_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`		                                           AND tr.`id_country` = 1	                                           	   AND tr.`id_state` = 0)	    LEFT JOIN `pq_tax` t ON (t.`id_tax` = tr.`id_tax`)		LEFT JOIN `pq_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)		WHERE 1		AND p.`active` = 1		AND p.`show_price` = 1		 AND p.`id_product` IN (1)		AND p.`id_product` IN (			SELECT cp.`id_product`			FROM `pq_category_group` cg			LEFT JOIN `pq_category_product` cp ON (cp.`id_category` = cg.`id_category`)			WHERE cg.`id_group` = 1 and cg.`id_category`= 		)		ORDER BY RAND() LIMIT 0, 3

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

607. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);608. 		}609. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))610. 		{611. 			if ($sql)612. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');613. 			throw new PrestaShopDatabaseException($this->getMsgError());614. 		}615. 	}616. 617. 	/**

How should I fix it ? I don´t get how to do this ?

 

Thank you very much for helping !

 

Best regards,

 

Robby1199

 

Link to comment
Share on other sites

  • 2 weeks later...

Thank you for the answer. Now I installed the version 1.5.6.1 completely new and also turned the reporting modus on.

This is what I get:

 

[PrestaShopDatabaseException]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY RAND() LIMIT 0, 3' at line 22

SELECT p.*, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,		pl.`name`, p.`ean13`, p.`upc`, i.`id_image`, il.`legend`, t.`rate`, m.`name` AS manufacturer_name,		DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new		FROM `ps_product` p		LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1)		LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)		LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)		LEFT JOIN `ps_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`		                                           AND tr.`id_country` = 1	                                           	   AND tr.`id_state` = 0)	    LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)		LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)		WHERE 1		AND p.`active` = 1		AND p.`show_price` = 1		 AND p.`id_product` IN (1)		AND p.`id_product` IN (			SELECT cp.`id_product`			FROM `ps_category_group` cg			LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)			WHERE cg.`id_group` = 1 and cg.`id_category`= 		)		ORDER BY RAND() LIMIT 0, 3

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

607. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);608. 		}609. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))610. 		{611. 			if ($sql)612. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');613. 			throw new PrestaShopDatabaseException($this->getMsgError());614. 		}615. 	}616. 617. 	/**
Link to comment
Share on other sites

Hey,

 

Thank you for the answer. I can connect to the back office. The only modul I find when I type "csblockcateogryspecial" into the fiel is the modul called "Special Product by category". When I disable it, the error message disappears and there stand the sentence:

 

"Fatal error: Call to undefined method Hook::getIdByNameIdByName() in C:\xampp\Xamp2\htdocs\PrestaShop\prestashop\modules\csstaticblocks\csstaticblocks.php on line 632"

 

What should I do ?

Link to comment
Share on other sites

×
×
  • Create New...