Analytics: HTTP requests for the first byte are not ignored

[uduerholz]

Expected behavior

The database table podlove_downloadintentclean does not contain rows with httprange of one or two bytes
(as described in the documentation).

Actual behavior

The database table podlove_downloadintentclean contains rows with httprange of one or two bytes.

System information

PHP Version 7.4.24
WordPress Version 5.8.1
Active Plugins
- Podlove Podcast Publisher v3.6.1
- Podlove Subscribe Button v1.3.7
- Podlove Web Player v5.4.14
- ...
Publisher Version 3.6.1
Publisher Database Version 152
Web Player Version player_v5
Monolog Version 1
open_basedir ok
curl Version 7.64.0

Suggested fix:

Correct the SQL query in lib/jobs/download_intent_cleanup_job.php:

@ -110,7 +110,7 @@ class DownloadIntentCleanupJob

<<   AND (di.httprange != 'bytes=0-0' OR di.httprange != 'bytes=0-1' OR httprange IS NULL) -- filter out 1 byte requests; allow requests with empty httprange
>>   AND ((di.httprange != 'bytes=0-0' AND di.httprange != 'bytes=0-1') OR di.httprange IS NULL) -- filter out 1 byte requests; allow requests with empty httprange