@Hiradur opened this Issue on November 7th 2022

Expected Behavior

When I invite a new matomo user, an invitation should be sent via email.

Current Behavior

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'

Possible Solution

Is this caused by a missing DB migration?

Steps to Reproduce (for Bugs)

  1. go to Administration menu
  2. go to System -> Users menu
  3. click the Invite New User button
  4. enter user details
  5. click Invite User button
  6. 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.

Your Environment

  • Matomo Version: 4.12.3
  • PHP Version: 7.4.19
  • Server Operating System: Red Hat Enterprise Linux 8.6 (SELinux in enforcing mode)
  • Additionally installed plugins:
    • HeatmapSessionRecordings
    • FormAnalytics
  • Browser: Firefox 102.4.0esr
  • Operating System: Debian GNU/Linux 11
@sgiehl commented on November 7th 2022 Member

Hi @Hiradur
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 option_value to 4.10.0 where the option_name is version_core. That way Matomo should automatically try to trigger the updates after Matomo 4.10.

@Hiradur commented on November 20th 2022

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.

This Issue was closed on November 7th 2022
Powered by GitHub Issue Mirror