Prestashop database exception

[giovanniciquera]

Salve ho questo errore su prestashop una volta che entro nella home del front end:

Unknown column '' in 'order clause'

 

SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,

                    pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
                    pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
                    m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer,
                    MAX(image_shop.`id_image`) id_image, il.`legend`,
                    ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`,
                    DATEDIFF(p.`date_add`, DATE_SUB(NOW(),
                    INTERVAL 299999 DAY)) > 0 AS new, MAX(product_attribute_shop.minimal_quantity) AS product_attribute_minimal_quantity FROM `ps_product_sale` ps
                LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product`
                 LEFT 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 (p.`id_product` = pa.`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 = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 )
                LEFT JOIN `ps_product_lang` pl
                    ON p.`id_product` = pl.`id_product`
                    AND pl.`id_lang` = 2 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` = 2)
                LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
                LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`)
                    AND tr.`id_country` = 10
                    AND tr.`id_state` = 0
                LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)
                    JOIN `ps_category_product` cp ON (cp.`id_product` = p.`id_product`)
                    JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1)
                WHERE product_shop.`active` = 1
                    AND p.`visibility` != 'none'
                GROUP BY product_shop.id_product
                    ORDER BY `` DESC
                    LIMIT 0, 24
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 123 - classes/ProductSale.php] - [1 Arguments]
• ProductSaleCore::getBestSales - [line 425 - modules/ptsblockproducttabs/ptsblockproducttabs.php] - [3 Arguments]
• PtsBlockProductTabs->hookRightColumn - [line 368 - modules/ptsblockproducttabs/ptsblockproducttabs.php] - [1 Arguments]
• PtsBlockProductTabs->hookDisplayHome - [line 510 - classes/Hook.php] - [1 Arguments]
• HookCore::exec - [line 40 - controllers/front/IndexController.php] - [1 Arguments]
• IndexControllerCore->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

 

Possibile causa? Soluzione?

Grazie