Use standard SQL (not MySQL-specific extensions) for database support

Created on 6 July 2020, over 4 years ago
Updated 28 June 2024, 5 months ago

Currently the Download Count module uses various MySQL-specific functions (eg FROM_UNIXTIME()) in its queries to group by date etc.

These aren't necessary to function correctly, and break the module for non-MySQL DBs. When Download Count is installed on Postgres or SQLite, the exceptions thrown from failed DB queries will prevent other module crons running too.

Use of engine-specific SQL syntax is (AIUI) discouraged in Drupal contrib. Best docs links I could find at time of writing:

πŸ› Bug report
Status

Needs work

Version

2.1

Component

Code

Created by

πŸ‡³πŸ‡ΏNew Zealand xurizaemon Ōtepoti, Aotearoa 🏝

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

Comments & Activities

Not all content is available!

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

Production build 0.71.5 2024