maintenance:mimetype:update-db --repair-filecache not repairing filecache

[PotcFdk]

Steps to reproduce

run occ maintenance:mimetype:update-db --repair-filecache

Expected behaviour

Files ending in .extension should have their mimetype field set to the configured one.

Actual behaviour

The field is left untouched, because the SQL queries that run are generated by this line

core/lib/private/Files/Type/Loader.php

Line 172 in 6b36c56

$update->createFunction('LOWER(`name`)'), $update->createNamedParameter($ext)

and end up looking like [...] WHERE [...] (LOWER(name) LIKE 'extension') (note the field name contains the full file name, not just the extension, so this query doesn't match any rows).

I don't really have a good overview regarding the source code, so I can't tell why it's not using this logic here, which looks more correct. Maybe I might be missing something; but why is this implemented twice in different places?:

core/lib/private/Repair/RepairMimeTypes.php

Line 153 in 6b36c56

\OC_DB::executeAudited(self::updateByNameStmt(), [$mimetypeId, $this->folderMimeTypeId, $mimetypeId, '%.' . $extension]);

Server configuration

Operating system: Ubuntu
Database: MariaDB
ownCloud version: 10.0.8

[ownclouders]

GitMate.io thinks the contributor most likely able to help you is @PVince81.

Possibly related issues are #20661 (Update), #21366 (Update), #27585 (mimetype:update-db changes a folder to "audio/*"), #22729 (Improve mimetype repair performance), and #24430 (Maintenance mode).

[PotcFdk]

Note that this issue was fixed in Nextcloud a long time ago nextcloud/server@65efb38#diff-9ff70cb4d5b322bf49c1c086f8903219

[ownclouders]

Hey, this issue has been closed because the label status/STALE is set and there were no updates for 7 days. Feel free to reopen this issue if you deem it appropriate.

(This is an automated comment from GitMate.io.)

[PotcFdk]

Not fixed yet, please reopen.