Index: trunk/core/kernel/db/dblist.php =================================================================== diff -u -r8388 -r8402 --- trunk/core/kernel/db/dblist.php (.../dblist.php) (revision 8388) +++ trunk/core/kernel/db/dblist.php (.../dblist.php) (revision 8402) @@ -350,6 +350,14 @@ $sql = $q.' '.$this->Conn->getLimitClause($this->Offset,$limit); $this->Records = $this->Conn->Query($sql); + + if (!$this->Records && ($this->Page > 1)) { + // no records & page > 1, try to reset to 1st page (works only when list in not counted before) + $this->Application->StoreVar($this->getPrefixSpecial().'_Page', 1); + $this->SetPage(1); + $this->Query($force); + } + $this->SelectedCount = count($this->Records); if (!$this->Counted) $this->RecordsCount = $this->SelectedCount; if (!$this->Counted && $this->SelectedCount > $this->PerPage && $this->PerPage != -1) $this->SelectedCount--;