Author: pashev.igor
Description:
ActiveUsers page does not work with Postgres (includes/specials/SpecialActiveusers.php):
Jul 07 13:15:21 xxx postgres[1234]: ERROR: non-integer constant in ORDER BY at character 361
Jul 07 13:15:21 xxx postgres[1234]: STATEMENT: SELECT rc_user_text,MAX(rc_timestamp) AS lastedittime FROM "recentchanges" WHERE (rc_user > 0) AND (rc_type != '5') AND (rc_log_type IS NULL OR rc_log_type != 'newusers') AND (rc_timestamp >= '2014-06-07 13:15:21 GMT') AND (rc_timestamp <= '2014-07-07 13:15:21 GMT') GROUP BY rc_user_text ORDER BY NULL
This bug is introduced by https://git.wikimedia.org/commit/mediawiki%2Fcore.git/87be24dbdf8235e381110393011b86e0f5be395f
Version: 1.23.1
Severity: major
OS: Linux