Your software
My Mautic version is: v4.2.0
My PHP version is: PHP Version 7.4.25
My Database type and version is: 10.3.32-MariaDB
Your problem
My problem is: unable to upload csv or import and even i click on channel->email
it shows me 500 error broke down
error log:
[2022-03-10 09:36:42] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT COUNT(DISTINCT(l.id)) as count FROM leads l LEFT JOIN users u ON u.id = l.owner_id INNER JOIN email_stats es ON l.id = es.lead_id WHERE ((es.email_id = ?) AND (es.is_read = ?)) AND (l.date_identified IS NOT NULL)’ with params [“21”, 1]: SQLSTATE[HY000]: General error: 1030 Got error 194 “Tablespace is missing for a table” from storage engine InnoDB” at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT COUNT(DISTINCT(l.id)) as count FROM leads l LEFT JOIN users u ON u.id = l.owner_id INNER JOIN email_stats es ON l.id = es.lead_id WHERE ((es.email_id = ?) AND (es.is_read = ?)) AND (l.date_identified IS NOT NULL)’ with params [“21”, 1]:\n\nSQLSTATE[HY000]: General error: 1030 Got error 194 “Tablespace is missing for a table” from storage engine InnoDB at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 1030 Got error 194 “Tablespace is missing for a table” from storage engine InnoDB at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1030 Got error 194 “Tablespace is missing for a table” from storage engine InnoDB at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"}
what i can do to solve this