--- trunk/lib/BackupPC/SearchLib.pm 2005/08/21 15:59:55 62 +++ trunk/lib/BackupPC/SearchLib.pm 2005/08/21 17:08:55 64 @@ -32,6 +32,7 @@ sub epoch_to_iso { my $t = shift || return; + $t += 60 * 60 * +2; # FIXME add TZ my $dt = DateTime->from_epoch( epoch => $t ) || return; print STDERR "BUG: $t != " . $dt->epoch . "\n" unless ($t == $dt->epoch); return $dt->ymd . ' ' . $dt->hms; @@ -115,7 +116,7 @@ $sql_where = " WHERE ". $where if ($where); my $sql_order = qq{ - ORDER BY files.id + ORDER BY files.date LIMIT $on_page OFFSET ? };