Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]

[asobiek]

Hi, I recently ran into some errors with MySQL and file permissions. I fixed the problem, got mysql running again, but Sentora is having issues with it. I am getting this when trying to access the control panel:

Code:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sentora_core.x_settings' doesn't exist' in /etc/sentora/panel/dryden/db/driver.class.php:176 Stack trace:  /etc/sentora/panel/dryden/db/driver.class.php(176): PDOStatement->execute() Forum Add-ons and Usage /etc/sentora/panel/dryden/ctrl/options.class.php(29): db_driver->bindQuery('SELECT so_value...', Array) MySupport Addon /etc/sentora/panel/index.php(20): ctrl_options::GetSystemOption('debug_mode') Test of MySupport MOD {main} thrown in /etc/sentora/panel/dryden/db/driver.class.php on line 176

Any help would be greatly appreciated 

Thanks,
Alex Sobiek

[TGates]

It is telling you the problem:

Code:

Table 'sentora_core.x_settings' doesn't exist'

Better check your database as it seems tables are missing or the file/folder permissions are still messed up and MySQL can not read the files that hold the database information. (/var/lib/mysql/)

Permissions for /var/lib/mysql/ files and folders are:
Owner: mysql
Group: mysql
Permissions: 0700

[asobiek]

@TGates
UPDATE:
I've checked the ownership and the permissions of /var/lib/mysql/ and all are fine. In addition, all the databases, including sentora_core are there. MySQL is running as a service just fine. When using phpmyadmin, it lists all the databases but I am unable to open a table. It tells me the table does not exist.

[shaylami]

you have corrupted DB you need to repair all your DB and tables,
please check on mysql website menuall how to repair DB and tables.
good luck

[TGates]

you have  corrupted DB you need to repair all your DB and tables,
please check on mysql website menuall how to repair DB and tables.
good luck

Update us on your progress after doing this.