I get the error below when migrating categories. My Magento2 database is fresh. Ubertheme Data Migration Pro 2.0.6
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
-
nnamdi.e ⋅60.00 $tone September 22, 2016
I am migrating from magento 1.9.2 to Magento 2.1
nnamdi.e ⋅60.00 $tone
September 22, 2016
9 answers
Column not found: 1054 Unknown column ‘entity_id’ in ‘where clause’.
The column `entity_id`is a field in the core table `catalog_category_entity_int` of the Magento 2 database default.
You can see this: http://i.prntscr.com/fca592976c6d4116bd3913e819fd46c3.png
I don’t known why it is not exists in your magento 2 database now.
Let’s tell me know what versions of your Magento 2 and Magento 1 in your working now?
Regards,
Mall.
I already commented
‘I am migrating from magento 1.9.2 to Magento 2.1.1’. I have tried also on Magento2.1.0,same thing,Magento renamed field entity_id to row_id in catalog_category_entity_int table. Kindly update your extension as I cannot migrate with it,and I want to use the new features on Magento 2.1.1
Hi nnamdi.e,
As per screenshot in Mall’s previous reply, default Magento CE 2 core database should have ‘entity_id’ column in the core table ‘catalog_entity_int’ (the screenshot shared with you was captured from a default Magento CE 2.x)
I wonder if you’re using Magento CE or Magento Enterpise?
Meanwhile, please provide via private message here your admin and SSH credential so that we can check further.
Regards,
An Nguyen
Hi [email protected],
I have checked your site at staging.yudala.com/admin
and i don’t see our tool installed in your site.
Regards,
Mall.
The tool is installed. I zipped it in pub/ directory to troubleshoot.I have extracted it.I deleted code/Ubertheme directory but it 2.0.6.Kindly take a look at pub/ub-tool
Hi there,
Please try re-install our migration tool, it seems you copy and paste the tool to wrong folder path. Kindly check our Readme.txt file again for detailed instruction.
Once you unzip UB Data Migration Pro download file, you have this app folder. Copy this app folder and paste to the root of your Magento 2 site: PATH_YOUR_MAGENTO_2/app/
Then you should see the folder Ubdatamigration under PATH_YOUR_MAGENTO_2/app/code/Ubertheme.
Hope that helps.
Regards,
An Nguyen
