Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error happenes when installation #30

Closed
SunshineTech opened this issue Jun 27, 2012 · 2 comments
Closed

Error happenes when installation #30

SunshineTech opened this issue Jun 27, 2012 · 2 comments

Comments

@SunshineTech
Copy link

First I create database in mysql, then I import the data of magento_sample_data_for_1.6.1.0.sql. When I install the magento2, there are a lot same errores. In page, the following error:

Zend_Db_Statement_Exception Object
(
[_previous:Zend_Exception:private] =>
[message:protected] => SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento2.customer/eav_attribute' doesn't exist
[string:Exception:private] =>
[code:protected] => 42
[file:protected] => D:\xampp\htdocs\magento2\lib\Zend\Db\Statement\Pdo.php
[line:protected] => 234
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => D:\xampp\htdocs\magento2\lib\Varien\Db\Statement\Pdo\Mysql.php
[line] => 110
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
[:id] => disable_auto_group_change
[:entity_type_id] => 1
)

                    )

            )

        [1] => Array
            (
                [file] => D:\xampp\htdocs\magento2\lib\Zend\Db\Statement.php
                [line] => 300
                [function] => _execute
                [class] => Varien_Db_Statement_Pdo_Mysql
                [type] => ->
                [args] => Array
                    (
                        [0] => Array
                            (
                                [:id] => disable_auto_group_change
                                [:entity_type_id] => 1
                            )

                    )

            )

        [2] => Array
            (
                [file] => D:\xampp\htdocs\magento2\lib\Zend\Db\Adapter\Abstract.php
                [line] => 479
                [function] => execute
                [class] => Zend_Db_Statement
                [type] => ->
                [args] => Array
                    (
                        [0] => Array
                            (
                                [:id] => disable_auto_group_change
                                [:entity_type_id] => 1
                            )

                    )

            )

        [3] => Array
            (
                [file] => D:\xampp\htdocs\magento2\lib\Zend\Db\Adapter\Pdo\Abstract.php
                [line] => 238
                [function] => query
                [class] => Zend_Db_Adapter_Abstract
                [type] => ->
                [args] => Array
                    (
                        [0] => SELECT `main`.*, `additional`.* FROM `eav_attribute` AS `main`

INNER JOIN customer/eav_attribute AS additional ON main.attribute_id = additional.attribute_id WHERE (main.attribute_code = :id) AND (main.entity_type_id = :entity_type_id)
[1] => Array
(
[:id] => disable_auto_group_change
[:entity_type_id] => 1
)

                    )

            )

        [4] => Array
            (
                [file] => D:\xampp\htdocs\magento2\lib\Varien\Db\Adapter\Pdo\Mysql.php
                [line] => 422
                [function] => query
                [class] => Zend_Db_Adapter_Pdo_Abstract
                [type] => ->
                [args] => Array
                    (
                        [0] => SELECT `main`.*, `additional`.* FROM `eav_attribute` AS `main`

INNER JOIN customer/eav_attribute AS additional ON main.attribute_id = additional.attribute_id WHERE (main.attribute_code = :id) AND (main.entity_type_id = :entity_type_id)
[1] => Array
(
[:id] => disable_auto_group_change
[:entity_type_id] => 1
)

                    )

            )

        [5] => Array
            (
                [file] => D:\xampp\htdocs\magento2\lib\Zend\Db\Adapter\Abstract.php
                [line] => 753
                [function] => query
                [class] => Varien_Db_Adapter_Pdo_Mysql
                [type] => ->
                [args] => Array
                    (
                        [0] => Varien_Db_Select Object
                            (
                                [_bind:protected] => Array
                                    (
                                    )

                                [_adapter:protected] => Varien_Db_Adapter_Pdo_Mysql Object
                                    (
                                        [_defaultStmtClass:protected] => Varien_Db_Statement_Pdo_Mysql
                                        [_transactionLevel:protected] => 0
                                        [_connectionFlagsSet:protected] => 1
                                        [_ddlCache:protected] => Array
                                            (
                                            )

                                        [_bindParams:protected] => Array
                                            (
                                            )

                                        [_bindIncrement:protected] => 0
                                        [_debug:protected] => 
                                        [_logQueryTime:protected] => 0.05
                                        [_logAllQueries:protected] => 
                                        [_logCallStack:protected] => 
                                        [_debugFile:protected] => var/debug/pdo_mysql.log
                                        [_debugIoAdapter:protected] => 
                                        [_debugTimer:protected] => 0
                                        [_cacheAdapter:protected] => Varien_Cache_Core Object
                                            (
                                                [_backend:protected] => Zend_Cache_Backend_File Object
                                                    (
                                                        [_options:protected] => Array
                                                            (
                                                                [cache_dir] => D:\xampp\htdocs\magento2\var\cache\
                                                                [file_locking] => 1
                                                                [read_control] => 1
                                                                [read_control_type] => crc32
                                                                [hashed_directory_level] => 1
                                                                [hashed_directory_umask] => 511
                                                                [file_name_prefix] => mage
                                                                [cache_file_umask] => 384
                                                                [metadatas_array_max_size] => 100
                                                            )

                                                        [_metadatasArray:protected] => Array
                                                            (
                                                            )

                                                        [_directives:protected] => Array
                                                            (
                                                                [lifetime] => 7200
                                                                [logging] => 
                                                                [logger] => 
                                                            )

                                                    )

                                                [_options:protected] => Array
                                                    (
                                                        [write_control] => 1
                                                        [caching] => 1
                                                        [cache_id_prefix] => eb1_
                                                        [automatic_serialization] => 
                                                        [automatic_cleaning_factor] => 0
                                                        [lifetime] => 7200
                                                        [logging] => 
                                                        [logger] => 
                                                        [ignore_user_abort] => 
                                                    )

                                                [_specificOptions:protected] => Array
                                                    (
                                                    )

                                                [_lastId:Zend_Cache_Core:private] => 
                                                [_extendedBackend:protected] => 1
                                                [_backendCapabilities:protected] => Array
                                                    (
                                                        [automatic_cleaning] => 1
                                                        [tags] => 1
                                                        [expired_read] => 1
                                                        [priority] => 
                                                        [infinite_lifetime] => 1
                                                        [get_list] => 1
                                                    )

                                            )

                                        [_isDdlCacheAllowed:protected] => 
                                        [_ddlColumnTypes:protected] => Array
                                            (
                                                [boolean] => bool
                                                [smallint] => smallint
                                                [integer] => int
                                                [bigint] => bigint
                                                [float] => float
                                                [decimal] => decimal
                                                [numeric] => decimal
                                                [date] => date
                                                [timestamp] => timestamp
                                                [datetime] => datetime
                                                [text] => text
                                                [blob] => blob
                                                [varbinary] => blob
                                            )

                                        [_ddlRoutines:protected] => Array
                                            (
                                                [0] => alt
                                                [1] => cre
                                                [2] => ren
                                                [3] => dro
                                                [4] => tru
                                            )

                                        [_intervalUnits:protected] => Array
                                            (
                                                [YEARS] => YEAR
                                                [MONTHS] => MONTH
                                                [DAYS] => DAY
                                                [HOURS] => HOUR
                                                [MINUTES] => MINUTE
                                                [SECOND] => SECOND
                                            )

                                        [_queryHook:protected] => 
                                        [_pdoType:protected] => mysql
                                        [_numericDataTypes:protected] => Array
                                            (
                                                [0] => 0
                                                [1] => 1
                                                [2] => 2
                                                [INT] => 0
                                                [INTEGER] => 0
                                                [MEDIUMINT] => 0
                                                [SMALLINT] => 0
                                                [TINYINT] => 0
                                                [BIGINT] => 1
                                                [SERIAL] => 1
                                                [DEC] => 2
                                                [DECIMAL] => 2
                                                [DOUBLE] => 2
                                                [DOUBLE PRECISION] => 2
                                                [FIXED] => 2
                                                [FLOAT] => 2
                                            )

                                        [_config:protected] => Array
                                            (
                                                [host] => localhost
                                                [username] => magento2
                                                [password] => magento2
                                                [dbname] => magento2
                                                [initStatements] => SET NAMES utf8
                                                [model] => mysql4
                                                [type] => pdo_mysql
                                                [pdoType] => 
                                                [active] => 1
                                                [charset] => 
                                                [persistent] => 
                                                [options] => Array
                                                    (
                                                        [caseFolding] => 0
                                                        [autoQuoteIdentifiers] => 1
                                                        [fetchMode] => 2
                                                    )

                                                [driver_options] => Array
                                                    (
                                                    )

                                            )

                                        [_fetchMode:protected] => 2
                                        [_profiler:protected] => Zend_Db_Profiler Object
                                            (
                                                [_queryProfiles:protected] => Array
                                                    (
                                                    )

                                                [_enabled:protected] => 
                                                [_filterElapsedSecs:protected] => 
                                                [_filterTypes:protected] => 
                                            )

                                        [_defaultProfilerClass:protected] => Zend_Db_Profiler
                                        [_connection:protected] => PDO Object
                                            (
                                            )

                                        [_caseFolding:protected] => 0
                                        [_autoQuoteIdentifiers:protected] => 1
                                        [_allowSerialization:protected] => 1
                                        [_autoReconnectOnUnserialize:protected] => 
                                    )

                                [_parts:protected] => Array
                                    (
                                        [straightjoin] => 
                                        [distinct] => 
                                        [columns] => Array
                                            (
                                                [0] => Array
                                                    (
                                                        [0] => main
                                                        [1] => *
                                                        [2] => 
                                                    )

                                                [1] => Array
                                                    (
                                                        [0] => additional
                                                        [1] => *
                                                        [2] => 
                                                    )

                                            )

                                        [union] => Array
                                            (
                                            )

                                        [from] => Array
                                            (
                                                [main] => Array
                                                    (
                                                        [joinType] => from
                                                        [schema] => 
                                                        [tableName] => eav_attribute
                                                        [joinCondition] => 
                                                    )

                                                [additional] => Array
                                                    (
                                                        [joinType] => inner join
                                                        [schema] => 
                                                        [tableName] => customer/eav_attribute
                                                        [joinCondition] => main.attribute_id = additional.attribute_id
                                                    )

                                            )

                                        [where] => Array
                                            (
                                                [0] => (main.attribute_code = :id)
                                                [1] => AND (main.entity_type_id = :entity_type_id)
                                            )

                                        [group] => Array
                                            (
                                            )

                                        [having] => Array
                                            (
                                            )

                                        [order] => Array
                                            (
                                            )

                                        [limitcount] => 
                                        [limitoffset] => 
                                        [forupdate] => 
                                    )

                                [_tableCols:protected] => Array
                                    (
                                    )

                            )

                        [1] => Array
                            (
                                [id] => disable_auto_group_change
                                [entity_type_id] => 1
                            )

                    )

            )

        [6] => Array
            (
                [file] => D:\xampp\htdocs\magento2\app\code\core\Mage\Eav\Model\Entity\Setup.php
                [line] => 904
                [function] => fetchRow
                [class] => Zend_Db_Adapter_Abstract
                [type] => ->
                [args] => Array
                    (
                        [0] => Varien_Db_Select Object
                            (
                                [_bind:protected] => Array
                                    (
                                    )

                                [_adapter:protected] => Varien_Db_Adapter_Pdo_Mysql Object
                                    (
                                        [_defaultStmtClass:protected] => Varien_Db_Statement_Pdo_Mysql
                                        [_transactionLevel:protected] => 0
                                        [_connectionFlagsSet:protected] => 1
                                        [_ddlCache:protected] => Array
                                            (
                                            )

                                        [_bindParams:protected] => Array
                                            (
                                            )

                                        [_bindIncrement:protected] => 0
                                        [_debug:protected] => 
                                        [_logQueryTime:protected] => 0.05
                                        [_logAllQueries:protected] => 
                                        [_logCallStack:protected] => 
                                        [_debugFile:protected] => var/debug/pdo_mysql.log
                                        [_debugIoAdapter:protected] => 
                                        [_debugTimer:protected] => 0
                                        [_cacheAdapter:protected] => Varien_Cache_Core Object
                                            (
                                                [_backend:protected] => Zend_Cache_Backend_File Object
                                                    (
                                                        [_options:protected] => Array
                                                            (
                                                                [cache_dir] => D:\xampp\htdocs\magento2\var\cache\
                                                                [file_locking] => 1
                                                                [read_control] => 1
                                                                [read_control_type] => crc32
                                                                [hashed_directory_level] => 1
                                                                [hashed_directory_umask] => 511
                                                                [file_name_prefix] => mage
                                                                [cache_file_umask] => 384
                                                                [metadatas_array_max_size] => 100
                                                            )

                                                        [_metadatasArray:protected] => Array
                                                            (
                                                            )

                                                        [_directives:protected] => Array
                                                            (
                                                                [lifetime] => 7200
                                                                [logging] => 
                                                                [logger] => 
                                                            )

                                                    )

                                                [_options:protected] => Array
                                                    (
                                                        [write_control] => 1
                                                        [caching] => 1
                                                        [cache_id_prefix] => eb1_
                                                        [automatic_serialization] => 
                                                        [automatic_cleaning_factor] => 0
                                                        [lifetime] => 7200
                                                        [logging] => 
                                                        [logger] => 
                                                        [ignore_user_abort] => 
                                                    )

                                                [_specificOptions:protected] => Array
                                                    (
                                                    )

                                                [_lastId:Zend_Cache_Core:private] => 
                                                [_extendedBackend:protected] => 1
                                                [_backendCapabilities:protected] => Array
                                                    (
                                                        [automatic_cleaning] => 1
                                                        [tags] => 1
                                                        [expired_read] => 1
                                                        [priority] => 
                                                        [infinite_lifetime] => 1
                                                        [get_list] => 1
                                                    )

                                            )

                                        [_isDdlCacheAllowed:protected] => 
                                        [_ddlColumnTypes:protected] => Array
                                            (
                                                [boolean] => bool
                                                [smallint] => smallint
                                                [integer] => int
                                                [bigint] => bigint
                                                [float] => float
                                                [decimal] => decimal
                                                [numeric] => decimal
                                                [date] => date
                                                [timestamp] => timestamp
                                                [datetime] => datetime
                                                [text] => text
                                                [blob] => blob
                                                [varbinary] => blob
                                            )

                                        [_ddlRoutines:protected] => Array
                                            (
                                                [0] => alt
                                                [1] => cre
                                                [2] => ren
                                                [3] => dro
                                                [4] => tru
                                            )

                                        [_intervalUnits:protected] => Array
                                            (
                                                [YEARS] => YEAR
                                                [MONTHS] => MONTH
                                                [DAYS] => DAY
                                                [HOURS] => HOUR
                                                [MINUTES] => MINUTE
                                                [SECOND] => SECOND
                                            )

                                        [_queryHook:protected] => 
                                        [_pdoType:protected] => mysql
                                        [_numericDataTypes:protected] => Array
                                            (
                                                [0] => 0
                                                [1] => 1
                                                [2] => 2
                                                [INT] => 0
                                                [INTEGER] => 0
                                                [MEDIUMINT] => 0
                                                [SMALLINT] => 0
                                                [TINYINT] => 0
                                                [BIGINT] => 1
                                                [SERIAL] => 1
                                                [DEC] => 2
                                                [DECIMAL] => 2
                                                [DOUBLE] => 2
                                                [DOUBLE PRECISION] => 2
                                                [FIXED] => 2
                                                [FLOAT] => 2
                                            )

                                        [_config:protected] => Array
                                            (
                                                [host] => localhost
                                                [username] => magento2
                                                [password] => magento2
                                                [dbname] => magento2
                                                [initStatements] => SET NAMES utf8
                                                [model] => mysql4
                                                [type] => pdo_mysql
                                                [pdoType] => 
                                                [active] => 1
                                                [charset] => 
                                                [persistent] => 
                                                [options] => Array
                                                    (
                                                        [caseFolding] => 0
                                                        [autoQuoteIdentifiers] => 1
                                                        [fetchMode] => 2
                                                    )

                                                [driver_options] => Array
                                                    (
                                                    )

                                            )

                                        [_fetchMode:protected] => 2
                                        [_profiler:protected] => Zend_Db_Profiler Object
                                            (
                                                [_queryProfiles:protected] => Array
                                                    (
                                                    )

                                                [_enabled:protected] => 
                                                [_filterElapsedSecs:protected] => 
                                                [_filterTypes:protected] => 
                                            )

                                        [_defaultProfilerClass:protected] => Zend_Db_Profiler
                                        [_connection:protected] => PDO Object
                                            (
                                            )

                                        [_caseFolding:protected] => 0
                                        [_autoQuoteIdentifiers:protected] => 1
                                        [_allowSerialization:protected] => 1
                                        [_autoReconnectOnUnserialize:protected] => 
                                    )

                                [_parts:protected] => Array
                                    (
                                        [straightjoin] => 
                                        [distinct] => 
                                        [columns] => Array
                                            (
                                                [0] => Array
                                                    (
                                                        [0] => main
                                                        [1] => *
                                                        [2] => 
                                                    )

                                                [1] => Array
                                                    (
                                                        [0] => additional
                                                        [1] => *
                                                        [2] => 
                                                    )

                                            )

                                        [union] => Array
                                            (
                                            )

                                        [from] => Array
                                            (
                                                [main] => Array
                                                    (
                                                        [joinType] => from
                                                        [schema] => 
                                                        [tableName] => eav_attribute
                                                        [joinCondition] => 
                                                    )

                                                [additional] => Array
                                                    (
                                                        [joinType] => inner join
                                                        [schema] => 
                                                        [tableName] => customer/eav_attribute
                                                        [joinCondition] => main.attribute_id = additional.attribute_id
                                                    )

                                            )

                                        [where] => Array
                                            (
                                                [0] => (main.attribute_code = :id)
                                                [1] => AND (main.entity_type_id = :entity_type_id)
                                            )

                                        [group] => Array
                                            (
                                            )

                                        [having] => Array
                                            (
                                            )

                                        [order] => Array
                                            (
                                            )

                                        [limitcount] => 
                                        [limitoffset] => 
                                        [forupdate] => 
                                    )

                                [_tableCols:protected] => Array
                                    (
                                    )

                            )

                        [1] => Array
                            (
                                [id] => disable_auto_group_change
                                [entity_type_id] => 1
                            )

                    )

            )

        [7] => Array
            (
                [file] => D:\xampp\htdocs\magento2\app\code\core\Mage\Eav\Model\Entity\Setup.php
                [line] => 662
                [function] => getAttribute
                [class] => Mage_Eav_Model_Entity_Setup
                [type] => ->
                [args] => Array
                    (
                        [0] => 1
                        [1] => disable_auto_group_change
                        [2] => attribute_id
                    )

            )

        [8] => Array
            (
                [file] => D:\xampp\htdocs\magento2\app\code\core\Mage\Customer\sql\customer_setup\upgrade-1.6.1.0-1.6.2.0.php
                [line] => 39
                [function] => addAttribute
                [class] => Mage_Eav_Model_Entity_Setup
                [type] => ->
                [args] => Array
                    (
                        [0] => customer
                        [1] => disable_auto_group_change
                        [2] => Array
                            (
                                [type] => static
                                [label] => Disable Automatic Group Change Based on VAT ID
                                [input] => boolean
                                [backend] => Mage_Customer_Model_Attribute_Backend_Data_Boolean
                                [position] => 28
                                [required] => 
                            )

                    )

            )

        [9] => Array
            (
                [file] => D:\xampp\htdocs\magento2\app\code\core\Mage\Core\Model\Resource\Setup.php
                [line] => 625
                [args] => Array
                    (
                        [0] => D:\xampp\htdocs\magento2\app\code\core\Mage\Customer\sql\customer_setup\upgrade-1.6.1.0-1.6.2.0.php
                    )

                [function] => include
            )

        [10] => Array
            (
                [file] => D:\xampp\htdocs\magento2\app\code\core\Mage\Core\Model\Resource\Setup.php
                [line] => 438
                [function] => _modifyResourceDb
                [class] => Mage_Core_Model_Resource_Setup
                [type] => ->
                [args] => Array
                    (
                        [0] => upgrade
                        [1] => 1.6.1.0
                        [2] => 1.6.2.0.1
                    )

            )

        [11] => Array
            (
                [file] => D:\xampp\htdocs\magento2\app\code\core\Mage\Core\Model\Resource\Setup.php
                [line] => 321
                [function] => _upgradeResourceDb
                [class] => Mage_Core_Model_Resource_Setup
                [type] => ->
                [args] => Array
                    (
                        [0] => 1.6.1.0
                        [1] => 1.6.2.0.1
                    )

            )

        [12] => Array
            (
                [file] => D:\xampp\htdocs\magento2\app\code\core\Mage\Core\Model\Resource\Setup.php
                [line] => 235
                [function] => applyUpdates
                [class] => Mage_Core_Model_Resource_Setup
                [type] => ->
                [args] => Array
                    (
                    )

            )

        [13] => Array
            (
                [file] => D:\xampp\htdocs\magento2\app\code\core\Mage\Core\Model\App.php
                [line] => 426
                [function] => applyAllUpdates
                [class] => Mage_Core_Model_Resource_Setup
                [type] => ::
                [args] => Array
                    (
                    )

            )

        [14] => Array
            (
                [file] => D:\xampp\htdocs\magento2\app\code\core\Mage\Core\Model\App.php
                [line] => 350
                [function] => _initModules
                [class] => Mage_Core_Model_App
                [type] => ->
                [args] => Array
                    (
                    )

            )

        [15] => Array
            (
                [file] => D:\xampp\htdocs\magento2\app\Mage.php
                [line] => 658
                [function] => run
                [class] => Mage_Core_Model_App
                [type] => ->
                [args] => Array
                    (
                        [0] => Array
                            (
                                [scope_code] => 
                                [scope_type] => store
                                [options] => Array
                                    (
                                    )

                            )

                    )

            )

        [16] => Array
            (
                [file] => D:\xampp\htdocs\magento2\index.php
                [line] => 34
                [function] => run
                [class] => Mage
                [type] => ::
                [args] => Array
                    (
                        [0] => 
                        [1] => store
                    )

            )

    )

