summaryrefslogtreecommitdiff
path: root/includes/pages
diff options
context:
space:
mode:
authorAndrej Rode <mail@andrejro.de>2017-08-16 00:45:56 +0200
committerAndrej Rode <mail@andrejro.de>2017-08-16 00:45:56 +0200
commit5f305121a4fb6a21bedcd82d845909aed38cec0c (patch)
tree62c20ac393b03e30458abae6dad688d8e53ec641 /includes/pages
parentdc6fb49f44c12e2bc354d7355d5cd903017568e9 (diff)
fix order by not in select clause for >mysql-5.7
Diffstat (limited to 'includes/pages')
-rw-r--r--includes/pages/user_shifts.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/includes/pages/user_shifts.php b/includes/pages/user_shifts.php
index c990ee4a..30f129c7 100644
--- a/includes/pages/user_shifts.php
+++ b/includes/pages/user_shifts.php
@@ -89,7 +89,7 @@ function load_days() {
$days = sql_select_single_col("
SELECT DISTINCT DATE(FROM_UNIXTIME(`start`)) AS `id`, DATE(FROM_UNIXTIME(`start`)) AS `name`
FROM `Shifts`
- ORDER BY `start`");
+ ORDER BY `id`, `name`");
if (count($days) == 0) {
error(_("The administration has not configured any shifts yet."));
redirect('?');