>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #3630926. --> Reported by: [sgalata](https://www.drupal.org/user/3593430) Related to !253 >>> <h3 id="summary-problem-motivation">Problem/Motivation</h3> <p><code>UrlToEntity::findEntityIdByUrl()</code> lowercases the entire URL. Hostnames are case-insensitive, but managed-file paths are not. With Drupal 11.4.4 and Entity Usage 5.0.1, a file whose URI is <code>public://example/MixedCase.pdf</code> is not found by the resulting lookup for <code>public://example/mixedcase.pdf</code>. Current 5.x source has the same normalization.</p> <p>An ordinary HTML hyperlink in a saved draft therefore produces no <code>html_link</code> reference, although the exact file URL returns 200. Consumers of usage data may consequently delete a still-linked file: Media File Delete's Entity Usage integration can remove the file during bulk media deletion after removing the media's own references.</p> <p>This differs from Media File Delete's duplicate media-usage issue <a href="https://www.drupal.org/project/media_file_delete/issues/3538455">#3538455</a>. Related Entity Usage issues <a href="https://www.drupal.org/project/entity_usage/issues/3521603">#3521603</a> and <a href="https://www.drupal.org/project/entity_usage/issues/3537701">#3537701</a> address public-file patterns, not whole-URL lowercasing; their fixes do not resolve this reproduction.</p> <h4 id="summary-steps-reproduce">Steps to reproduce</h4> <ol> <li>On a disposable local site, enable Entity Usage with nodes as sources, files as targets, and HTML links enabled.</li> <li>Create a managed PDF with URI <code>public://example/MixedCase.pdf</code>. Verify the stored filename retains capitalization.</li> <li>Save an unpublished node with a formatted body containing a plain anchor, without media embedding or LinkIt metadata: <code>&amp;lt;a href="http://localhost/sites/default/files/example/MixedCase.pdf"&amp;gt;PDF&amp;lt;/a&amp;gt;</code>.</li> <li>Verify the exact URL returns 200.</li> <li>Call <code>findEntityIdByUrl()</code> on the <code>Drupal\entity_usage\UrlToEntityInterface</code> service and inspect the file's Entity Usage sources.</li> <li>Observe NULL resolution and no node/body hyperlink source. A wholly lowercase directory/filename control resolves and tracks correctly.</li> </ol> <p>Optional integration reproduction: create Document media referencing that disposable file, then use the actual Media listing to bulk-delete only that media with associated-file deletion selected. The file can be removed although the saved draft still links to it. A single-delete retention message is not sufficient proof, because duplicate media usage can mask the missing hyperlink.</p> <h3 id="summary-proposed-resolution">Proposed resolution</h3> <ul> <li>Preserve path and filename capitalization in the shared URL resolver.</li> <li>Compare parsed hostnames case-insensitively in SiteDomains; preserve configured and discovered base paths, including public stream-wrapper paths and the legacy domain conversion.</li> <li>In the public-file integration, compare scheme and hostname case-insensitively while matching paths case-sensitively. Derive the managed URI from the URL path alone, excluding query/fragment suffixes. Decode path escapes with rawurldecode() so literal plus signs remain plus signs.</li> <li>Keep exact URI queries. Files named MixedCase.pdf and mixedcase.pdf must resolve to distinct IDs. Do not rename files or rewrite stored content.</li> </ul> <p>The prepared fix extends the existing kernel file-tracking test with real managed files and saved plain HTML fields. Coverage includes absolute/root-relative/relative links, uppercase hostnames and schemes, encoded spaces/plus signs, query/fragment suffixes, filenames differing only by case, wrong-case directories, external-host rejection, and a non-local wrapper exposing a mixed-case CDN base path. Only the external wrapper URL is stubbed; entity storage, queries and URL resolution are real. Additional focused checks cover SiteDomains and legacy config conversion.</p> <p>The managed-file regression fails without the fix at MixedDirectory/MixedCase.pdf (NULL resolution) and passes with it. Focused checks: 55 tests, 253 assertions passing. A real local bulk-delete smoke test retained the saved draft's mixed-case file (entity and disk present, HTTP 200), while deleting an unreferenced lowercase control (entity and disk absent, HTTP 404). Retention was backed by actual node/body html_link sources, with no remaining media or core file-usage entries.</p> <h3 id="summary-remaining-tasks">Remaining tasks</h3> <p>Review, CI, merge and release. After deployment, rebuild existing usage statistics on each site with <code>drush entity-usage:recreate</code> or <code>/admin/config/entity-usage/batch-update</code>. Avoid file deletion during rebuilds. Installing the fix alone does not repair previously missed references.</p> <h3 id="summary-ui-changes">User interface changes</h3> <p>None.</p> <h3 id="summary-api-changes">API changes</h3> <p>SiteDomains::getInternalUrl() no longer requires lowercased input. It preserves path capitalization and compares hosts case-insensitively. Wrong-case base paths no longer match.</p> <h3 id="summary-data-model-changes">Data model changes</h3> <p>No schema changes.</p> <p>Disclosure: AI-assisted investigation and coding, verified with executable regression and local integration checks. Examples are synthetic localhost fixtures. This is incorrect reference recognition during authorized deletion, not an identified access-control bypass.</p>