When I invite a new matomo user, an invitation should be sent via email.
User creation fails after entering the superuser password with
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'invited_by' in 'field list'.
I encountered this issue with version 4.12.1 and upgraded to 4.12.3 today, but it didn't fix the issue. I could successfully create users in the past using older versions of matomo.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'invited_by' in 'field list'
Is this caused by a missing DB migration?
System -> Usersmenu
Invite New Userbutton
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'invited_by' in 'field list'should now be displayed for a brief time
I need to create an account for a new member on our team.
Sorry to hear you are having trouble with the update. It seem the migration of 4.11. were not executed for you for some reason.
The user table should have been changed here: https://github.com/matomo-org/matomo/blob/4.x-dev/core/Updates/4.11.0-rc2.php#L62-L66
Might be hard to find the reason why that didn't work for you.
You can now either try to apply the required changes automatically. Or it might work to update the option table and set the
4.10.0 where the
version_core. That way Matomo should automatically try to trigger the updates after Matomo 4.10.
We discovered that all
version_* rows in the
option table were still at
4.8 (the version we used for the initial install) even though we installed numerous Matomo updates via Ansible in the meantime. We were never prompted in the UI to perform a database upgrade and are not sure why.
We remediated this issue by adding
console core:update --yes to our Ansible role, which should ensure that the DB is always updated after we perform an update via Ansible.