[previous:Exception:private] => PDOException Object
    (
        [message:protected] => SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento2.customer/eav_attribute' doesn't exist
        [string:Exception:private] => 
        [code:protected] => 42S02
        [file:protected] => D:\xampp\htdocs\magento2\lib\Zend\Db\Statement\Pdo.php
        [line:protected] => 228
        [trace:Exception:private] => Array
            (
                [0] => Array
                    (
                        [file] => D:\xampp\htdocs\magento2\lib\Zend\Db\Statement\Pdo.php
                        [line] => 228
                        [function] => execute
                        [class] => PDOStatement
                        [type] => ->
                        [args] => Array
                            (
                                [0] => Array
                                    (
                                        [:id] => disable_auto_group_change
                                        [:entity_type_id] => 1
                                    )

                            )

                    )

                [1] => Array
                    (
                        [file] => D:\xampp\htdocs\magento2\lib\Varien\Db\Statement\Pdo\Mysql.php
                        [line] => 110
                        [function] => _execute
                        [class] => Zend_Db_Statement_Pdo
                        [type] => ->
                        [args] => Array
                            (
                                [0] => Array
                                    (
                                        [:id] => disable_auto_group_change
                                        [:entity_type_id] => 1
                                    )

                            )

                    )

                [2] => Array
                    (
                        [file] => D:\xampp\htdocs\magento2\lib\Zend\Db\Statement.php
                        [line] => 300
                        [function] => _execute
                        [class] => Varien_Db_Statement_Pdo_Mysql
                        [type] => ->
                        [args] => Array
                            (
                                [0] => Array
                                    (
                                        [:id] => disable_auto_group_change
                                        [:entity_type_id] => 1
                                    )

                            )

                    )

                [3] => Array
                    (
                        [file] => D:\xampp\htdocs\magento2\lib\Zend\Db\Adapter\Abstract.php
                        [line] => 479
                        [function] => execute
                        [class] => Zend_Db_Statement
                        [type] => ->
                        [args] => Array
                            (
                                [0] => Array
                                    (
                                        [:id] => disable_auto_group_change
                                        [:entity_type_id] => 1
                                    )

                            )

                    )

                [4] => Array
                    (
                        [file] => D:\xampp\htdocs\magento2\lib\Zend\Db\Adapter\Pdo\Abstract.php
                        [line] => 238
                        [function] => query
                        [class] => Zend_Db_Adapter_Abstract
                        [type] => ->
                        [args] => Array
                            (
                                [0] => SELECT `main`.*, `additional`.* FROM `eav_attribute` AS `main`

INNER JOIN customer/eav_attribute AS additional ON main.attribute_id = additional.attribute_id WHERE (main.attribute_code = :id) AND (main.entity_type_id = :entity_type_id)
[1] => Array
(
[:id] => disable_auto_group_change
[:entity_type_id] => 1
)

                            )

                    )

                [5] => Array
                    (
                        [file] => D:\xampp\htdocs\magento2\lib\Varien\Db\Adapter\Pdo\Mysql.php
                        [line] => 422
                        [function] => query
                        [class] => Zend_Db_Adapter_Pdo_Abstract
                        [type] => ->
                        [args] => Array
                            (
                                [0] => SELECT `main`.*, `additional`.* FROM `eav_attribute` AS `main`

INNER JOIN customer/eav_attribute AS additional ON main.attribute_id = additional.attribute_id WHERE (main.attribute_code = :id) AND (main.entity_type_id = :entity_type_id)
[1] => Array
(
[:id] => disable_auto_group_change
[:entity_type_id] => 1
)

                            )

                    )

                [6] => Array
                    (
                        [file] => D:\xampp\htdocs\magento2\lib\Zend\Db\Adapter\Abstract.php
                        [line] => 753
                        [function] => query
                        [class] => Varien_Db_Adapter_Pdo_Mysql
                        [type] => ->
                        [args] => Array
                            (
                                [0] => Varien_Db_Select Object
                                    (
                                        [_bind:protected] => Array
                                            (
                                            )

                                        [_adapter:protected] => Varien_Db_Adapter_Pdo_Mysql Object
                                            (
                                                [_defaultStmtClass:protected] => Varien_Db_Statement_Pdo_Mysql
                                                [_transactionLevel:protected] => 0
                                                [_connectionFlagsSet:protected] => 1
                                                [_ddlCache:protected] => Array
                                                    (
                                                    )

                                                [_bindParams:protected] => Array
                                                    (
                                                    )

                                                [_bindIncrement:protected] => 0
                                                [_debug:protected] => 
                                                [_logQueryTime:protected] => 0.05
                                                [_logAllQueries:protected] => 
                                                [_logCallStack:protected] => 
                                                [_debugFile:protected] => var/debug/pdo_mysql.log
                                                [_debugIoAdapter:protected] => 
                                                [_debugTimer:protected] => 0
                                                [_cacheAdapter:protected] => Varien_Cache_Core Object
                                                    (
                                                        [_backend:protected] => Zend_Cache_Backend_File Object
                                                            (
                                                                [_options:protected] => Array
                                                                    (
                                                                        [cache_dir] => D:\xampp\htdocs\magento2\var\cache\
                                                                        [file_locking] => 1
                                                                        [read_control] => 1
                                                                        [read_control_type] => crc32
                                                                        [hashed_directory_level] => 1
                                                                        [hashed_directory_umask] => 511
                                                                        [file_name_prefix] => mage
                                                                        [cache_file_umask] => 384
                                                                        [metadatas_array_max_size] => 100
                                                                    )

                                                                [_metadatasArray:protected] => Array
                                                                    (
                                                                    )

                                                                [_directives:protected] => Array
                                                                    (
                                                                        [lifetime] => 7200
                                                                        [logging] => 
                                                                        [logger] => 
                                                                    )

                                                            )

                                                        [_options:protected] => Array
                                                            (
                                                                [write_control] => 1
                                                                [caching] => 1
                                                                [cache_id_prefix] => eb1_
                                                                [automatic_serialization] => 
                                                                [automatic_cleaning_factor] => 0
                                                                [lifetime] => 7200
                                                                [logging] => 
                                                                [logger] => 
                                                                [ignore_user_abort] => 
                                                            )

                                                        [_specificOptions:protected] => Array
                                                            (
                                                            )

                                                        [_lastId:Zend_Cache_Core:private] => 
                                                        [_extendedBackend:protected] => 1
                                                        [_backendCapabilities:protected] => Array
                                                            (
                                                                [automatic_cleaning] => 1
                                                                [tags] => 1
                                                                [expired_read] => 1
                                                                [priority] => 
                                                                [infinite_lifetime] => 1
                                                                [get_list] => 1
                                                            )

                                                    )

                                                [_isDdlCacheAllowed:protected] => 
                                                [_ddlColumnTypes:protected] => Array
                                                    (
                                                        [boolean] => bool
                                                        [smallint] => smallint
                                                        [integer] => int
                                                        [bigint] => bigint
                                                        [float] => float
                                                        [decimal] => decimal
                                                        [numeric] => decimal
                                                        [date] => date
                                                        [timestamp] => timestamp
                                                        [datetime] => datetime
                                                        [text] => text
                                                        [blob] => blob
                                                        [varbinary] => blob
                                                    )

                                                [_ddlRoutines:protected] => Array
                                                    (
                                                        [0] => alt
                                                        [1] => cre
                                                        [2] => ren
                                                        [3] => dro
                                                        [4] => tru
                                                    )

                                                [_intervalUnits:protected] => Array
                                                    (
                                                        [YEARS] => YEAR
                                                        [MONTHS] => MONTH
                                                        [DAYS] => DAY
                                                        [HOURS] => HOUR
                                                        [MINUTES] => MINUTE
                                                        [SECOND] => SECOND
                                                    )

                                                [_queryHook:protected] => 
                                                [_pdoType:protected] => mysql
                                                [_numericDataTypes:protected] => Array
                                                    (
                                                        [0] => 0
                                                        [1] => 1
                                                        [2] => 2
                                                        [INT] => 0
                                                        [INTEGER] => 0
                                                        [MEDIUMINT] => 0
                                                        [SMALLINT] => 0
                                                        [TINYINT] => 0
                                                        [BIGINT] => 1
                                                        [SERIAL] => 1
                                                        [DEC] => 2
                                                        [DECIMAL] => 2
                                                        [DOUBLE] => 2
                                                        [DOUBLE PRECISION] => 2
                                                        [FIXED] => 2
                                                        [FLOAT] => 2
                                                    )

                                                [_config:protected] => Array
                                                    (
                                                        [host] => localhost
                                                        [username] => magento2
                                                        [password] => magento2
                                                        [dbname] => magento2
                                                        [initStatements] => SET NAMES utf8
                                                        [model] => mysql4
                                                        [type] => pdo_mysql
                                                        [pdoType] => 
                                                        [active] => 1
                                                        [charset] => 
                                                        [persistent] => 
                                                        [options] => Array
                                                            (
                                                                [caseFolding] => 0
                                                                [autoQuoteIdentifiers] => 1
                                                                [fetchMode] => 2
                                                            )

                                                        [driver_options] => Array
                                                            (
                                                            )

                                                    )

                                                [_fetchMode:protected] => 2
                                                [_profiler:protected] => Zend_Db_Profiler Object
                                                    (
                                                        [_queryProfiles:protected] => Array
                                                            (
                                                            )

                                                        [_enabled:protected] => 
                                                        [_filterElapsedSecs:protected] => 
                                                        [_filterTypes:protected] => 
                                                    )

                                                [_defaultProfilerClass:protected] => Zend_Db_Profiler
                                                [_connection:protected] => PDO Object
                                                    (
                                                    )

                                                [_caseFolding:protected] => 0
                                                [_autoQuoteIdentifiers:protected] => 1
                                                [_allowSerialization:protected] => 1
                                                [_autoReconnectOnUnserialize:protected] => 
                                            )

                                        [_parts:protected] => Array
                                            (
                                                [straightjoin] => 
                                                [distinct] => 
                                                [columns] => Array
                                                    (
                                                        [0] => Array
                                                            (
                                                                [0] => main
                                                                [1] => *
                                                                [2] => 
                                                            )

                                                        [1] => Array
                                                            (
                                                                [0] => additional
                                                                [1] => *
                                                                [2] => 
                                                            )

                                                    )

                                                [union] => Array
                                                    (
                                                    )

                                                [from] => Array
                                                    (
@danslo
Copy link
Contributor

danslo commented Jun 27, 2012

You can't use the current sample data with Magento 2.

@magento-team
Copy link
Contributor

Right. Magento 1.x database dumps are incompatible with Magento 2.x. The problem is in backwards-incompatible changes done on DB level so far.

Due to elimination of "factory names" of classes and tables, there are backwards-incompatible changes in values of some columns, which were storing these names. Specifically, fields in eav_entity_type table:

entity_model
attribute_model
entity_table
increment_model
additional_attribute_table
entity_attribute_collection

... or catalog_eav_attribute.frontend_input_renderer and others

Thus, a value that used to be sales/order and interpreted either as table name or class name, was replaced into real table or class names:

Mage_Sales_Model_Resource_Order (a class)
sales_flat_order (a table)

We plan to have sample data as a module, rather than a DB dump. Originally it was brought by an old community issue http://www.magentocommerce.com/bug-tracking/issue?issue=8061

Currently intentions are to separate any sample content (CMS pages, blocks, banners) into a module, then to implement ability to choose to disable this module during installation. These changes most likely will be implemented at some point before GA release of Magento 2.0

Although this comment provides our best view of the product direction, priorities can change and features may be adjusted. As a result, we do not recommend making firm business decisions solely based on the information above.

Attempting to repair a 1.x DB dump would be a very hard manual operation, but theoretically it is possible, provided that you have all formal backwards-incompatible changes documented. These changes are constantly being recorded to developer's guide as we go and perform backwards-incompatible changes.

magento-team pushed a commit that referenced this issue Jan 16, 2015
…e-theme-version

[Extensibility] MAGETWO-25343: Declaration of Components: XML VS composer.json - Removed version from theme.xml
This was referenced Mar 4, 2015
@stevieyu stevieyu mentioned this issue Apr 3, 2015
@FabXav FabXav mentioned this issue Oct 11, 2024
5 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants