Issue After Upgrading Magento from 2.4.2 to 2.4.8: Missing core_config_data Table Error and Fronten

[padmachhat5f0d]

Hi,

I have recently upgraded our Magento installation from version 2.4.2 to 2.4.8. However, I am encountering the following issue in the Admin Panel under Content > Design > Configuration:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'insta-db.core_config_data' doesn't exist, query was: SELECT `core_config_data`.* FROM `core_config_data` WHERE (path = 'design/theme/theme_id').

Magento is still trying to access core_config_data without the prefix.

Additionally, the frontend of the website is not displaying any content, such as the header and other page elements. It appears that the layout is broken, and content is not being rendered.

Could you kindly assist in resolving this issue?

 

Thanks

Padma

[Ankit Jasani]

Hi @padmachhat5f0d ,

Open app/etc/env.php and find the 'db' section. It should look roughly like this:

'db' => [
    'table_prefix' => '',
    'connection' => [
        'default' => [
            'host'     => '…',
            'dbname'   => '....',
            'username' => '…',
            'password' => '…',
            'active'   => '1',
        ]
    ]
],

If your tables are prefixed, change it to:

'db' => [
    'table_prefix' => 'myshop_',
    'connection' => [
        'default' => [
            'host'     => '…',
            'dbname'   => '...',
            'username' => '…',
            'password' => '…',
            'active'   => '1',
        ]
    ]
],

Replace myshop_ with whatever prefix your database tables actually use.

Execute below commands from magento root directory
bin/magento setup:upgrade
bin/magento setup:di:compile
bin/magento setup:static-content:deploy -f
bin/magento indexer:reindex

Log back into Admin > Content > Design > Configuration. The error about core_config_data should be gone. Also, make sure each Store View is assigned the correct theme.

Problem Solved? Accept as Solution!

Thanks,

Ankit

[padmachhat5f0d]

Hi @Ankit Jasani ,

In env.php the db structure is already defined and the table is already present in the database still the same error is coming.

Thanks,

Padma

[Ankit Jasani]

Hi @padmachhat5f0d ,

I am not able to see your screenshot actually for some reason but do you have any prefix available for your tables? like xyz_core_config_data

[padmachhat5f0d]

Hi @Ankit Jasani ,

After upgrading Magento from 2.4.2 to 2.4.8, the website frontend is partially broken—key elements like the homepage, navbar, and "Add to Cart" button are missing, though inner pages load when accessed directly. In the admin panel under Content → Design → Configuration, an error appears: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'insta-db.core_config_data' doesn't exist, query was: SELECT `core_config_data`.* FROM `core_config_data` WHERE (path = 'design/theme/theme_id'), even though our database uses the prefix vicm_ and the correct table vicm_core_config_data does exist.

Thanks,

Padma

[Ankit Jasani]

Hi @padmachhat5f0d ,

Have you checked app/etc/env.php and "vicm_" available in table_prefix?

[padmachhat5f0d]

Hi @Ankit Jasani ,

'vicm_' table prefix is present in env.php.

Thanks,

Padma

[Ankit Jasani · Accepted solution]

Hi @padmachhat5f0d ,

Issue already highlighted here
https://github.com/magento/magento2/issues/39847
Solution targeted into 2.4.9-alpha1
Please go through above mentioned thread and read comments.

You can try to upgrade as well as I can see 2.4.9-alpha1 is available.

Problem Solved? Aceept as Solution!

Thanks,

Ankit

[padmachhat5f0d]

Thanks @Ankit Jasani 

[exevenuq321def]

Issue After Upgrading Magento from 2.4.2 to 2.4.8: Missing core_config_data Table Error and Fronten SOLVED Go to solution Did you know you can see the translated content as per your choice? Translate Now padmachhat5f0d padmachhat5f0d Occasional Contributor ‎07-05-2025 05:49 AM Issue After Upgrading Magento from 2.4.2 to 2.4.8: Missing core_config_data Table Error and Fronten Hi, I have recently upgraded our Magento installation from version 2.4.2 to 2.4.8. However, I am encountering the following issue in the Admin Panel under Content > Design > Configuration: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'insta-db.core_config_data' doesn't exist, query was: SELECT `core_config_data`.* FROM `core_config_data` WHERE (path = 'design/theme/theme_id'). Magento is still trying to access core_config_data without the prefix. Additionally, the frontend of the website is not displaying any content, such as the header and other page elements. It appears that the layout is broken, and content is not being rendered. Could you kindly assist in resolving this issue? magento1.png Thanks Padma Solved! Go to Solution. magento2 All forum topics Previous TopicNext Topic 1 ACCEPTED SOLUTION Ankit Jasani Ankit Jasani M2 Certified a month ago Re: Issue After Upgrading Magento from 2.4.2 to 2.4.8: Missing core_config_data Table Error and Fron Hi @padmachhat5f0d , Issue already highlighted here https://github.com/magento/magento2/issues/39847 Solution targeted into 2.4.9-alpha1 Please go through above mentioned thread and read comments. You can try to upgrade as well as I can see 2.4.9-alpha1 is available. Problem Solved? Aceept as Solution! Thanks, Ankit Ankit Jasani View solution in original post