Contrib.social

User Agent Strings not matching

Open on Drupal.org →
Created on 10 January 2020, about 5 years ago
Updated 15 March 2024, 11 months ago

I'm not sure why this is happening, or if this is new, but I'm seeing Browscap files coming in with "applewebkit" in lower case, which leads to no matches for WHERE :useragent LIKE useragent. The only match ends up being to the useragent '%'.

This patch fixes changes the above SQL to the following: WHERE LOWER(:useragent) LIKE LOWER(useragent).

🐛 Bug report
Status

Fixed

Component

Code

Created by

🇺🇸United States arnaldop St Cloud, FL

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024