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:79There 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