Magento Expert Forum - Improve your Magento experience

Results 1 to 2 of 2

Magento 2 - Data Migration Tool, unknown column store_id in customer_entity

  1. #1
    New member
    Join Date
    Sep 2020
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post Magento 2 - Data Migration Tool, unknown column store_id in customer_entity

    am trying to migrate a CE 1.9.4.5 site to CE 2.4.0 and have installed the data migration tool.
    I managed to migrate both Settings and data successfully.
    My orders, products, settings etc. where successfully migrated
    But when i try to perform reindex after successful migration, the following error occurs
    Code:
    Catalog Search index process unknown error:
    SQLSTATE[42S22]: Column not found: 1054 Unknown column 't.store_id' in 'field list'
    The same sql error is shown when i take the category menu in backend admin panel.

    Note. I checked in my old magento 1.9.4.5 site, there also store_id column is not present in customer_entity_varchar table, but everything is working perfectly there.
    Tried migrating data again in a freshly installed magento 2, but no luck.

    Thanks in advance for your help.


    Please find the error screenshots
    Name:  error1.png
Views: 18
Size:  333.3 KB
    Name:  error2.png
Views: 11
Size:  445.0 KB

    View more threads in the same category:

    Last edited by vinodkalpaka; 13-09-2020 at 01:30 PM. Reason: attached error screenshots

  2. #2
    New member
    Join Date
    Sep 2020
    Location
    Indonesia
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    hi @vinodkalpaka it's so hard to migration Magento without an expert, I think lime commerce can help you here: https://www.limecommerce.com/magento...tion-services/

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •