# Moving Mautic 3

**URL:** <https://forum.mautic.org/t/moving-mautic-3/27877>\
**Category:** Mautic 3 - Install/Upgrade Support\
**Created:** [May 2, 2023, 11:53am UTC](https://forum.mautic.org/t/moving-mautic-3/27877 "2023-05-02T11:53:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mjfa](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mjfa/32/8118_2.png) [@mjfa](https://forum.mautic.org/u/mjfa)\
**Post date:** [May 2, 2023, 11:53am UTC](https://forum.mautic.org/t/moving-mautic-3/27877/1 "2023-05-02T11:53:44Z")

</div>

**Your software**  
_My PHP version is_ : 7.3.33

**Updating/Installing Errors**  
Moving Mautic 3.1.1

_These errors are showing in the Mautic log_ :

[2023-05-02 12:41:02] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: “An exception occurred while executing ‘SELECT x.lead\_id, x.alias, v.value FROM ( SELECT l.id AS lead\_id, f.id as lead\_field\_id, f.alias FROM office\_leads l CROSS JOIN office\_lead\_fields f WHERE f.object IN (‘extendedField’,‘extendedFieldSecure’) AND l.id IN (247) ) x LEFT JOIN ( SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_string\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL UNION SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_string\_secure\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL UNION SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_float\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL UNION SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_float\_secure\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL UNION SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_boolean\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL UNION SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_boolean\_secure\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL UNION SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_date\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL UNION SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_date\_secure\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL UNION SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_datetime\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL UNION SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_datetime\_secure\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL UNION SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_time\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL UNION SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_time\_secure\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL UNION SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_text\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL UNION SELECT lead\_id, lead\_field\_id, `value` FROM office\_lead\_fields\_leads\_text\_secure\_xref WHERE lead\_id IN (247) AND `value` IS NOT NULL ) v USING (lead\_id, lead\_field\_id) WHERE v.value IS NOT NULL’: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘officecrm2023-3230347f2b.office\_lead\_fields\_leads\_string\_xref’ doesn’t exist” at /home/virtual/vps-cf59a6/d/dc198fddb2/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 42 {“exception”:“[object] (Doctrine\DBAL\Exception\TableNotFoundException(code: 0): An exception occurred while executing ‘SELECT x.lead\_id, x.alias, v.value\nFROM\n(\n SELECT l.id AS lead\_id,\n f.id as lead\_field\_id,\n f.alias\n FROM office\_leads l CROSS JOIN office\_lead\_fields f\n WHERE f.object IN (‘extendedField’,‘extendedFieldSecure’) \n AND l.id IN (247)\n) x\nLEFT JOIN\n(\n SELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_string\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\nUNION\nSELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_string\_secure\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\nUNION\nSELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_float\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\nUNION\nSELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_float\_secure\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\nUNION\nSELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_boolean\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\nUNION\nSELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_boolean\_secure\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\nUNION\nSELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_date\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\nUNION\nSELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_date\_secure\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\nUNION\nSELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_datetime\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\nUNION\nSELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_datetime\_secure\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\nUNION\nSELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_time\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\nUNION\nSELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_time\_secure\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\nUNION\nSELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_text\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\nUNION\nSELECT lead\_id, lead\_field\_id, `value`\nFROM office\_lead\_fields\_leads\_text\_secure\_xref\nWHERE lead\_id IN (247)\nAND `value` IS NOT NULL\n) v USING (lead\_id, lead\_field\_id)\nWHERE v.value IS NOT NULL’:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table ‘officecrm2023-3230347f2b.office\_lead\_fields\_leads\_string\_xref’ doesn’t exist at /home/virtual/vps-cf59a6/d/dc198fddb2/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:42, Doctrine\DBAL\Driver\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘officecrm2023-3230347f2b.office\_lead\_fields\_leads\_string\_xref’ doesn’t exist at /home/virtual/vps-cf59a6/d/dc198fddb2/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘officecrm2023-3230347f2b.office\_lead\_fields\_leads\_string\_xref’ doesn’t exist at /home/virtual/vps-cf59a6/d/dc198fddb2/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)”}

**Your problem**  
The contacts screen with all the contacts in it does not show anything…

Tried updating from 3 to 3.1.1

---

<div class="post-metadata">

**Author:** ![mjfa](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mjfa/32/8118_2.png) [@mjfa](https://forum.mautic.org/u/mjfa)\
**Post date:** [May 3, 2023, 8:11am UTC](https://forum.mautic.org/t/moving-mautic-3/27877/2 "2023-05-03T08:11:47Z")

</div>

Does anyone have a clue on this one please?

---

<div class="post-metadata">

**Author:** ![shunshifu](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/shunshifu/32/12482_2.png) [@shunshifu](https://forum.mautic.org/u/shunshifu)\
**Post date:** [August 10, 2024, 2:53pm UTC](https://forum.mautic.org/t/moving-mautic-3/27877/3 "2024-08-10T14:53:56Z")

</div>

I know this is old but I’ll add what I know.

We have the same problem and I believe this is due to the extended fields add on, Which I see in your logs.