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