Please How are CACHES deleted Mautic 3?

Product Support Mautic 3 - Install/Upgrade Support
21

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 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] [–] \

22

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.

23

I have created a topic here: SQL syntax errors Mautic 3.1.1

Please help me

24

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 :slight_smile:

25

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.

26

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

27

I am in the correct directory in CLI where I run my commands.

My point is that that the command to clear cache does not do the same as clearing the …var/cache directory.

28

I believe mautic:cache:clear purges the contents of the var/cache/prod folder