Magento 2 – Fix Error After Migration: Unable to Load Theme by Specified Key

frontend-errormagento2magento2-migration-tool

the migration with data-migration-tool from older Magento to Magento 2.0.4 is completed.

But after migration I get the error in frontend:

Unable to load theme by specified key: 'themename'

This is a very strange error because the theme 'themename' doesn't exist.

The database table theme doesn't show this mysterious theme. The same in adminarea Content -> Themes. And I choose another theme in Configuration -> General -> Design. And the theme doesn't exist in app/design folder.

So from where is this theme coming? Perhaps a theme from older Magento I migrated? If so…how can I delete this old theme and solve this error?

I deleted the caches and var folder, generated the static files, compiled di.xml, set permissions. Nothing helps.

Additional adminarea doesn't load any css.

Best Answer

Thanks for your help.

I found 'themename' in database table design_change and delete the table content.

Related Solutions

Magento 2 – Fix Data Migration SQL Error ‘Column Not Found’

That's precisely your issue: there's supposed to be a entity_id field in the catalog_category_product table. Here's the code that creates it:

//From \Magento\Catalog\Setup\InstallSchema, lines 1202-1210

$table = $installer->getConnection()
    ->newTable($installer->getTable('catalog_category_product'))
    ->addColumn(
        'entity_id',
        \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
        null,
        ['identity' => true, 'nullable' => false, 'primary' => true],
        'Entity ID'
    )

The issue you need to figure out is why the entity_id column has been deleted.

Magento – Magento 2: I’m unable to save new products

I had the same problem and I got the solution doing this:

Export database using the following command:

mysqldump -h [database_host] --user=[database_username] --password=[password] --single-transaction main | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | gzip > /path/to/database_name.sql.gz

Import the database again.

The error is caused because the user rb_magento2 doesn't exist or doesn't have permissions.

Also you can try creating a user with name rb_magento2 but the first solution is the most recommended.

Check this doc: https://devdocs.magento.com/guides/v2.2/cloud/live/stage-prod-migrate.html#troubleshooting-the-database-migration

Best Answer

Related Solutions

Magento 2 – Fix Data Migration SQL Error ‘Column Not Found’

Magento – Magento 2: I’m unable to save new products

Related Topic