The pager_query() function only searches and replaces on 'FROM' and thereby triggers on FROM_UNIXTIME when creating a count_query. The replace expression should include the space after 'FROM'. Attached a patch fixing this.

CommentFileSizeAuthor
pager.fixfrom.patch.txt531 bytesgorgen

Comments

killes@www.drop.org’s picture

killes@www.drop.org commented
Version: 4.7.3 » x.y.z
Status: Active » Needs review

Looks good to me, needs some testing. Will backport once committed to HEAD.

drumm’s picture

drumm
he/him
Location NY, US
commented
Status: Needs review » Fixed

Committed to HEAD.

Please note that FROM_UNIXTIME() is not recommended since it does not account for Drupal's timezone handling.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)