prestashop 1.5.0.9 FrontOffice Error on product page

[ezakimak]

Hi,

 

I just isntalled ps1.5.0.9 and testing the FO I get this error .

 

Thanks for any help on this

 

Regards

 

[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 c.nright <= AND cl.id_lang = 1 AND c.active = 1 AND c.' at line 7

SELECT c.id_category, cl.name, cl.link_rewrite

FROM ps_category c

LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )

WHERE c.nleft <= 7

AND c.nright >= 8

AND c.nleft >=

AND c.nright <=

AND cl.id_lang = 1

AND c.active = 1

AND c.level_depth > 0

ORDER BY c.level_depth ASC

 

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

 

597. if ($webservice_call && $errno)

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

 '.$this->getMsgError().'. Query was : '.$sql, 97);

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

600. {

601. if ($sql)

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

[/b][/color]603. throw new PrestaShopDatabaseException($this->getMsgError());

604. }

605. }

606.

607. /**

[/font][/color]

• [b]DbCore->displayError[/b] - [line 308 - classes/db/Db.php] - [1 Arguments]
  
• [b]DbCore->query[/b] - [line 483 - classes/db/Db.php] - [1 Arguments]
  
• [b]DbCore->executeS[/b] - [line 992 - classes/Tools.php] - [1 Arguments]
  
• [b]ToolsCore::getPath[/b] - [line 445 - controllers/front/ProductController.php] - [3 Arguments]
  
• [b]ProductControllerCore->assignCategory[/b] - [line 188 - controllers/front/ProductController.php] - [size=3][0 Argument][/size]
  
• [b]ProductControllerCore->initContent[/b] - [line 166 - classes/controller/Controller.php] - [size=3][0 Argument][/size]
  
• [b]ControllerCore->run[/b] - [line 340 - classes/Dispatcher.php] - [size=3][0 Argument][/size]
  
• [b]DispatcherCore->dispatch[/b] - [line 29 - index.php] - [size=3][0 Argument][/size]
  

[Dev On Web]

Strange that, I have not encountered this error on 1.5.0.9 ...

Have you made any changes to the original files? Which version you use, the beta 3,4? Or SVN?

[ezakimak]

Hi,

I am using the SVN version, downloaded again zip file from website and it works, must be something with the SVN version

Thanks

 

Strange that, I have not encountered this error on 1.5.0.9 ...

Have you made any changes to the original files? Which version you use, the beta 3,4? Or SVN?

Edited April 12, 2012 by ezakimak (see edit history)

[Dev On Web]

Ok, nice