Your software
My PHP version is : 7.4
My MySQL/MariaDB version is (delete as applicable): 10.3.36-MariaDB
Updating/Installing Errors
I am Updating
Upgrading via : Command Line
These errors are showing in the installer :
php bin/console doctrine:migrations:migrate
Mautic Migrations
WARNING! You are about to execute a database migration that could result in schema changes and data loss. Are you sure you wish to continue? (y/n)yes
Migrating up to 20220111202917 from 20201123070813
++ migrating 20201125155904
-> ALTER TABLE `maufj_lead_event_log` RENAME INDEX `IDX_SEARCH` TO `maufj_IDX_SEARCH`
Migration 20201125155904 failed during Execution. Error An exception occurred while executing ‘ALTER TABLE maufj_lead_event_log RENAME INDEX IDX_SEARCH TO maufj_IDX_SEARCH’:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1
In AbstractMySQLDriver.php line 98:
An exception occurred while executing 'ALTER TABLE maufj_lead_event_log RENAME INDEX IDX_SEARCH TO maufj_IDX_SEARCH
':
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corre
sponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line
1
In Exception.php line 18:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corre
sponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line
1
In PDOConnection.php line 141:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corre
sponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line
1
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] [–] []
These errors are showing in the Mautic log :
[2022-08-25 03:54:43] console.CRITICAL: Error thrown while running command “doctrine:schema:update --force”. Message: “An exception occurred while executing ‘DROP INDEX IDX_3568220419EB6921 ON maufj_oauth2_user_client_xref’: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists” {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘DROP INDEX IDX_3568220419EB6921 ON maufj_oauth2_user_client_xref’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)”,“command”:“doctrine:schema:update --force”,“message”:“An exception occurred while executing ‘DROP INDEX IDX_3568220419EB6921 ON maufj_oauth2_user_client_xref’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists”} {“hostname”:“cloud.ihserver.com.br”,“pid”:1928407}
[2022-08-25 03:54:45] console.CRITICAL: Error thrown while running command “doctrine:schema:update --force”. Message: “An exception occurred while executing ‘DROP INDEX IDX_3568220419EB6921 ON maufj_oauth2_user_client_xref’: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists” {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘DROP INDEX IDX_3568220419EB6921 ON maufj_oauth2_user_client_xref’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)”,“command”:“doctrine:schema:update --force”,“message”:“An exception occurred while executing ‘DROP INDEX IDX_3568220419EB6921 ON maufj_oauth2_user_client_xref’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists”} {“hostname”:“cloud.ihserver.com.br”,“pid”:1928457}
[2022-08-25 03:54:48] console.CRITICAL: Error thrown while running command “doctrine:schema:update --force”. Message: “An exception occurred while executing ‘DROP INDEX IDX_3568220419EB6921 ON maufj_oauth2_user_client_xref’: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists” {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘DROP INDEX IDX_3568220419EB6921 ON maufj_oauth2_user_client_xref’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)”,“command”:“doctrine:schema:update --force”,“message”:“An exception occurred while executing ‘DROP INDEX IDX_3568220419EB6921 ON maufj_oauth2_user_client_xref’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP INDEX IDX_3568220419EB6921; check that it exists”} {“hostname”:“cloud.ihserver.com.br”,“pid”:1928500}
[2022-08-25 03:54:52] console.CRITICAL: Error thrown while running command “doctrine:migrations:migrate”. Message: “An exception occurred while executing ‘ALTER TABLE maufj_lead_event_log RENAME INDEX IDX_SEARCH TO maufj_IDX_SEARCH’: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1” {“exception”:“[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘ALTER TABLE maufj_lead_event_log RENAME INDEX IDX_SEARCH TO maufj_IDX_SEARCH’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1 at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:98, Doctrine\DBAL\Driver\PDO\Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1 at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1 at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)”,“command”:“doctrine:migrations:migrate”,“message”:“An exception occurred while executing ‘ALTER TABLE maufj_lead_event_log RENAME INDEX IDX_SEARCH TO maufj_IDX_SEARCH’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1”} {“hostname”:“cloud.ihserver.com.br”,“pid”:1928563}
[2022-08-25 03:54:59] console.CRITICAL: Error thrown while running command “doctrine:migrations:migrate --quiet --no-interaction”. Message: “An exception occurred while executing ‘ALTER TABLE maufj_lead_event_log RENAME INDEX IDX_SEARCH TO maufj_IDX_SEARCH’: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1” {“exception”:“[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘ALTER TABLE maufj_lead_event_log RENAME INDEX IDX_SEARCH TO maufj_IDX_SEARCH’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1 at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:98, Doctrine\DBAL\Driver\PDO\Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1 at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1 at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)”,“command”:“doctrine:migrations:migrate --quiet --no-interaction”,“message”:“An exception occurred while executing ‘ALTER TABLE maufj_lead_event_log RENAME INDEX IDX_SEARCH TO maufj_IDX_SEARCH’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1”} {“hostname”:“cloud.ihserver.com.br”,“pid”:1928668}
[2022-08-25 03:58:47] console.CRITICAL: Error thrown while running command “doctrine:migrations:migrate”. Message: “An exception occurred while executing ‘ALTER TABLE maufj_lead_event_log RENAME INDEX IDX_SEARCH TO maufj_IDX_SEARCH’: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1” {“exception”:“[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘ALTER TABLE maufj_lead_event_log RENAME INDEX IDX_SEARCH TO maufj_IDX_SEARCH’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1 at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:98, Doctrine\DBAL\Driver\PDO\Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1 at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1 at /home/icombr/public_html/marketing/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)”,“command”:“doctrine:migrations:migrate”,“message”:“An exception occurred while executing ‘ALTER TABLE maufj_lead_event_log RENAME INDEX IDX_SEARCH TO maufj_IDX_SEARCH’:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘INDEX IDX_SEARCH TO maufj_IDX_SEARCH’ at line 1”} {“hostname”:“cloud.ihserver.com.br”,“pid”:1943154}
Your problem
My problem is :
I’m trying to finish the Upgrade to 4.4.1 and I get this error.
Steps I have tried to fix the problem :
I already clean cache, force migrate, etc.