blank front page

Sterminous · April 8, 2014

Problem started today, yesterday everything was normal, it just stated, no one has changed anything, mobile version is working, i tried with the default theme to, but still blank page. What should i do?

Admin panel is working, i didn't update anything, i'm using 1.5.6.1

Sterminous · April 9, 2014

how to fix this?, anyone know?

NemoPS · April 9, 2014

Enable error reporting as described in my signature, then post back the error here

Sterminous · April 9, 2014

Error code:

Fatal error: Call to undefined method Link::getPageLinkOld() in ./modules/plblog/plblog.php on line 635

Sterminous · April 9, 2014

Error code:

Fatal error: Call to undefined method Link::getPageLinkOld() in ./modules/plblog/plblog.php on line 635

Module caused this problem

Sterminous · April 9, 2014

Module caused this problem

I disabled this module and i got this error:

[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 '1,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,3' at line 29


SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,
					pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
					pl.`meta_keywords`, pl.`meta_title`, pl.`name`,
					m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer,
					MAX(image_shop.`id_image`) id_image, il.`legend`,
					ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`,
					DATEDIFF(p.`date_add`, DATE_SUB(NOW(),
					INTERVAL 20 DAY)) > 0 AS new
				FROM `prestashop_product_sale` ps
				LEFT JOIN `prestashop_product` p ON ps.`id_product` = p.`id_product`
				 LEFT JOIN prestashop_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
				LEFT JOIN `prestashop_product_lang` pl
					ON p.`id_product` = pl.`id_product`
					AND pl.`id_lang` = 2 AND pl.id_shop = 1 
				LEFT JOIN `prestashop_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN prestashop_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 `prestashop_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
				LEFT JOIN `prestashop_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
				LEFT JOIN `prestashop_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`)
					AND tr.`id_country` = 86
					AND tr.`id_state` = 0
				LEFT JOIN `prestashop_tax` t ON (t.`id_tax` = tr.`id_tax`)
				 LEFT 
			JOIN prestashop_stock_available stock
			ON (stock.id_product = p.id_product AND stock.id_shop = 1  )
				WHERE product_shop.`active` = 1
					AND p.`visibility` != 'none'
					AND p.`id_product` IN (,1,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43)
				GROUP BY product_shop.id_product
				ORDER BY `sales` DESC
				LIMIT 0, 6

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. 	/**
DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 488 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 122 - classes/ProductSale.php] - [1 Arguments]
ProductSaleCore::getBestSales - [line 202 - modules/gameworldtopseller/gameworldtopseller.php] - [3 Arguments]
gameworldtopseller->hookHome - [line 475 - classes/Hook.php] - [1 Arguments]
HookCore::exec - [line 39 - controllers/front/IndexController.php] - [1 Arguments]
IndexControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]
ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument]

Sterminous · April 9, 2014

I disabled this module and i got this error:

[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 '1,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,3' at line 29


SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,
					pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
					pl.`meta_keywords`, pl.`meta_title`, pl.`name`,
					m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer,
					MAX(image_shop.`id_image`) id_image, il.`legend`,
					ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`,
					DATEDIFF(p.`date_add`, DATE_SUB(NOW(),
					INTERVAL 20 DAY)) > 0 AS new
				FROM `prestashop_product_sale` ps
				LEFT JOIN `prestashop_product` p ON ps.`id_product` = p.`id_product`
				 LEFT JOIN prestashop_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
				LEFT JOIN `prestashop_product_lang` pl
					ON p.`id_product` = pl.`id_product`
					AND pl.`id_lang` = 2 AND pl.id_shop = 1 
				LEFT JOIN `prestashop_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN prestashop_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 `prestashop_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
				LEFT JOIN `prestashop_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
				LEFT JOIN `prestashop_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`)
					AND tr.`id_country` = 86
					AND tr.`id_state` = 0
				LEFT JOIN `prestashop_tax` t ON (t.`id_tax` = tr.`id_tax`)
				 LEFT 
			JOIN prestashop_stock_available stock
			ON (stock.id_product = p.id_product AND stock.id_shop = 1  )
				WHERE product_shop.`active` = 1
					AND p.`visibility` != 'none'
					AND p.`id_product` IN (,1,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43)
				GROUP BY product_shop.id_product
				ORDER BY `sales` DESC
				LIMIT 0, 6

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. 	/**
DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 488 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 122 - classes/ProductSale.php] - [1 Arguments]
ProductSaleCore::getBestSales - [line 202 - modules/gameworldtopseller/gameworldtopseller.php] - [3 Arguments]
gameworldtopseller->hookHome - [line 475 - classes/Hook.php] - [1 Arguments]
HookCore::exec - [line 39 - controllers/front/IndexController.php] - [1 Arguments]
IndexControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]
ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument]

Problemo!

NemoPS · April 10, 2014

edit the getbestSales method of the ProductSale.php class file, find

AND p.`id_product` IN ('.$ids.')

And change it to

AND p.`id_product` IN ('.ltrim(',',$ids).')

Sterminous · April 10, 2014

edit the getbestSales method of the ProductSale.php class file, find

AND p.`id_product` IN ('.$ids.')

And change it to

AND p.`id_product` IN ('.ltrim(',',$ids).')

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 ') GROUP BY product_shop.id_product ORDER BY `sales` DESC LIMIT 0, 6' at line 29


SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,
					pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
					pl.`meta_keywords`, pl.`meta_title`, pl.`name`,
					m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer,
					MAX(image_shop.`id_image`) id_image, il.`legend`,
					ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`,
					DATEDIFF(p.`date_add`, DATE_SUB(NOW(),
					INTERVAL 20 DAY)) > 0 AS new
				FROM `prestashop_product_sale` ps
				LEFT JOIN `prestashop_product` p ON ps.`id_product` = p.`id_product`
				 LEFT JOIN prestashop_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
				LEFT JOIN `prestashop_product_lang` pl
					ON p.`id_product` = pl.`id_product`
					AND pl.`id_lang` = 2 AND pl.id_shop = 1 
				LEFT JOIN `prestashop_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN prestashop_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 `prestashop_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
				LEFT JOIN `prestashop_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
				LEFT JOIN `prestashop_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`)
					AND tr.`id_country` = 86
					AND tr.`id_state` = 0
				LEFT JOIN `prestashop_tax` t ON (t.`id_tax` = tr.`id_tax`)
				 LEFT 
			JOIN prestashop_stock_available stock
			ON (stock.id_product = p.id_product AND stock.id_shop = 1  )
				WHERE product_shop.`active` = 1
					AND p.`visibility` != 'none'
					AND p.`id_product` IN ()
				GROUP BY product_shop.id_product
				ORDER BY `sales` DESC
				LIMIT 0, 6

- now i have this error

Sterminous · April 10, 2014

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 ') GROUP BY product_shop.id_product ORDER BY `sales` DESC LIMIT 0, 6' at line 29


SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,
					pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
					pl.`meta_keywords`, pl.`meta_title`, pl.`name`,
					m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer,
					MAX(image_shop.`id_image`) id_image, il.`legend`,
					ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`,
					DATEDIFF(p.`date_add`, DATE_SUB(NOW(),
					INTERVAL 20 DAY)) > 0 AS new
				FROM `prestashop_product_sale` ps
				LEFT JOIN `prestashop_product` p ON ps.`id_product` = p.`id_product`
				 LEFT JOIN prestashop_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
				LEFT JOIN `prestashop_product_lang` pl
					ON p.`id_product` = pl.`id_product`
					AND pl.`id_lang` = 2 AND pl.id_shop = 1 
				LEFT JOIN `prestashop_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN prestashop_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 `prestashop_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
				LEFT JOIN `prestashop_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
				LEFT JOIN `prestashop_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`)
					AND tr.`id_country` = 86
					AND tr.`id_state` = 0
				LEFT JOIN `prestashop_tax` t ON (t.`id_tax` = tr.`id_tax`)
				 LEFT 
			JOIN prestashop_stock_available stock
			ON (stock.id_product = p.id_product AND stock.id_shop = 1  )
				WHERE product_shop.`active` = 1
					AND p.`visibility` != 'none'
					AND p.`id_product` IN ()
				GROUP BY product_shop.id_product
				ORDER BY `sales` DESC
				LIMIT 0, 6

- now i have this error

how to fix this?

NemoPS · April 11, 2014

sorry it's ltrim($ids,',')

Sterminous · April 11, 2014

sorry it's ltrim($ids,',')

Thank you, it helped.

blank front page

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in