Page size selection at bottom sometimes takes the user to non existing page

[numberbee7070]

Checklist

• [X] The bug is reproducible against the latest release or master.
• [X] There are no similar issues or pull requests to fix it yet.

Describe the bug

when on last page of items in a table if we increase the no. of items per page it gives 404 error.

Steps to reproduce the bug

Try this have 20 entries in a table added to admin page. Now go to the 2nd page from navigation at bottom. Change the page size from 10/page to 25/page. Site will throw 404 error.

Expected behavior

when selecting page size either the page value should be set so that the first entry is visible on the new page or it should take the user to page 1

Actual behavior

No response

Debugging material

No response

Environment

Python 3.11.8 manjaro linux sqladmin 0.17.0 SQLAlchemy 2.0.29

Additional context

No response