# Please How are CACHES deleted Mautic 3? **URL:** \ **Category:** Mautic 3 - Install/Upgrade Support\ **Created:** [August 8, 2020, 5:31am UTC](https://forum.mautic.org/t/please-how-are-caches-deleted-mautic-3/15563 "2020-08-08T05:31:33Z")\ **Posts on this page:** 8\ **Page:** 2
**Author:** ![ravinbhutani](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ravinbhutani/32/412_2.png) [@ravinbhutani](https://forum.mautic.org/u/ravinbhutani)\ **Post date:** [October 13, 2020, 1:03pm UTC](https://forum.mautic.org/t/please-how-are-caches-deleted-mautic-3/15563/21 "2020-10-13T13:03:27Z")
Mautic Version is 3.1.1 **In system Info: it is showing these details: (I have copied only the details, which I assume can help)** * * * **PHP Info** PHP Version 7.3.23 System Linux [sh202.bigrock.com](http://sh202.bigrock.com) 4.14.146-225.ELK.el7.x86\_64 #1 SMP Sat Sep 21 01:25:09 CDT 2019 x86\_64 Build Date Oct 6 2020 16:20:49 | MysqlI Support | enabled | | --- | --- | | Client API library version | mysqlnd 5.0.12-dev - 20150407 | * * * **Folder and permission** | Folder/File Path | Is writable | | --- | --- | | /home4/joylocxl/connect.joyloan.in/app/config/local.php | Writable | | /home4/joylocxl/connect.joyloan.in/var/cache | Writable | | /home4/joylocxl/connect.joyloan.in/var/logs | Writable | | /home4/joylocxl/connect.joyloan.in/media/files | Writable | | /home4/joylocxl/connect.joyloan.in/media/images | Writable | | /home4/joylocxl/connect.joyloan.in/translations | Writable | * * * **## Current Error Log** [2020-10-13 09:40:58] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE t.date\_sent BETWEEN ? AND ? GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 09:40:58”]: Unknown column ‘t.generated\_sent\_date’ in ‘field list’" at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE t.date\_sent BETWEEN ? AND ? GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 09:40:58”]:\n\nUnknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)”} [2020-10-13 09:41:18] mautic.NOTICE: Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing ‘ALTER TABLE mau86\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), “-”, LPAD(MONTH(date\_sent), 2, “0”), “-”, LPAD(DAY(date\_sent), 2, “0”))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(gen’ at line 2 (uncaught exception) at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `doctrine:migrations:migrate` [2020-10-13 09:41:18] mautic.WARNING: Command `doctrine:migrations:migrate` exited with status code 1 [2020-10-13 09:41:18] mautic.ERROR: [UPGRADE ERROR] Exit code 1; ++ adding generated column generated\_sent\_date -\> ALTER TABLE mau86\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), “-”, LPAD(MONTH(date\_sent), 2, “0”), “-”, LPAD(DAY(date\_sent), 2, “0”))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(generated\_sent\_date, email\_id) \ In AbstractMySQLDriver.php line 79: \ An exception occurred while executing ‘ALTER TABLE mau86\_email\_stats ADD ge nerated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), “-”, LPAD(MONTH(date\_sen t), 2, “0”), “-”, LPAD(DAY(date\_sent), 2, “0”))) COMMENT ‘(DC2Type:generate d)’; ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_d ate_email_id`(generated\_sent\_date, email\_id)’: \ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE mau 86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(gen’ at line 2 \ In MysqliStatement.php line 86: \ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE mau 86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(gen’ at line 2 \ doctrine:migrations:migrate [–write-sql [WRITE-SQL]] [–dry-run] [–query-time] [–allow-no-migration] [–all-or-nothing [ALL-OR-NOTHING]] [–configuration [CONFIGURATION]] [–db-configuration [DB-CONFIGURATION]] [–db DB] [–em EM] [–shard SHARD] [-h|–help] [-q|–quiet] [-v|vv|vvv|–verbose] [-V|–version] [–ansi] [–no-ansi] [-n|–no-interaction] [-e|–env ENV] [–no-debug] [–] \ [2020-10-13 09:41:34] mautic.NOTICE: Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing ‘ALTER TABLE mau86\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), “-”, LPAD(MONTH(date\_sent), 2, “0”), “-”, LPAD(DAY(date\_sent), 2, “0”))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(gen’ at line 2 (uncaught exception) at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `doctrine:migrations:migrate` [2020-10-13 09:41:34] mautic.WARNING: Command `doctrine:migrations:migrate` exited with status code 1 [2020-10-13 09:41:34] mautic.ERROR: [UPGRADE ERROR] Exit code 1; ++ adding generated column generated\_sent\_date -\> ALTER TABLE mau86\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), “-”, LPAD(MONTH(date\_sent), 2, “0”), “-”, LPAD(DAY(date\_sent), 2, “0”))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(generated\_sent\_date, email\_id) \ In AbstractMySQLDriver.php line 79: \ An exception occurred while executing ‘ALTER TABLE mau86\_email\_stats ADD ge nerated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), “-”, LPAD(MONTH(date\_sen t), 2, “0”), “-”, LPAD(DAY(date\_sent), 2, “0”))) COMMENT ‘(DC2Type:generate d)’; ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_d ate_email_id`(generated\_sent\_date, email\_id)’: \ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE mau 86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(gen’ at line 2 \ In MysqliStatement.php line 86: \ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE mau 86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(gen’ at line 2 \ doctrine:migrations:migrate [–write-sql [WRITE-SQL]] [–dry-run] [–query-time] [–allow-no-migration] [–all-or-nothing [ALL-OR-NOTHING]] [–configuration [CONFIGURATION]] [–db-configuration [DB-CONFIGURATION]] [–db DB] [–em EM] [–shard SHARD] [-h|–help] [-q|–quiet] [-v|vv|vvv|–verbose] [-V|–version] [–ansi] [–no-ansi] [-n|–no-interaction] [-e|–env ENV] [–no-debug] [–] \ [2020-10-13 09:59:30] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE (t.email\_id IN (9)) AND (t.date\_sent BETWEEN ? AND ?) GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 09:59:30”]: Unknown column ‘t.generated\_sent\_date’ in ‘field list’" at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE (t.email\_id IN (9)) AND (t.date\_sent BETWEEN ? AND ?) GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 09:59:30”]:\n\nUnknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)”} [2020-10-13 04:40:55] mautic.CRITICAL: Uncaught PHP Exception Mautic\PluginBundle\Exception\ApiErrorException: “Property values were not valid Array ( [0] =\> Array ( [isValid] =\> [message] =\> Active was not one of the allowed options: [label: “Not Eligible” value: “Inactive” display\_order: 0 double\_data: 0.0 hidden: false description: “” read\_only: false , label: “Eligible” value: “Eligible” display\_order: 1 double\_data: 0.0 hidden: false description: “” read\_only: false] [error] =\> INVALID\_OPTION [name] =\> marketing\_status ) ) " at /home4/joylocxl/connect.joyloan.in/plugins/MauticCrmBundle/Api/HubspotApi.php line 28 {“exception”:”[object] (Mautic\PluginBundle\Exception\ApiErrorException(code: 0): Property values were not valid \n Array\n(\n [0] =\> Array\n (\n [isValid] =\> \n [message] =\> Active was not one of the allowed options: [label: “Not Eligible”\nvalue: “Inactive”\ndisplay\_order: 0\ndouble\_data: 0.0\nhidden: false\ndescription: “”\nread\_only: false\n, label: “Eligible”\nvalue: “Eligible”\ndisplay\_order: 1\ndouble\_data: 0.0\nhidden: false\ndescription: “”\nread\_only: false\n]\n [error] =\> INVALID\_OPTION\n [name] =\> marketing\_status\n )\n\n)\n at /home4/joylocxl/connect.joyloan.in/plugins/MauticCrmBundle/Api/HubspotApi.php:28)"} [2020-10-13 10:14:48] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE (t.email\_id IN (11)) AND (t.date\_sent BETWEEN ? AND ?) GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 10:14:48”]: Unknown column ‘t.generated\_sent\_date’ in ‘field list’" at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE (t.email\_id IN (11)) AND (t.date\_sent BETWEEN ? AND ?) GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 10:14:48”]:\n\nUnknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)”} [2020-10-13 10:56:34] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE t.date\_sent BETWEEN ? AND ? GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 10:56:34”]: Unknown column ‘t.generated\_sent\_date’ in ‘field list’" at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE t.date\_sent BETWEEN ? AND ? GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 10:56:34”]:\n\nUnknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)”} [2020-10-13 10:56:39] mautic.NOTICE: Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing ‘ALTER TABLE mau86\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), “-”, LPAD(MONTH(date\_sent), 2, “0”), “-”, LPAD(DAY(date\_sent), 2, “0”))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(gen’ at line 2 (uncaught exception) at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `doctrine:migrations:migrate` [2020-10-13 10:56:39] mautic.WARNING: Command `doctrine:migrations:migrate` exited with status code 1 [2020-10-13 10:56:39] mautic.ERROR: [UPGRADE ERROR] Exit code 1; ++ adding generated column generated\_sent\_date -\> ALTER TABLE mau86\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), “-”, LPAD(MONTH(date\_sent), 2, “0”), “-”, LPAD(DAY(date\_sent), 2, “0”))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(generated\_sent\_date, email\_id) \ In AbstractMySQLDriver.php line 79: \ An exception occurred while executing ‘ALTER TABLE mau86\_email\_stats ADD ge nerated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), “-”, LPAD(MONTH(date\_sen t), 2, “0”), “-”, LPAD(DAY(date\_sent), 2, “0”))) COMMENT ‘(DC2Type:generate d)’; ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_d ate_email_id`(generated\_sent\_date, email\_id)’: \ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE mau 86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(gen’ at line 2 \ In MysqliStatement.php line 86: \ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE mau 86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(gen’ at line 2 \ doctrine:migrations:migrate [–write-sql [WRITE-SQL]] [–dry-run] [–query-time] [–allow-no-migration] [–all-or-nothing [ALL-OR-NOTHING]] [–configuration [CONFIGURATION]] [–db-configuration [DB-CONFIGURATION]] [–db DB] [–em EM] [–shard SHARD] [-h|–help] [-q|–quiet] [-v|vv|vvv|–verbose] [-V|–version] [–ansi] [–no-ansi] [-n|–no-interaction] [-e|–env ENV] [–no-debug] [–] \ [2020-10-13 11:16:17] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE t.date\_sent BETWEEN ? AND ? GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 11:16:17”]: Unknown column ‘t.generated\_sent\_date’ in ‘field list’" at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE t.date\_sent BETWEEN ? AND ? GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 11:16:17”]:\n\nUnknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)”} [2020-10-13 11:16:24] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE t.date\_sent BETWEEN ? AND ? GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 11:16:24”]: Unknown column ‘t.generated\_sent\_date’ in ‘field list’" at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE t.date\_sent BETWEEN ? AND ? GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 11:16:24”]:\n\nUnknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)”} [2020-10-13 11:23:12] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE (t.email\_id IN (13)) AND (t.date\_sent BETWEEN ? AND ?) GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 11:23:12”]: Unknown column ‘t.generated\_sent\_date’ in ‘field list’" at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT t.generated\_sent\_date AS date, COUNT(_) AS count FROM mau86\_email\_stats t WHERE (t.email\_id IN (13)) AND (t.date\_sent BETWEEN ? AND ?) GROUP BY t.generated\_sent\_date ORDER BY t.generated\_sent\_date ASC LIMIT 31’ with params [“2020-09-13 00:00:00”, “2020-10-13 11:23:12”]:\n\nUnknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘t.generated\_sent\_date’ in ‘field list’ at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)”} [2020-10-13 18:19:38] mautic.NOTICE: Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing ‘ALTER TABLE mau86\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), “-”, LPAD(MONTH(date\_sent), 2, “0”), “-”, LPAD(DAY(date\_sent), 2, “0”))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(generated\_sent\_date, email\_id)’: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(gen’ at line 2 (uncaught exception) at /home4/joylocxl/connect.joyloan.in/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `doctrine:migrations:migrate` [2020-10-13 18:19:38] mautic.WARNING: Command `doctrine:migrations:migrate` exited with status code 1 [2020-10-13 18:19:38] mautic.ERROR: [UPGRADE ERROR] Exit code 1; ++ adding generated column generated\_sent\_date -\> ALTER TABLE mau86\_email\_stats ADD generated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), “-”, LPAD(MONTH(date\_sent), 2, “0”), “-”, LPAD(DAY(date\_sent), 2, “0”))) COMMENT ‘(DC2Type:generated)’; ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(generated\_sent\_date, email\_id) \ In AbstractMySQLDriver.php line 79: \ An exception occurred while executing ‘ALTER TABLE mau86\_email\_stats ADD ge nerated\_sent\_date DATE AS (CONCAT(YEAR(date\_sent), “-”, LPAD(MONTH(date\_sen t), 2, “0”), “-”, LPAD(DAY(date\_sent), 2, “0”))) COMMENT ‘(DC2Type:generate d)’; ALTER TABLE mau86\_email\_stats ADD INDEX `mau86_generated_sent_d ate_email_id`(generated\_sent\_date, email\_id)’: \ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE mau 86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(gen’ at line 2 \ In MysqliStatement.php line 86: \ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE mau 86\_email\_stats ADD INDEX `mau86_generated_sent_date_email_id`(gen’ at line 2 \ doctrine:migrations:migrate [–write-sql [WRITE-SQL]] [–dry-run] [–query-time] [–allow-no-migration] [–all-or-nothing [ALL-OR-NOTHING]] [–configuration [CONFIGURATION]] [–db-configuration [DB-CONFIGURATION]] [–db DB] [–em EM] [–shard SHARD] [-h|–help] [-q|–quiet] [-v|vv|vvv|–verbose] [-V|–version] [–ansi] [–no-ansi] [-n|–no-interaction] [-e|–env ENV] [–no-debug] [–] \ ---
**Author:** ![EJL](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ejl/32/12155_2.png) [@EJL](https://forum.mautic.org/u/EJL)\ **Post date:** [October 13, 2020, 2:39pm UTC](https://forum.mautic.org/t/please-how-are-caches-deleted-mautic-3/15563/22 "2020-10-13T14:39:34Z")
You should start a new thread for your problem specifically so we can efficiently help you troubleshoot the errors. We should not continue in this support thread as it was a cron syntax issue, and your issue is SQL syntax errors. ---
**Author:** ![ravinbhutani](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ravinbhutani/32/412_2.png) [@ravinbhutani](https://forum.mautic.org/u/ravinbhutani)\ **Post date:** [October 14, 2020, 6:28am UTC](https://forum.mautic.org/t/please-how-are-caches-deleted-mautic-3/15563/23 "2020-10-14T06:28:56Z")
I have created a topic here: [SQL syntax errors Mautic 3.1.1](https://forum.mautic.org/t/sql-syntax-errors-mautic-3-1-1/16555) Please help me ---
**Author:** ![scoupeau](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/scoupeau/32/918_2.png) [@scoupeau](https://forum.mautic.org/u/scoupeau)\ **Post date:** [December 31, 2020, 6:52pm UTC](https://forum.mautic.org/t/please-how-are-caches-deleted-mautic-3/15563/24 "2020-12-31T18:52:25Z")
If you have cPanel or Plesk or whatever control panel you should erase the cache very easily. Go to File Manager and open /var/cache folder inside the Mautic folder. Delete all the content in cache folder and the problem will be fixed 🙂 ---
**Author:** ![maxemojo](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/maxemojo/32/471_2.png) [@maxemojo](https://forum.mautic.org/u/maxemojo)\ **Post date:** [April 16, 2021, 1:25pm UTC](https://forum.mautic.org/t/please-how-are-caches-deleted-mautic-3/15563/25 "2021-04-16T13:25:37Z")
Simple question: What is the difference between running: php bin/console mautic:cache:clear And clearing out the /var/cache directory? Because seems to me “php bin/console mautic:cache:clear” does not do much? I ask, because after having API problems, clearing the directory fixed it but “php bin/console mautic:cache:clear” does not. ---
**Author:** ![EJL](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ejl/32/12155_2.png) [@EJL](https://forum.mautic.org/u/EJL)\ **Post date:** [April 16, 2021, 11:07pm UTC](https://forum.mautic.org/t/please-how-are-caches-deleted-mautic-3/15563/26 "2021-04-16T23:07:18Z")
> [@maxemojo](#): > > php bin/console mautic:cache:clear This appears incorrectly formatted. It lacks the actual path to your mautic install. Here is an example: **/opt/plesk/php/7.4/bin/php /var/www/vhosts/MauticDomain.com/mautic-sub-domain-if-any.com/bin/console cache:clear** ---
**Author:** ![maxemojo](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/maxemojo/32/471_2.png) [@maxemojo](https://forum.mautic.org/u/maxemojo)\ **Post date:** [April 17, 2021, 8:20am UTC](https://forum.mautic.org/t/please-how-are-caches-deleted-mautic-3/15563/27 "2021-04-17T08:20:36Z")
I am in the correct directory in CLI where I run my commands. > **[Command Line Interface (CLI) commands](https://docs.mautic.org/en/troubleshooting/command-line-tools-cli)** > > . Sometimes you may need to use the command line (CLI) with Mautic. Here follows a list of the CLI commands that can be used.You can find this list (and others for example commands relating to Doctrine and other vendors) by typing. bin/console. at... My point is that that the command to clear cache does not do the same as clearing the …var/cache directory. ---
**Author:** ![EJL](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ejl/32/12155_2.png) [@EJL](https://forum.mautic.org/u/EJL)\ **Post date:** [April 17, 2021, 3:54pm UTC](https://forum.mautic.org/t/please-how-are-caches-deleted-mautic-3/15563/28 "2021-04-17T15:54:16Z")
I believe mautic:cache:clear purges the contents of the var/cache/prod folder [Previous page](https://forum.mautic.org/t/please-how-are-caches-deleted-mautic-3/15563.md?page=1)