Error with Categories and monitoring product since upgrade in 1.6.1

[mams13]

Hello Community prestashop,

 

Since I upgraded my prestashop 1.6.0.14 to 1.6.1 I got a lot of errors in backoffice. some are resolved but I can't find solution for theses:

 

1. When I'm going on product page and I try to change category association I have just a point under the category parent

same problem if I can to add a new category under an other. but when I go into front office all is ok.

I'm try to refresh cache but not change. (screenshot)

 

 

 

2. In monitoring products I have this message: 

• Mauvaise requête SQL
  Unknown column 'sa.active' in 'where clause'

 

I activated the mod dev here the message:

 

[PrestaShopDatabaseException]

Unknown column 'sa.active' in 'where clause'
 

SELECT SQL_CALC_FOUND_ROWS
                                b.*, a.*
            
            FROM `ps_product` a
            LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1)
             INNER JOIN ps_product_shop product_shop
        ON (product_shop.id_product = a.id_product AND product_shop.id_shop = 1)
             WHERE 1 AND EXISTS (
            SELECT 1
            FROM `ps_product` p
             LEFT JOIN ps_stock_available stock
            ON (stock.id_product = p.id_product AND stock.id_shop = 1 AND stock.id_shop_group = 0 )
            WHERE a.id_product = p.id_product AND NOT EXISTS (
                SELECT 1
                FROM `ps_product_attribute` pa WHERE pa.id_product = p.id_product
            )
            AND IFNULL(stock.quantity, 0) <= 0
        ) AND sa.`active` = 1
            
             ORDER BY a.`id_product` DESC LIMIT 0, 50
at line 765 in file classes/db/Db.php

 

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

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
761.         }
762.         elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
763.         {
764.             if ($sql)
765.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
766.
767.             throw new PrestaShopDatabaseException($this->getMsgError());
768.         }
769.     }
770.

• DbCore->displayError - [line 418 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 620 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 3190 - classes/controller/AdminController.php] - [3 Arguments]
• AdminControllerCore->getList - [line 335 - controllers/admin/AdminTrackingController.php] - [6 Arguments]
• AdminTrackingControllerCore->getList - [line 249 - controllers/admin/AdminTrackingController.php] - [1 Arguments]
• AdminTrackingControllerCore->renderList - [line 209 - controllers/admin/AdminTrackingController.php]
• AdminTrackingControllerCore->getCustomListProductsNoStock - [line - ]
• call_user_func - [line 78 - controllers/admin/AdminTrackingController.php] - [1 Arguments]

------------------------------------------------------------------------------------

 

Anyone have got the problem or can solved this? 

 

All help will be welcome.

Edited August 7, 2015 by mams13 (see edit history)

[heidardg]

I have the same problem.

[musicmaster]

Please try replacing "sa.`active` = 1" with "product_shop.`active` = 1".

 

Mind reading is hard, but this seems to me what the PS crew most likely meant.

 

And write a Forge ticket... Or maybe it is already there - with a solution.

[Serial]

Hi,

 

I have the same problem but I don't find the file to correct ?

[musicmaster]

Look at the function call stack that is below the query in the first post.

 

The third line there is 

• DbCore->executeS - [line 3190 - classes/controller/AdminController.php] - [3 Arguments]

So that is likely the file and the line number that you need to change.