Item previous/next not working

[Blokkendoos]

Description
The next/previous buttons are active but lack the link to the appropriate item. Clicking the button goes back to the album.
Expected: pressing next or previous button goes to the next or previous item.

Details
gallery3-master
Raspbian 13 (Trixie)
Apache 2.4.66
PHP 8.4.16

Workaround
The latest commit where this was still working: #7b71247e
Not working as of: #c2a70520
Reverting a small part of commit #c2a70520, in system/libraries/Database_Mysqli_Result.php, solves this issue:

/**
	 * SeekableIterator: seek
	 */
	public function seek($offset): bool
	{
		if ($this->offsetExists($offset) AND $this->result->data_seek($offset))
		{
			// Set the current row to the offset
			$this->current_row = $offset;
            return TRUE;
		}
        else
        {
            return FALSE;
        }

If this is correct, I can raise a PR.

Thanks for keeping Gallery3 running!