Column not found: 1054 Unknown column 'df_type' in 'field list' (повтор, пользоваться поиском не считаю нужным)

[10 ноября 2016 г.]    Российская сборка Magento 2.49.12
Magento 2: модули и услуги
#1 Алексей Лазарев
  • Группа: Пользователь
  • Сообщений: 143
  • Регистрация: 19.11.2011

29.10.2012 18:27

Добрый день, сегодня обновил российскую сборку до последней версии, и при попытке зайти на сайт (www.bonmix.ru) по основному адресу получил следующее

Zend_Db_Statement_Exception Object
(
    [_previous:Zend_Exception:private] => 
    [message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'df_type' in 'field list'
    [string:Exception:private] => 
    [code:protected] => 42
    [file:protected] => /var/www/bonmix.ru/lib/Zend/Db/Statement/Pdo.php
    [line:protected] => 234
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /var/www/bonmix.ru/lib/Varien/Db/Statement/Pdo/Mysql.php
                    [line] => 110
                    [function] => _execute
                    [class] => Zend_Db_Statement_Pdo
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [0] => UA
                                    [1] => UA-43
                                    [2] => Крым Автономная Республика
                                    [3] => 0
                                    [4] => Сімферополь
                                )

                        )

                )

            [1] => Array
                (
                    [file] => /var/www/bonmix.ru/lib/Zend/Db/Statement.php
                    [line] => 300
                    [function] => _execute
                    [class] => Varien_Db_Statement_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [0] => UA
                                    [1] => UA-43
                                    [2] => Крым Автономная Республика
                                    [3] => 0
                                    [4] => Сімферополь
                                )

                        )

                )

            [2] => Array
                (
                    [file] => /var/www/bonmix.ru/lib/Zend/Db/Adapter/Abstract.php
                    [line] => 479
                    [function] => execute
                    [class] => Zend_Db_Statement
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [0] => UA
                                    [1] => UA-43
                                    [2] => Крым Автономная Республика
                                    [3] => 0
                                    [4] => Сімферополь
                                )

                        )

                )

            [3] => Array
                (
                    [file] => /var/www/bonmix.ru/lib/Zend/Db/Adapter/Pdo/Abstract.php
                    [line] => 238
                    [function] => query
                    [class] => Zend_Db_Adapter_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`, `df_type`, `df_capital`) VALUES (?, ?, ?, ?, ?)
                            [1] => Array
                                (
                                    [0] => UA
                                    [1] => UA-43
                                    [2] => Крым Автономная Республика
                                    [3] => 0
                                    [4] => Сімферополь
                                )

                        )

                )

            [4] => Array
                (
                    [file] => /var/www/bonmix.ru/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 389
                    [function] => query
                    [class] => Zend_Db_Adapter_Pdo_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`, `df_type`, `df_capital`) VALUES (?, ?, ?, ?, ?)
                            [1] => Array
                                (
                                    [0] => UA
                                    [1] => UA-43
                                    [2] => Крым Автономная Республика
                                    [3] => 0
                                    [4] => Сімферополь
                                )

                        )

                )

            [5] => Array
                (
                    [file] => /var/www/bonmix.ru/lib/Zend/Db/Adapter/Abstract.php
                    [line] => 574
                    [function] => query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`, `df_type`, `df_capital`) VALUES (?, ?, ?, ?, ?)
                            [1] => Array
                                (
                                    [0] => UA
                                    [1] => UA-43
                                    [2] => Крым Автономная Республика
                                    [3] => 0
                                    [4] => Сімферополь
                                )

                        )

                )

            [6] => Array
                (
                    [file] => /var/www/bonmix.ru/app/code/local/Df/Directory/Model/Setup/Processor/InstallRegions.php
                    [line] => 165
                    [function] => insert
                    [class] => Zend_Db_Adapter_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => directory_country_region
                            [1] => Array
                                (
                                    [country_id] => UA
                                    [code] => UA-43
                                    [default_name] => Крым Автономная Республика
                                    [df_type] => 0
                                    [df_capital] => Сімферополь
                                )

                        )

                )

            [7] => Array
                (
                    [file] => /var/www/bonmix.ru/app/code/local/Df/Directory/Model/Setup/Processor/InstallRegions.php
                    [line] => 202
                    [function] => regionInsert
                    [class] => Df_Directory_Model_Setup_Processor_InstallRegions
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [name_russian] => Крым Автономная Республика
                                    [name_local] => Крим Автономна республіка
                                    [center_russian] => Симферополь
                                    [center_local] => Сімферополь
                                    [code] => UA-43
                                    [type] => 0
                                )

                        )

                )

            [8] => Array
                (
                    [file] => /var/www/bonmix.ru/app/code/local/Df/Directory/Model/Setup/Processor/InstallRegions.php
                    [line] => 36
                    [function] => regionsInsert
                    [class] => Df_Directory_Model_Setup_Processor_InstallRegions
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [9] => Array
                (
                    [file] => /var/www/bonmix.ru/app/code/local/Df/Directory/Model/Resource/Setup.php
                    [line] => 211
                    [function] => process
                    [class] => Df_Directory_Model_Setup_Processor_InstallRegions
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [10] => Array
                (
                    [file] => /var/www/bonmix.ru/app/code/local/Df/Directory/sql/df_directory_setup/mysql4-upgrade-2.0.1-2.2.0.php
                    [line] => 24
                    [function] => upgrade_2_2_0
                    [class] => Df_Directory_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [11] => Array
                (
                    [file] => /var/www/bonmix.ru/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 624
                    [args] => Array
                        (
                            [0] => /var/www/bonmix.ru/app/code/local/Df/Directory/sql/df_directory_setup/mysql4-upgrade-2.0.1-2.2.0.php
                        )

                    [function] => include
                )

            [12] => Array
                (
                    [file] => /var/www/bonmix.ru/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 437
                    [function] => _modifyResourceDb
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => upgrade
                            [1] => 2.0.1
                            [2] => 2.3.0
                        )

                )

            [13] => Array
                (
                    [file] => /var/www/bonmix.ru/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 320
                    [function] => _upgradeResourceDb
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 2.0.1
                            [1] => 2.3.0
                        )

                )

            [14] => Array
                (
                    [file] => /var/www/bonmix.ru/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 235
                    [function] => applyUpdates
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [15] => Array
                (
                    [file] => /var/www/bonmix.ru/app/code/core/Mage/Core/Model/App.php
                    [line] => 412
                    [function] => applyAllUpdates
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ::
                    [args] => Array
                        (
                        )

                )

            [16] => Array
                (
                    [file] => /var/www/bonmix.ru/app/code/core/Mage/Core/Model/App.php
                    [line] => 338
                    [function] => _initModules
                    [class] => Mage_Core_Model_App
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [17] => Array
                (
                    [file] => /var/www/bonmix.ru/app/Mage.php
                    [line] => 640
                    [function] => run
                    [class] => Mage_Core_Model_App
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [scope_code] => 
                                    [scope_type] => store
                                    [options] => Array
                                        (
                                        )

                                )

                        )

                )

            [18] => Array
                (
                    [file] => /var/www/bonmix.ru/index.php
                    [line] => 80
                    [function] => run
                    [class] => Mage
                    [type] => ::
                    [args] => Array
                        (
                            [0] => 
                            [1] => store
                        )

                )

        )

    [previous:Exception:private] => PDOException Object
        (
            [message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'df_type' in 'field list'
            [string:Exception:private] => 
            [code:protected] => 42S22
            [file:protected] => /var/www/bonmix.ru/lib/Zend/Db/Statement/Pdo.php
            [line:protected] => 228
            [trace:Exception:private] => Array
                (
                    [0] => Array
                        (
                            [file] => /var/www/bonmix.ru/lib/Zend/Db/Statement/Pdo.php
                            [line] => 228
                            [function] => execute
                            [class] => PDOStatement
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                            [0] => UA
                                            [1] => UA-43
                                            [2] => Крым Автономная Республика
                                            [3] => 0
                                            [4] => Сімферополь
                                        )

                                )

                        )

                    [1] => Array
                        (
                            [file] => /var/www/bonmix.ru/lib/Varien/Db/Statement/Pdo/Mysql.php
                            [line] => 110
                            [function] => _execute
                            [class] => Zend_Db_Statement_Pdo
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                            [0] => UA
                                            [1] => UA-43
                                            [2] => Крым Автономная Республика
                                            [3] => 0
                                            [4] => Сімферополь
                                        )

                                )

                        )

                    [2] => Array
                        (
                            [file] => /var/www/bonmix.ru/lib/Zend/Db/Statement.php
                            [line] => 300
                            [function] => _execute
                            [class] => Varien_Db_Statement_Pdo_Mysql
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                            [0] => UA
                                            [1] => UA-43
                                            [2] => Крым Автономная Республика
                                            [3] => 0
                                            [4] => Сімферополь
                                        )

                                )

                        )

                    [3] => Array
                        (
                            [file] => /var/www/bonmix.ru/lib/Zend/Db/Adapter/Abstract.php
                            [line] => 479
                            [function] => execute
                            [class] => Zend_Db_Statement
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                            [0] => UA
                                            [1] => UA-43
                                            [2] => Крым Автономная Республика
                                            [3] => 0
                                            [4] => Сімферополь
                                        )

                                )

                        )

                    [4] => Array
                        (
                            [file] => /var/www/bonmix.ru/lib/Zend/Db/Adapter/Pdo/Abstract.php
                            [line] => 238
                            [function] => query
                            [class] => Zend_Db_Adapter_Abstract
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`, `df_type`, `df_capital`) VALUES (?, ?, ?, ?, ?)
                                    [1] => Array
                                        (
                                            [0] => UA
                                            [1] => UA-43
                                            [2] => Крым Автономная Республика
                                            [3] => 0
                                            [4] => Сімферополь
                                        )

                                )

                        )

                    [5] => Array
                        (
                            [file] => /var/www/bonmix.ru/lib/Varien/Db/Adapter/Pdo/Mysql.php
                            [line] => 389
                            [function] => query
                            [class] => Zend_Db_Adapter_Pdo_Abstract
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`, `df_type`, `df_capital`) VALUES (?, ?, ?, ?, ?)
                                    [1] => Array
                                        (
                                            [0] => UA
                                            [1] => UA-43
                                            [2] => Крым Автономная Республика
                                            [3] => 0
                                            [4] => Сімферополь
                                        )

                                )

                        )

                    [6] => Array
                        (
                            [file] => /var/www/bonmix.ru/lib/Zend/Db/Adapter/Abstract.php
                            [line] => 574
                            [function] => query
                            [class] => Varien_Db_Adapter_Pdo_Mysql
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`, `df_type`, `df_capital`) VALUES (?, ?, ?, ?, ?)
                                    [1] => Array
                                        (
                                            [0] => UA
                                            [1] => UA-43
                                            [2] => Крым Автономная Республика
                                            [3] => 0
                                            [4] => Сімферополь
                                        )

                                )

                        )

                    [7] => Array
                        (
                            [file] => /var/www/bonmix.ru/app/code/local/Df/Directory/Model/Setup/Processor/InstallRegions.php
                            [line] => 165
                            [function] => insert
                            [class] => Zend_Db_Adapter_Abstract
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => directory_country_region
                                    [1] => Array
                                        (
                                            [country_id] => UA
                                            [code] => UA-43
                                            [default_name] => Крым Автономная Республика
                                            [df_type] => 0
                                            [df_capital] => Сімферополь
                                        )

                                )

                        )

                    [8] => Array
                        (
                            [file] => /var/www/bonmix.ru/app/code/local/Df/Directory/Model/Setup/Processor/InstallRegions.php
                            [line] => 202
                            [function] => regionInsert
                            [class] => Df_Directory_Model_Setup_Processor_InstallRegions
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                            [name_russian] => Крым Автономная Республика
                                            [name_local] => Крим Автономна республіка
                                            [center_russian] => Симферополь
                                            [center_local] => Сімферополь
                                            [code] => UA-43
                                            [type] => 0
                                        )

                                )

                        )

                    [9] => Array
                        (
                            [file] => /var/www/bonmix.ru/app/code/local/Df/Directory/Model/Setup/Processor/InstallRegions.php
                            [line] => 36
                            [function] => regionsInsert
                            [class] => Df_Directory_Model_Setup_Processor_InstallRegions
                            [type] => ->
                            [args] => Array
                                (
                                )

                        )

                    [10] => Array
                        (
                            [file] => /var/www/bonmix.ru/app/code/local/Df/Directory/Model/Resource/Setup.php
                            [line] => 211
                            [function] => process
                            [class] => Df_Directory_Model_Setup_Processor_InstallRegions
                            [type] => ->
                            [args] => Array
                                (
                                )

                        )

                    [11] => Array
                        (
                            [file] => /var/www/bonmix.ru/app/code/local/Df/Directory/sql/df_directory_setup/mysql4-upgrade-2.0.1-2.2.0.php
                            [line] => 24
                            [function] => upgrade_2_2_0
                            [class] => Df_Directory_Model_Resource_Setup
                            [type] => ->
                            [args] => Array
                                (
                                )

                        )

                    [12] => Array
                        (
                            [file] => /var/www/bonmix.ru/app/code/core/Mage/Core/Model/Resource/Setup.php
                            [line] => 624
                            [args] => Array
                                (
                                    [0] => /var/www/bonmix.ru/app/code/local/Df/Directory/sql/df_directory_setup/mysql4-upgrade-2.0.1-2.2.0.php
                                )

                            [function] => include
                        )

                    [13] => Array
                        (
                            [file] => /var/www/bonmix.ru/app/code/core/Mage/Core/Model/Resource/Setup.php
                            [line] => 437
                            [function] => _modifyResourceDb
                            [class] => Mage_Core_Model_Resource_Setup
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => upgrade
                                    [1] => 2.0.1
                                    [2] => 2.3.0
                                )

                        )

                    [14] => Array
                        (
                            [file] => /var/www/bonmix.ru/app/code/core/Mage/Core/Model/Resource/Setup.php
                            [line] => 320
                            [function] => _upgradeResourceDb
                            [class] => Mage_Core_Model_Resource_Setup
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => 2.0.1
                                    [1] => 2.3.0
                                )

                        )

                    [15] => Array
                        (
                            [file] => /var/www/bonmix.ru/app/code/core/Mage/Core/Model/Resource/Setup.php
                            [line] => 235
                            [function] => applyUpdates
                            [class] => Mage_Core_Model_Resource_Setup
                            [type] => ->
                            [args] => Array
                                (
                                )

                        )

                    [16] => Array
                        (
                            [file] => /var/www/bonmix.ru/app/code/core/Mage/Core/Model/App.php
                            [line] => 412
                            [function] => applyAllUpdates
                            [class] => Mage_Core_Model_Resource_Setup
                            [type] => ::
                            [args] => Array
                                (
                                )

                        )

                    [17] => Array
                        (
                            [file] => /var/www/bonmix.ru/app/code/core/Mage/Core/Model/App.php
                            [line] => 338
                            [function] => _initModules
                            [class] => Mage_Core_Model_App
                            [type] => ->
                            [args] => Array
                                (
                                )

                        )

                    [18] => Array
                        (
                            [file] => /var/www/bonmix.ru/app/Mage.php
                            [line] => 640
                            [function] => run
                            [class] => Mage_Core_Model_App
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                            [scope_code] => 
                                            [scope_type] => store
                                            [options] => Array
                                                (
                                                )

                                        )

                                )

                        )

                    [19] => Array
                        (
                            [file] => /var/www/bonmix.ru/index.php
                            [line] => 80
                            [function] => run
                            [class] => Mage
                            [type] => ::
                            [args] => Array
                                (
                                    [0] => 
                                    [1] => store
                                )

                        )

                )

            [previous:Exception:private] => 
            [errorInfo] => Array
                (
                    [0] => 42S22
                    [1] => 1054
                    [2] => Unknown column 'df_type' in 'field list'
                )

        )

)
Error in file: "/var/www/bonmix.ru/app/code/local/Df/Directory/sql/df_directory_setup/mysql4-upgrade-2.0.1-2.2.0.php" - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'df_type' in 'field list'

#0 /var/www/bonmix.ru/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /var/www/bonmix.ru/app/code/core/Mage/Core/Model/Resource/Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '2.0.1', '2.3.0')
#2 /var/www/bonmix.ru/app/code/core/Mage/Core/Model/Resource/Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('2.0.1', '2.3.0')
#3 /var/www/bonmix.ru/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /var/www/bonmix.ru/app/code/core/Mage/Core/Model/App.php(412): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /var/www/bonmix.ru/app/code/core/Mage/Core/Model/App.php(338): Mage_Core_Model_App->_initModules()
#6 /var/www/bonmix.ru/app/Mage.php(640): Mage_Core_Model_App->run(Array)
#7 /var/www/bonmix.ru/index.php(80): Mage::run('', 'store')
#8 {main}


Что делать?!

#2 Алексей Лазарев
  • Группа: Пользователь
  • Сообщений: 143
  • Регистрация: 19.11.2011

29.10.2012 18:42

Появилась эта ошибка после попытки обновить кэш. После перезагрузки сервера сайт работает, но как только пытаюсь снова обновить кэш - вижу снова эту ошибку.

Обновление ру сборки производил по инструкции.

Поделиться темой: