Error with Pagination using Node.js

Using Wappler v3.9.7 on a mac with Node.js and SQL Server database.

It’s been a little while since I’ve done pagination, so it’s possible I’m doing something wrong.
I get an error 500 when I click a sortable header or a pagination link on a table where I have added pagination.

So If I create a table from the table generator with just sortable headers, it works fine. I convert my server action to a paged query, add the offset to my query manager, add the pagination and when the page initially loads, the server action is successful. However when I click on any query parameter such as a sortable header or pagination I get this error:

Here is my Server Action:

Query Manager:

Server Connect:

Any ideas what is happening? Has anyone else had this problem?

Thanks,
Chris

Community Page
Last updated: