Please How are CACHES deleted Mautic 3?

I GOT SOMETHING NOW

[root@vpserver mauticstage]# ls -l /home/beginnersbase1/public_html/mauticstage
total 112
drwxr-xr-x 7 beginnersbase1 beginnersbase1 4096 Aug 5 02:55 app
drwxr-xr-x 2 beginnersbase1 beginnersbase1 4096 Aug 5 02:55 bin
-rw-r–r-- 1 beginnersbase1 beginnersbase1 12862 Aug 5 02:55 favicon.ico
-rw-r–r-- 1 beginnersbase1 beginnersbase1 634 Aug 5 02:55 index.php
-rw-r–r-- 1 beginnersbase1 beginnersbase1 38419 Aug 5 02:55 LICENSE.txt
drwxr-xr-x 2 beginnersbase1 beginnersbase1 4096 Aug 5 02:26 mautic-3-temp-files
drwxr-xr-x 7 beginnersbase1 beginnersbase1 4096 Aug 5 02:26 media
-rw-r–r-- 1 beginnersbase1 beginnersbase1 4043 Aug 5 02:55 offline.php
drwxr-xr-x 15 beginnersbase1 beginnersbase1 4096 Aug 6 18:05 plugins
-rw-r–r-- 1 beginnersbase1 beginnersbase1 224 Aug 5 02:55 robots.txt
-rw-r–r-- 1 beginnersbase1 beginnersbase1 1317 Aug 5 02:55 SECURITY.md
drwxr-xr-x 19 beginnersbase1 beginnersbase1 4096 Aug 5 02:55 themes
drwxr-xr-x 2 beginnersbase1 beginnersbase1 4096 Aug 5 02:55 translations
drwxr-xr-x 3 beginnersbase1 beginnersbase1 4096 Aug 5 02:56 upgrade
drwxr-xr-x 6 beginnersbase1 beginnersbase1 4096 Aug 8 13:04 var
drwxr-xr-x 69 beginnersbase1 beginnersbase1 4096 Aug 5 02:56 vendor
[root@vpserver mauticstage]#

What do i do now?

beginn… is the owner of the directory, do you have a folder named bin inside the mautic directory?

edit: nevermind, I saw that :slight_smile:

Now, run the following command:

sudo -u beginnersbase1 php /home/beginnersbase1/public_html/mauticstage/bin/console cache:clear

Please should this be pasted and run in one word or line?

check my edit, and it should be paste in one line, /var/www/mautic/bin/console won’t work for you, use this:

sudo -u beginnersbase1 php /home/beginnersbase1/public_html/mauticstage/bin/console cache:clear

Image example:

Thank you @devsrealm
:smiling_face_with_three_hearts:

today is my lucky day i guess. I am grateful for helping me fix this. God bless you

Here:
[root@vpserver mauticstage]# sudo -u beginnersbase1 php /home/beginnersbase1/public_html/mauticstage/bin/console cache:clear

// Clearing the cache for the prod environment with debug
// false

[OK] Cache for the “prod” environment (debug=false) was successfully cleared.

Content-type: text/html; charset=UTF-8

[root@vpserver mauticstage]#

2 Likes

Glad it worked bro, and God bless u too :slight_smile:.

Today I initiated my first campaign and Mautic got hanged for 6 hours. Still I can not open dashboard or login through main page. Troubleshooting suggest to clear cache

  1. To clear the cache, I can not see the “/app/cache” folder (but there is AppCache.php )
  2. “http://[your-mautic-url]/s/update/schema” this method too is giving error

I do not know if I am doing it right, but I made this command: . I am entering this comand in Terminal app in Cpanel provided by my hosting. (my Mautic subdomain is connect.joyloan.in)

sudo -u joylocxl php /home4/joylocxl/connect.joyloan.in/bin/console cache:clear

Comand terminal is giving following output. I do not know what it means

sudo: effective uid is not 0, is /bin/sudo on file system with no “souid” option set or an NFS file system without root privilages?

Can you please help me clear the cache? Hope my Mautic will work after that

Can you tell us version of mautic are you using?

The cache on Mautic 3.x is located at var/cache not app/cache

If all else fails, go to var/cache/prod and delete the contents. Refresh your browser

It is 3.1. I installed it just 2-3 weeks ago. Even made a recent update. So, it is latest, but I do not know where to see version.

The cache folder is in var/cache. I deleted all the contents of that folder. But this error of 500 persists.

“Update/schema” method is also giving error. What else can be wrong?

In the error log it is showing hundreds of errors.

But I can access the Mautic, except dashboard and using login ID and password.

When I use “Update/schema” method, I see the error, but still I can see the other things, including setting section.

i cant think of a reason to run update schema manually. That was the process of your update if you use command line and not clicking the notification. <----Never do that

The version of your mautic is in the bottom right corner of screen but if you cant see screen due to 500 error I understand.

I would start a new post and describe the system you are using and the errors from the log

I was trying as this method (Update/schema) was given in Mautic troubleshooting.

Today was my first newsletter sending, so I do not know what is what.

I can see the error logs by bypassing the login screen. (when I do “Update/schema”, it gives me some error, but I can go in to setting and see errors)

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

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.

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

Please help me

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:

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.

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

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.

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