Cannot access 'stock management' and 'stock cover'

[Sacats]

Hello,

 

I activated the advanced stock management and I added my warehouse.

But when I want to go to the tab 'stock management' (and also stock cover) I get following error:

 

Unknown column 'cl.name' in 'where clause' SELECT SQL_CALC_FOUND_ROWS b.*, a.* , a.id_product as id, COUNT(pa.id_product_attribute) as variations FROM `ps_product` a LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 6) LEFT JOIN `ps_product_attribute` pa ON (pa.id_product = a.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 IN (1, 3)) WHERE 1 AND a.cache_is_pack = 0 AND a.is_virtual = 0 AND cl.`name` LIKE '%didymos%' GROUP BY a.id_product ORDER BY a.id_product ASC LIMIT 0,50

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

 

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

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

600. }

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

602. {

603. if ($sql)

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

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

606. }

607. }

608.

609. /**

• [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 2110 - classes/controller/AdminController.php] - [1 Arguments]
  
• [b]AdminControllerCore->getList[/b] - [line 866 - controllers/admin/AdminStockManagementController.php] - [6 Arguments]
  
• [b]AdminStockManagementControllerCore->getList[/b] - [line 1461 - classes/controller/AdminController.php] - [1 Arguments]
  
• [b]AdminControllerCore->renderList[/b] - [line 115 - controllers/admin/AdminStockManagementController.php] - [size=3][0 Argument][/size]
  
• [b]AdminStockManagementControllerCore->renderList[/b] - [line 1414 - classes/controller/AdminController.php] - [size=3][0 Argument][/size]
  
• [b]AdminControllerCore->initContent[/b] - [line 1080 - controllers/admin/AdminStockManagementController.php] - [size=3][0 Argument][/size]
  
• [b]AdminStockManagementControllerCore->initContent[/b] - [line 167 - classes/controller/Controller.php] - [size=3][0 Argument][/size]
  
• [b]ControllerCore->run[/b] - [line 348 - classes/Dispatcher.php] - [size=3][0 Argument][/size]
  
• [b]DispatcherCore->dispatch[/b] - [line 50 - admini/index.php] - [size=3][0 Argument][/size]
  

 

I don't know what to do, so all help is welcome.

I have 1.5.3.1 and a multistore with 2 shops. I want to activate the advanced stock management because there will be some products the same in both shops and if it is sold in one shop, then it should be sold in the other as well.

 

Thanks

[Sacats]

DH took a look at the error and he says it is probably a bug because the cl name is not defined.

 

Is it? And if so, must I report it somewhere?

[Sacats]

Up

 

Desperately looking for a solution....

 

Anyone?

[Sacats]

Bump, still looking for a solution/hint/anything...