Backoffice - Products Page Not Showing

[hobbychan]

Hello,

 

I was installing some models at my store, when suddenly I went to (Categories > Products) and I got this error:

• Bad SQL query
  Unknown column 'invetrina' in 'order clause'

 

I have turned on the bug report thing and I got this message from the system: 

store link: http://store.hobbychan.com

 

[PrestaShopDatabaseException]

Unknown column 'invetrina' in 'order clause'
 

            SELECT SQL_CALC_FOUND_ROWS
            a.`id_product`,b.name as name,`reference`,a.price as price,sa.active as active
            , shop.name as shopname, a.id_shop_default, MAX(image_shop.id_image) id_image, cl.name `name_category`, sa.`price`, 0 AS price_final, a.`is_virtual`, pd.`nb_downloadable`, sav.`quantity` as sav_quantity, sa.`active`, IF(sav.`quantity`<=0, 1, 0) badge_danger
            FROM `rbh_product` a
            LEFT JOIN `rbh_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1)
            
        LEFT JOIN `rbh_image` i ON (i.`id_product` = a.`id_product`)
        LEFT JOIN `rbh_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0
         AND sav.id_shop = 1 AND sav.id_shop_group = 0 ) JOIN `rbh_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default)
                LEFT JOIN `rbh_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default)
                LEFT JOIN `rbh_shop` shop ON (shop.id_shop = a.id_shop_default)
                LEFT JOIN `rbh_image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = a.id_shop_default)
                LEFT JOIN `rbh_product_download` pd ON (pd.`id_product` = a.`id_product`)
            
            WHERE 1
            GROUP BY sa.id_product
            
            ORDER BY `invetrina` desc LIMIT 0,50
at line 646 in file classes/db/Db.php

 

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

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
642.         }
643.         elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
644.         {
645.             if ($sql)
646.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
647.             throw new PrestaShopDatabaseException($this->getMsgError());
648.         }
649.     }
650.
651.     /**

• DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 516 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 2943 - classes/controller/AdminController.php] - [3 Arguments]
• AdminControllerCore->getList - [line 363 - controllers/admin/AdminProductsController.php] - [6 Arguments]
• AdminProductsControllerCore->getList - [line 2088 - classes/controller/AdminController.php] - [1 Arguments]
• AdminControllerCore->renderList - [line 2467 - controllers/admin/AdminProductsController.php]
• AdminProductsControllerCore->renderList - [line 1848 - classes/controller/AdminController.php]
• AdminControllerCore->initContent - [line 2390 - controllers/admin/AdminProductsController.php]
• AdminProductsControllerCore->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

[hobbychan]

I have uninstalled all the models I were installing, no success. 

 

>.< 

[tuk66]

The invetrina field was (or should be) added to your database. I would vote that the AdminProductsController.php file was patched.