Osx 10.15.5
Wappler 3.0.0 RC3
Node and Postgres local, but same on docker
Getting errors on table sorting and pagination
Standard paged query where I select 3 columns from a table
{status: "500", code: "42803",…}
code: "42803"
message: "select count(*) as "Total" from "rig" order by "r_id" desc limit $1 - column "rig.r_id" must appear in the GROUP BY clause or be used in an aggregate function"
stack: "error: select count(*) as "Total" from "rig" order by "r_id" desc limit $1 - column "rig.r_id" must appear in the GROUP BY clause or be used in an aggregate function↵ at Parser.parseErrorMessage (/Users/mattis/Developer/WapplerBeta/node_beta/node_modules/pg-protocol/dist/parser.js:241:15)↵ at Parser.handlePacket (/Users/mattis/Developer/WapplerBeta/node_beta/node_modules/pg-protocol/dist/parser.js:89:29)↵ at Parser.parse (/Users/mattis/Developer/WapplerBeta/node_beta/node_modules/pg-protocol/dist/parser.js:41:38)↵ at Socket.<anonymous> (/Users/mattis/Developer/WapplerBeta/node_beta/node_modules/pg-protocol/dist/index.js:8:42)↵ at Socket.emit (events.js:311:20)↵ at addChunk (_stream_readable.js:294:12)↵ at readableAddChunk (_stream_readable.js:275:11)↵ at Socket.Readable.push (_stream_readable.js:209:10)↵ at TCP.onStreamRead (internal/stream_base_commons.js:186:23)"
status: "500"
Community Page
Last updated:
Last updated: