V6.0.0 Upgrade- Error when creating or editing forms

[raramuridesign]

Hi Team,
We have upgraded to mautic 6.0.0, previous version the latest in v5 series.
PHP 8.2.x

When we try to access forms, editing, we get this error.

[2025-03-27T11:06:35.248493+00:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.is_read_only' in 'SELECT'" at /home/abmovers/webapps/go300/public/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 67 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.is_read_only' in 'SELECT' at /home/abmovers/webapps/go300/public/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.is_read_only' in 'SELECT' at /home/abmovers/webapps/go300/public/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.is_read_only' in 'SELECT' at /home/abmovers/webapps/go300/public/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)"} {"hostname":"xxxxxx.xxxxxxx.net","pid":2913924}

There has been no issue with db migrations - everything is present.

Any idea what the issue is.
Matthew

[rcheesley]

Hi Matthew,

When you did the install, did you run all the required migrations?

Specifically, this is the migration for creating that table field:

Form field add readonly behaviour

app/migrations/Version20241227065658.php

[raramuridesign]

@rcheesley Yes we did…Is it possible to run that manually ? If yes how.
Matthew

[raramuridesign]

@rcheesley I ran this command manually on the database and it fixed the issue. Thanks for the info.

ALTER TABLE form_fields
ADD COLUMN is_read_only TINYINT(1) DEFAULT 0;

or direct cli command

php bin/console doctrine:migrations:migrate “Mautic\Migrations\Version20241227065658” --env=prod

[raramuridesign]

@rcheesley I just ran the migrations and it does not run the one you have listed. It would be helpful to know this and understand these migrations to the database in more detail. Even perhaps mentioning this in the update info when a release is set.
Offering an alternate way of doing this would also be useful

How do you run an individual migration?
Matthew