Hi Team @rcheesley
When trying to login I am getting this error, I have checked various tables to see that uuid is there. and they are. Am I missing something else ?
Matthew
[2025-05-01T12:03:15.098596+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 'm1_.uuid' in 'SELECT'" at /home/mautic-ssa/webapps/j3mautic-ssa/public/go/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 'm1_.uuid' in 'SELECT' at /home/mautic-ssa/webapps/j3mautic-ssa/public/go/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 'm1_.uuid' in 'SELECT' at /home/mautic-ssa/webapps/j3mautic-ssa/public/go/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm1_.uuid' in 'SELECT' at /home/mautic-ssa/webapps/j3mautic-ssa/public/go/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)"} {"hostname":"a-srv24-wwm-ubuntu24","pid":459222}
Just a thought, is there a migration which deals with this specifically, if yes, what is the vesion number ?
I searched the GitHub PRs for UUID using this query to find when it was introduced:
6.x ← avikarshasaha:uuid_implementation
opened 09:14AM - 05 Feb 25 UTC
| Q | A
| --------------------------------… ------ | ---
| Bug fix? (use the a.b branch) | 🔴
| New feature/enhancement? (use the a.x branch) | 🟢
| Deprecations? | 🟢
| BC breaks? (use the c.x branch) | 🔴
| Automated tests included? | 🔴
| Related user documentation PR URL | mautic/user-documentation#...
| Related developer documentation PR URL | mautic/developer-documentation-new#...
| Issue(s) addressed | Fixes #...
## Description
UUID implementation. This is necessary for global identification of entities for the campaign library:
https://github.com/mautic/mautic/pull/14504
The UUID will be used to decide whether an entity should be updated or inserted during the import of entities.
---
### 📋 Steps to test this PR:
1. Run `bin/console doctrine:migrations:migrate` to apply the migration.
2. You should see in the changed entities/tables like reports, pages, emails and so on that there is new UUID column in the table with filled in hash.
There was also a PR to fix some issues:
6.x ← dadarya0:uuid-for-role-and-permission
opened 07:30AM - 18 Mar 25 UTC
Cf 583: Copy Roles via RC/GT.
| Q | … A
| -------------------------------------- | ---
| Bug fix? (use the a.b branch) | ❌
| New feature/enhancement? (use the a.x branch) | ✔️
| Deprecations? | ❌
| BC breaks? (use the c.x branch) | ❌
| Automated tests included? | ❌
| Related user documentation PR URL | mautic/user-documentation#...
| Related developer documentation PR URL | mautic/developer-documentation-new#...
| Issue(s) addressed | Fixes #...
## Description
UUID implementation. This is necessary for global identification of entities for the campaign library:
https://github.com/mautic/mautic/pull/14504
The UUID will be used to decide whether an entity should be updated or inserted during the import of entities.
---
### 📋 Steps to test this PR:
1. Open this PR on Gitpod or pull down for testing locally (see docs on testing PRs [here](https://contribute.mautic.org/contributing-to-mautic/tester))
2. Run bin/console doctrine:migrations:migrate to apply the migration.
3. You should see in the changed entities/tables in role and permission and so on that there is new UUID column in the table with filled in hash.
Both were merged in 6.0.0.
In the first PR I found the migration:
app/migrations/Version20210211081531.php
Then there are two migrations in the second one:
app/migrations/Version20210818090322.php
app/migrations/Version20210819201726.php
If you’ve done an upgrade and the migrations were processed, it should have migrated your database and completed the necessary changes.
I alos searched the issue queue for UUID and found this issue: Missing `uuid` field in Lead entity after updating to 6.0.0-rc · Issue #14760 · mautic/mautic · GitHub which was fixed with the later PR:
6.x ← fedys:follow-contact-permissions-when-importing-contacts-2
opened 11:57AM - 04 Feb 25 UTC
| Q | A
| --------------------------------… ------ | ---
| Bug fix? (use the a.b branch) | 🟢
| New feature/enhancement? (use the a.x branch) | 🔴
| Deprecations? | 🔴
| BC breaks? (use the c.x branch) | 🔴
| Automated tests included? | 🟢
| Related user documentation PR URL |
| Related developer documentation PR URL |
| Issue(s) addressed |
## Description
This PR adds permission checks during contact and company imports.
---
### 📋 Steps to test this PR:
1. Create a role that does not have permissions for editing contacts but has permissions to create contacts.
2. Login as a user that has the above role assigned to them.
3. Create a new contact import that contains rows for both inserts and updates.
4. Wait till the import is `imported`.
5. Any CSV rows containing updates should be ignored.
6. There should be error messages like `User '<username>' has insufficient permissions` for all the rows containing updates.
7. Validate that permissions are checked against a user who **last updated a given import**.
8. Validate the above steps for company imports at `/s/companies/import/new`. The company import follows the same `Contact Permissions`. There are no separate `Company Permissions`.
Also released with 6.0.0.