Prestashop upgrade errors help needed

[Dickie]

Hi there,

 

If anyone can help with a load of errors I've encountered while trying to upgrade and install a new theme on my site it would be great.

 

here's what i get when going on to the homepage.

[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 ') AND product_shop.`active` = 1 AND product_' at line 21

 

SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, product_attribute_shop.id_product_attribute,

pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,

pl.`name`, image_shop.`id_image`, il.`legend`, m.`name` AS manufacturer_name

FROM `ps_product` p

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 (pa.id_product = p.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 = 0 AND stock.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 (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)

LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)

WHERE p.`id_product` IN()

AND product_shop.`active` = 1

AND product_shop.`show_price` = 1

AND ((image_shop.id_image IS NOT NULL OR i.id_image IS NULL) OR (image_shop.id_image IS NULL AND i.cover=1))

AND (pa.id_product_attribute IS NULL OR product_attribute_shop.default_on = 1)

 

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

 

 

601. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

602. }

603. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))

604. {

605. if ($sql)

[color=#F20000][b]606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');[/b][/color]

607. throw new PrestaShopDatabaseException($this->getMsgError());

608. }

609. }

610.

611. /**[/font][/color]

• [b]DbCore->displayError[/b] - [line 307 - classes/db/Db.php] - [1 Arguments]
  
• [b]DbCore->query[/b] - [line 482 - classes/db/Db.php] - [1 Arguments]
  
• [b]DbCore->executeS[/b] - [line 683 - modules/smartproductslider/smartproductslider.php] - [1 Arguments]
  
• [b]SmartProductSlider->hookDisplayHome[/b] - [line 421 - classes/Hook.php] - [1 Arguments]
  
• [b]HookCore::exec[/b] - [line 39 - controllers/front/IndexController.php] - [1 Arguments]
  
• [b]IndexControllerCore->initContent[/b] - [line 167 - classes/controller/Controller.php] - [size=3][0 Argument][/size]
  
• [b]ControllerCore->run[/b] - [line 349 - classes/Dispatcher.php] - [size=3][0 Argument][/size]
  
• [b]DispatcherCore->dispatch[/b] - [line 28 - index.php] - [size=3][0 Argument][/size]
  

[size=3]Regards[/size]

[NemoPS]

DIsable the smartProductSlider module. Then try and see if reinstalling it helps, or if there's any new version available