Mautic v4.4.9 shared hosted - errors since update

Product Support
1

Your software
My Mautic version is: v4.4.9
My PHP version is: 8.0.27
My Database type and version is: MariaDB 10.4
Shared hosting without access to ssh

Your problem
My problem is: Multiple errors since update :herb:

When clicking to get contact detail :
he site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.
ystem administrators, check server logs for errors.

When clicking on segment detail (to modify:
nothing happen
Access possible through drop down menu (modify, clone, delete)

When modififying segment :
AĂŻe ! Je pense que je l’ai cassĂ©. Si je le fais Ă  nouveau, merci d’en informer l’administrateur du systĂšme !
500 Internal Server Error

mautic_url /s/update/schema

These errors are showing in the log:
[2023-06-23 01:36:08] 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 jk1f_form_fields t0 WHERE t0.form_id = ? ORDER BY t0.field_order ASC’ with params [8]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.parent_id’ in ‘field list’” at /home/clients/a1d8c1f027d88aca8ca4bd233feaa8e1/sites/mautic_url/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 jk1f_form_fields t0 WHERE t0.form_id = ? ORDER BY t0.field_order ASC’ with params [8]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.parent_id’ in ‘field list’ at /home/clients/a1d8c1f027d88aca8ca4bd233feaa8e1/sites/mautic_url/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/clients/a1d8c1f027d88aca8ca4bd233feaa8e1/sites/mautic_url/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/clients/a1d8c1f027d88aca8ca4bd233feaa8e1/sites/mautic_url/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“h2web238”,“pid”:61276}

Steps I have tried to fix the problem:
Verify : ‘db_driver’ => ‘pdo_mysql’, (was OK)
mautic_url /s/update/schema (KO - error Une erreur est survenue lors de la mise à jour de la base de données. Vérifiez le journal pour plus de détails. )
Upgrade PHP to PHP 8.1 (KO - Deprecated: Return type of SendGrid\ReplyTo::jsonSerialize() should either be compatible with JsonSerializable::jsonSerialize(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/clients/a1d8c1f027d88aca8ca4bd233feaa8e1/sites/mautic_url/vendor/sendgrid/sendgrid/lib/helpers/mail/Mail.php on line 77)

I don’t have access to terminal to cache:clear

It was working fine since 2021 before last update

Thanks for your help

2

Based on error you posted, I would think all migrations were not executed correctly.

I would check the status of migrations. And of course you cant get around mautic without cache clear so access to the terminal is a must at some point (be it for cache clear migration check or something else).

Regards, M.