Unknown column 'entity_id' in catalog_category_entity_int

[ghost]

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,

[UberthemeTeam]

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: #47
(You can find full details of the tool, with a video tutorial there)

Regards,
Ubertheme team

[ghost]

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/

[UberthemeTeam]

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]

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]

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