Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Matomo 4 migration: Index column size too large #16811

Closed
Findus23 opened this issue Nov 26, 2020 · 2 comments · Fixed by #16826
Closed

Matomo 4 migration: Index column size too large #16811

Findus23 opened this issue Nov 26, 2020 · 2 comments · Fixed by #16826
Assignees
@sgiehl
Labels
Can't reproduce (yet) For issues that are reported by several people, but can't be reproduced reliably and need more data Regression Indicates a feature used to work in a certain way but it no longer does even though it should.
Milestone
4.0.2

Comments

@Findus23
Copy link
Member

reported in https://forum.matomo.org/t/fehler-bei-installation-in-strato-hosting-paket/39480

SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes.

PHP-Version 7.2 and MySQL-Version 5.6.
@Findus23 Findus23 added the Regression Indicates a feature used to work in a certain way but it no longer does even though it should. label Nov 26, 2020
@Findus23 Findus23 added this to the 4.0.1 milestone Nov 26, 2020
@sgiehl
Copy link
Member

sgiehl commented Nov 26, 2020

Guess that is related to the utf8mb4 changes, but without knowing which table actually produces the error it's hard looking it up.
Looked through the database definitions, but couldn't find anything obvious. Asked on the forum for more input. If that doesn't help quickly will need to setup a database without utf8mb4 support and install Matomo on it.

@Findus23 Findus23 added the Can't reproduce (yet) For issues that are reported by several people, but can't be reproduced reliably and need more data label Nov 26, 2020
@tsteur
Copy link
Member

tsteur commented Nov 26, 2020

It seems to be the matomo_archive_invalidations table @sgiehl see forum. Anything we can do here?

@tsteur tsteur modified the milestones: 4.0.1, 4.0.2 Nov 26, 2020
@sgiehl sgiehl self-assigned this Nov 27, 2020
@sgiehl sgiehl mentioned this issue Nov 27, 2020
Merged
9 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@sgiehl sgiehl

Labels
Can't reproduce (yet) For issues that are reported by several people, but can't be reproduced reliably and need more data Regression Indicates a feature used to work in a certain way but it no longer does even though it should.
Projects
None yet
Milestone
4.0.2
Development

Successfully merging a pull request may close this issue.

Adjust archive_invalidations index matomo-org/matomo
3 participants
@tsteur @sgiehl @Findus23