How do I fix this error below, it's theme related?

[tobenprais20a8]

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

Exception in /home4/tbnveoum/public_html/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:700

[johnwebdes40a5]

Hello @tobenprais20a8 

Means that Magento is trying to load configuration (specifically the theme config) from the core_config_data table, but the table does not exist in your database.

Confirm the Table is Missing

SHOW TABLES LIKE 'core_config_data';

Recreate the Missing Table

You can manually recreate the core_config_data table using the standard Magento schema. Here's the SQL to do that:

CREATE TABLE `core_config_data` (
  `config_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Config ID',
  `scope` varchar(8) NOT NULL DEFAULT 'default' COMMENT 'Config Scope',
  `scope_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Config Scope ID',
  `path` varchar(255) NOT NULL COMMENT 'Config Path',
  `value` text DEFAULT NULL COMMENT 'Config Value',
  PRIMARY KEY (`config_id`),
  UNIQUE KEY `CORE_CONFIG_DATA_SCOPE_SCOPE_ID_PATH` (`scope`,`scope_id`,`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Core Config Data';

Re-run Magento Setup

php bin/magento setup:upgrade
php bin/magento cache:flush

Hope it helps ! 

If you find our reply helpful, please give us kudos.

A Leading Magento Development Agency That Delivers Powerful Results, Innovation, and Secure Digital Transformation.

WebDesk Solution Support Team

Get a Free Quote | | Adobe Commerce Partner | Hire Us | Call Us 877.536.3789

[tyler874324f37]

If you're encountering a theme-related error on your website, the issue could stem from outdated theme files, a conflict with a plugin, or improperly coded customizations. To resolve this, start by switching to a default theme (like Twenty Twenty-Four) to confirm whether the problem is indeed theme-related. If the error disappears, the issue lies in the original theme of website design agency hong kong. From there, you can either update the theme to its latest version, disable conflicting plugins one by one, or check the theme's functions.php file for syntax errors or deprecated code. Always back up your site before making changes.

[nides47306e19b]

The error is caused by the absence of the core_config_data table in your database. To resolve it, you need to run the Magento database upgrade command by executing php bin/magento setup: upgrade from the command line. This command will attempt to fix any missing tables and apply necessary database updates. If the table still doesn't exist, you may need to restore it from a backup or reinstall Magento to ensure the table and other necessary configurations are properly set up. It's important to note that this issue can affect people working with the Magento system, as missing database tables can lead to various configuration and performance problems.

[nishatareefa99]

When working with  website templates, encountering errors is not uncommon, especially after updates or changes to the site. If you're seeing a theme-related error, it can often be related to coding issues, incompatible plugins.

[m87929881g98b4]

This command will update your database schema and data, ensuring that any missing tables, including core_config_data, are created. Make sure you have a backup of your database before running the command to avoid any data loss. If the error persists, you may need to clear the cache using PK365 php bin/magento cache:clean and php bin/magento cache:flush.