# Cannot see Contact Information after update **URL:** \ **Category:** Mautic 4 Install/Upgrade Support\ **Created:** [February 19, 2022, 4:25am UTC](https://forum.mautic.org/t/cannot-see-contact-information-after-update/22761 "2022-02-19T04:25:08Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![ygorpovoa](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ygorpovoa/32/6635_2.png) [@ygorpovoa](https://forum.mautic.org/u/ygorpovoa)\ **Post date:** [February 19, 2022, 4:25am UTC](https://forum.mautic.org/t/cannot-see-contact-information-after-update/22761/1 "2022-02-19T04:25:09Z")
**Your software** Mautic 4.1.2 _My PHP version is_ : 7.4.26 _My MySQL/MariaDB version is_ (delete as applicable): mysqlnd 7.4.26 **Updating/Installing Errors** _I am_ : Updating _Upgrading/installing via_: Command Line _These errors are showing in the installer_ : no errors were shown _These errors are showing in the Mautic log_ : [2022-02-19 01:23:44] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t0.id AS id\_1, t0.label AS label\_2, t0.show\_label AS show\_label\_3, t0.alias AS alias\_4, t0.type AS type\_5, t0.is\_custom AS is\_custom\_6, t0.custom\_parameters AS custom\_parameters\_7, t0.default\_value AS default\_value\_8, t0.is\_required AS is\_required\_9, t0.validation\_message AS validation\_message\_10, t0.help\_message AS help\_message\_11, t0.field\_order AS field\_order\_12, t0.properties AS properties\_13, t0.validation AS validation\_14, t0.parent\_id AS parent\_id\_15, t0.conditions AS conditions\_16, t0.label\_attr AS label\_attr\_17, t0.input\_attr AS input\_attr\_18, t0.container\_attr AS container\_attr\_19, t0.lead\_field AS lead\_field\_20, t0.save\_result AS save\_result\_21, t0.is\_auto\_fill AS is\_auto\_fill\_22, t0.show\_when\_value\_exists AS show\_when\_value\_exists\_23, t0.show\_after\_x\_submissions AS show\_after\_x\_submissions\_24, t0.always\_display AS always\_display\_25, t0.form\_id AS form\_id\_26 FROM form\_fields t0 WHERE t0.form\_id = ? ORDER BY t0.field\_order ASC’ with params [4]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.parent\_id’ in ‘field list’” at /home/u270484841/domains/cristinadurante.com.br/public\_html/mail/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT t0.id AS id\_1, t0.label AS label\_2, t0.show\_label AS show\_label\_3, t0.alias AS alias\_4, t0.type AS type\_5, t0.is\_custom AS is\_custom\_6, t0.custom\_parameters AS custom\_parameters\_7, t0.default\_value AS default\_value\_8, t0.is\_required AS is\_required\_9, t0.validation\_message AS validation\_message\_10, t0.help\_message AS help\_message\_11, t0.field\_order AS field\_order\_12, t0.properties AS properties\_13, t0.validation AS validation\_14, t0.parent\_id AS parent\_id\_15, t0.conditions AS conditions\_16, t0.label\_attr AS label\_attr\_17, t0.input\_attr AS input\_attr\_18, t0.container\_attr AS container\_attr\_19, t0.lead\_field AS lead\_field\_20, t0.save\_result AS save\_result\_21, t0.is\_auto\_fill AS is\_auto\_fill\_22, t0.show\_when\_value\_exists AS show\_when\_value\_exists\_23, t0.show\_after\_x\_submissions AS show\_after\_x\_submissions\_24, t0.always\_display AS always\_display\_25, t0.form\_id AS form\_id\_26 FROM form\_fields t0 WHERE t0.form\_id = ? ORDER BY t0.field\_order ASC’ with params [4]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.parent\_id’ in ‘field list’ at /home/u270484841/domains/cristinadurante.com.br/public\_html/mail/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.parent\_id’ in ‘field list’ at /home/u270484841/domains/cristinadurante.com.br/public\_html/mail/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.parent\_id’ in ‘field list’ at /home/u270484841/domains/cristinadurante.com.br/public\_html/mail/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"} **Your problem** _My problem is_ : I cannot see contacts/leads details on my mautic. _Steps I have tried to fix the problem_ : I tried clearing the cache only, but it didn’t work. Thanks in advance for anyone trying to help me. 🙂 ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [February 19, 2022, 12:13pm UTC](https://forum.mautic.org/t/cannot-see-contact-information-after-update/22761/2 "2022-02-19T12:13:12Z")
It looks like migrations were not successful. Please check your migration status with: `php bin/console doctrine:migrations:status` You might want to make sure all migrations have been executed. As a side note: When you installing php dependencies make sure that script exit OK, a while ago during the migration to Mautic 4 I was not able to use contacts because dependencies have not been fully installed. Regards, M. ---
**Author:** ![notsotechy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/notsotechy/32/8095_2.png) [@notsotechy](https://forum.mautic.org/u/notsotechy)\ **Post date:** [August 15, 2022, 5:29pm UTC](https://forum.mautic.org/t/cannot-see-contact-information-after-update/22761/3 "2022-08-15T17:29:47Z")
hi I upgraded from mautic 3 to 4.4.1 and it timed out due to my php settings (which i have now fixed) but when i try to manually trigger the update now i get these errors ``` -> ALTER TABLE `m3_lead_event_log` RENAME INDEX `IDX_SEARCH` TO `m3_IDX_SEARCH` ``` Migration 20201125155904 failed during Execution. Error An exception occurred while executing ‘ALTER TABLE `m3_lead_event_log` RENAME INDEX `IDX_SEARCH` TO `m3_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 `m3_IDX_SEARCH`’ at line 1 In AbstractMySQLDriver.php line 98: An exception occurred while executing ‘ALTER TABLE `m3_lead_event_log` RENAME INDEX `IDX_SEARCH` TO `m3_IDX_SE ARCH`’: 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 `m3_I DX_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 corresponds to your MariaDB server version for the right syntax to use near ‘INDEX `IDX_SEARCH` TO `m3_I DX_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 corresponds to your MariaDB server version for the right syntax to use near ‘INDEX `IDX_SEARCH` TO `m3_I DX_SEARCH`’ at line 1 can someone please suggest a solution / next step? thank you this is the error in the database [2022-08-15 13:39:05] mautic.WARNING: Command `doctrine:migrations:migrate` exited with status code 1 {“hostname”:“(MASKED).com”,“pid”:31392} and also when i run the status command, here is what i see php bin/console doctrine:migration:status == Configuration ``` >> Name: Mautic Migrations >> Database Driver: pdo_mysql >> Database Host: localhost >> Database Name: user1234 >> Configuration Source: manually configured >> Version Table Name: m3_migrations >> Version Column Name: version >> Migrations Namespace: Mautic\Migrations >> Migrations Directory: /home/(MASKED).com/user123/public_html/app/migrations >> Previous Version: 2021-02-03 14:36:00 (20210203143600) >> Current Version: 2021-02-23 17:47:02 (20210223174702) >> Next Version: 2021-05-02 16:23:14 (20210502162314) >> Latest Version: 2022-01-11 20:29:17 (20220111202917) >> Executed Migrations: 37 >> Executed Unavailable Migrations: 0 >> Available Migrations: 47 >> New Migrations: 10 ``` ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [August 15, 2022, 5:53pm UTC](https://forum.mautic.org/t/cannot-see-contact-information-after-update/22761/4 "2022-08-15T17:53:06Z")
I would try to restore mautic version 3 from backup and run the migration again. Migration process probably stuck somewhere in the middle so now there are all these errors. I would guess. ---
**Author:** ![notsotechy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/notsotechy/32/8095_2.png) [@notsotechy](https://forum.mautic.org/u/notsotechy)\ **Post date:** [August 15, 2022, 6:03pm UTC](https://forum.mautic.org/t/cannot-see-contact-information-after-update/22761/5 "2022-08-15T18:03:46Z")
I restored back to version 3.3.5 but now when i try to run the update through CLI i get this error [2022-08-15 14:50:24] mautic.NOTICE: Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing ‘ALTER TABLE `m3_lead_event_log` RENAME INDEX `IDX_SEARCH` TO `m3_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 `m3_IDX_SEARCH`’ at line 1 (uncaught exception) at /home/MASKED.com/MASKED/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 98 while running console command `doctrine:migrations:migrate` {“hostname”:“[MASKED.com](http://MASKED.com)”,“pid”:19074} this is the same problem i had when updating from the app on the web any idea how to fix this? ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [August 16, 2022, 7:26am UTC](https://forum.mautic.org/t/cannot-see-contact-information-after-update/22761/6 "2022-08-16T07:26:22Z")
If you did not have problems with migrations before and migrations failed only because of timeout, this leads me to believe that database has not been restored. Second thing… if (I am mistaken) you did revert source AND database to a a previous version. Look into migration that is failing and try to achieve manually what the migration script does. Also investigate the current database schema before you run anything. ---
**Author:** ![notsotechy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/notsotechy/32/8095_2.png) [@notsotechy](https://forum.mautic.org/u/notsotechy)\ **Post date:** [August 16, 2022, 3:03pm UTC](https://forum.mautic.org/t/cannot-see-contact-information-after-update/22761/7 "2022-08-16T15:03:00Z")
Yeah when i restored it went back to the previous database and files, so everything is working now, but when i try to upgrade from cli i still get the same errors as above. not sure how to resolve so ill keep using 3.3.5 for now ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [August 16, 2022, 6:38pm UTC](https://forum.mautic.org/t/cannot-see-contact-information-after-update/22761/8 "2022-08-16T18:38:47Z")
If you want I can look into it in scope of my paid services. Drop me a private message if you are up for it :). ---
**Author:** ![steverobinson](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/steverobinson/32/174_2.png) [@steverobinson](https://forum.mautic.org/u/steverobinson)\ **Post date:** [August 17, 2022, 11:44pm UTC](https://forum.mautic.org/t/cannot-see-contact-information-after-update/22761/9 "2022-08-17T23:44:01Z")
> [@notsotechy](#): > > RENAME INDEX You said you’re running MySQL version 7.4, but that’s php, not MySQL. This looks like you might be running a very old version my MySQL or MariaDB. Either way, check your database version and the version of the database listed in your /app/config/local.php file. Mautic may be trying to run a command that’s not available in your current version of MySQL or MariaDB. ---
**Author:** ![notsotechy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/notsotechy/32/8095_2.png) [@notsotechy](https://forum.mautic.org/u/notsotechy)\ **Post date:** [August 18, 2022, 4:34am UTC](https://forum.mautic.org/t/cannot-see-contact-information-after-update/22761/10 "2022-08-18T04:34:31Z")
I got MariaDB 10.2 is that too old?