Back to Questions Page

Getting errors migrating categories

1 Comment September 22, 2016
Vote Up
0
Vote Down
Answered
Public
Technical Question
Profile photo of nnamdi.e nnamdi.e asked September 22, 2016

 
 
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

  1. Profile photo of nnamdi.ennamdi.e ⋅60.00 $tone September 22, 2016
    I am migrating from magento 1.9.2 to Magento 2.1

9 answers

Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone September 22, 2016
Public

Hi nnamdi.e@yudala.com,

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.

#1
Vote Up
0
Vote Down
Profile photo of nnamdi.e ⋅60.00 $tone September 23, 2016
Public

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

#2
Vote Up
0
Vote Down
Profile photo of Admin ⋅ Staff ⋅-30640.00 $tone September 23, 2016
Public

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

#3
Vote Up
0
Vote Down
Profile photo of nnamdi.e ⋅60.00 $tone October 14, 2016
Public

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

#8
Vote Up
0
Vote Down
Profile photo of Admin ⋅ Staff ⋅-30640.00 $tone October 17, 2016
Public

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

#9

Please login or Register to Submit Answer

Written By

Further Reading

Comments