search

ubertheme / magento2_data_migration

The #1 Tool to automatically migrate all core data to Magento 2
https://www.ubertheme.com/magento-extensions-2-x/magento-2-data-migration-pro?utm_source=github&utm_medium=repo&utm_campaign=magento_migration_ce
MIT License
45 stars 39 forks source link

Unknown column 'entity_id' in `catalog_category_entity_int` #48

Open ghost opened 8 years ago

ghost commented 8 years ago

CDbException CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entity_id' in 'where clause'. The SQL statement executed was: SELECT * FROM catalog_category_entity_int t WHERE entity_id= 1 AND attribute_id = 69 AND store_id = 0 LIMIT 1

We don't have entity_id column in catalog_category_entity_int, following is the magento 2 catalog_category_entity_int structure,

image

UberthemeTeam commented 8 years ago

Hi @jellamahendra, Thanks for spending time to work with our migration tool. It's pity that we no longer maintain the old version that you're using. We have a newer version UB Data Migration Pro in place, as mentioned in this post: https://github.com/ubertheme/magento2_data_migration/issues/47 (You can find full details of the tool, with a video tutorial there)

Regards, Ubertheme team

ghost commented 8 years ago

HI Team,

The same issue I am facing in UB Data Migration Lite - 1.0.6, I have downloaded it from https://www.ubertheme.com/magento-news/magento-2-data-migration-pro-release/

image

UberthemeTeam commented 8 years ago

Hi @jellamahendra

We did reply to the same question you posted on Ubertheme.com: https://www.ubertheme.com/magento-news/magento-2-data-migration-pro-release/#comment-2881891338 Kindly provide more details as noted in our reply there, we will get back to you then.

Regards, Ubertheme team

kingkpono commented 8 years ago

I am having the same issue using Pro 2.0.6. I am using a fresh Magento2 database.

CDbException CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entity_id' in 'where clause'. The SQL statement executed was: SELECT * FROM catalog_category_entity_int t WHERE entity_id= 1 AND attribute_id = 69 AND store_id = 0 LIMIT 1 /var/www/vhosts/staging-demo/httpdocs/pub/ub-tool/yii/db/CDbCommand.php(543)

UberthemeTeam commented 8 years ago

Hi @kingkpono ,

In the ticket you asked our team at https://www.ubertheme.com/question/cdbexception-the-table-core_website/, you did use our UB Data Migration Lite (not our Pro version), and you mentioned the Magento 2.0.7 instead.

I also had this after when I open the tool in Magento 2.0.7 fresh installation

We wonder if you had another profile at Ubertheme? If you still need help on our migration tool, kindly follow up further via the ticket above, or you can submit a new one.

Thanks, Ubertheme team