# RENAME INDEX IDX\_SEARCH

**URL:** <https://forum.mautic.org/t/rename-index-idx-search/25174>\
**Category:** Mautic 4 Install/Upgrade Support\
**Created:** [August 25, 2022, 4:02am UTC](https://forum.mautic.org/t/rename-index-idx-search/25174 "2022-08-25T04:02:49Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![llittlecharlie](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/llittlecharlie/32/6653_2.png) [@llittlecharlie](https://forum.mautic.org/u/llittlecharlie)\
**Post date:** [August 25, 2022, 4:02am UTC](https://forum.mautic.org/t/rename-index-idx-search/25174/1 "2022-08-25T04:02:49Z")

</div>

**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.