[Bug] MySQL Update to 5.0.0: The storage engine for the table doesn't support descending indexes #21729
Description
What happened?
Updates failes with error.
What should happen?
Update to 5.0.0
How can this be reproduced?
- MySQL: 8.0.35-0ubuntu0.22.04.1
- Update to Matomo 5.0.0
Matomo version
4.16.0
PHP version
No response
Server operating system
No response
What browsers are you seeing the problem on?
No response
Computer operating system
No response
Relevant log output
Executing ALTER TABLE `piwik_log_visit` ADD INDEX `index_idsite_idvisitor_time` (`idsite`, `idvisitor`, `visit_last_action_time` DESC);...
[X] Critical Error during the update process:
* /var/www/html/matomo-01/core/Updates/5.0.0-b1.php:
Error trying to execute the migration 'ALTER TABLE `piwik_log_visit` ADD INDEX `index_idsite_idvisitor_time` (`idsite`, `idvisitor`, `visit_last_action_time` DESC);'.
The error was: SQLSTATE[42000]: Syntax error or access violation: 1178 The storage engine for the table doesn't support descending indexes
### Validations
- [X] Read our [Contributing Guidelines](https://github.com/matomo-org/matomo/blob/5.x-dev/CONTRIBUTING.md).
- [X] Follow our [Security Policy](https://github.com/matomo-org/matomo/blob/5.x-dev/SECURITY.md).
- [X] Check that there isn't already an issue that reports the same bug to avoid creating duplicates.
- [X] The provided steps to reproduce is a [minimal reproducible](https://stackoverflow.com/help/minimal-reproducible-example) of the Bug.