Transient Bug after 1.6.2.31 Upgrade



  • Upon logging in after the upgrade having already flushed the caches, this error appeared:

    ×
    [ SQL ERROR ]
    
    Unknown column 'id_configuration' in 'field list'
                            SELECT CONCAT("
                                DELETE FROM `configuration_kpi` 
                                WHERE `name` = 'UPDATE_MODULES' 
                                AND `id_configuration` != ", MAX(`id_configuration`), "
                                AND `value` = '0'
                                 
                    AND (id_shop_group IS NULL OR id_shop_group = 0) 
                    AND (id_shop IS NULL OR id_shop = 0)
                                ") as stmt
                            FROM `configuration_kpi`
                            WHERE `name` = 'UPDATE_MODULES'
                             
                    AND (id_shop_group IS NULL OR id_shop_group = 0) 
                    AND (id_shop IS NULL OR id_shop = 0)
                            GROUP BY name
                            HAVING COUNT(*) > 1 LIMIT 1
    DbCore->displayError in /classes/db/Db.php:458
    DbCore->query in /classes/db/Db.php:719
    DbCore->getRow in /classes/db/Db.php:749
    DbCore->getValue in /classes/Configuration.php:642
    ConfigurationCore::updateValue in /classes/ConfigurationKPI.php:122
    ConfigurationKPICore::updateValue in /controllers/admin/AdminModulesController.php:2196
    AdminModulesControllerCore->initContent in /classes/controller/Controller.php:336
    ControllerCore->run in /classes/Dispatcher.php:427
    DispatcherCore->dispatch in /storeadmin/index.php:79
    

    There is no field called 'id_configuration' in 'configuration_kpi' but there is a field called 'id_configuration_kpi'. Is that what is wrong I wonder.



  • Yes if you have the debug mode activated.

    Replace the /classes/Configuration.php by the joined file.
    Configuration.php


Se connecter pour répondre