simov / express-admin

MySQL, MariaDB, PostgreSQL, SQLite admin for Node.js
MIT License
1.17k stars 222 forks source link

Unhandled exception when paginating empty resultsets #143

Open stanzahk opened 6 years ago

stanzahk commented 6 years ago

Hi,

i have set-up a view with filters.

When searching for a item and the result set is empty, the application dies with the following error:

`/usr/lib/node_modules/express-admin/lib/data/pagination.js:11 var total = parseInt(rows[0].count), ^

TypeError: Cannot read property 'count' of undefined at /usr/lib/node_modules/express-admin/lib/data/pagination.js:11:37 at Query._callback (/usr/lib/node_modules/express-admin/lib/db/client.js:43:9) at Query.Sequence.end (/usr/lib/node_modules/express-admin/node_modules/mysql/lib/protocol/sequences/Sequence.js:78:24) at Query._handleFinalResultPacket (/usr/lib/node_modules/express-admin/node_modules/mysql/lib/protocol/sequences/Query.js:143:8) at Query.EofPacket (/usr/lib/node_modules/express-admin/node_modules/mysql/lib/protocol/sequences/Query.js:127:8) at Protocol._parsePacket (/usr/lib/node_modules/express-admin/node_modules/mysql/lib/protocol/Protocol.js:205:24) at Parser.write (/usr/lib/node_modules/express-admin/node_modules/mysql/lib/protocol/Parser.js:62:12) at Protocol.write (/usr/lib/node_modules/express-admin/node_modules/mysql/lib/protocol/Protocol.js:37:16) at Socket. (/usr/lib/node_modules/express-admin/node_modules/mysql/lib/Connection.js:73:28) at emitOne (events.js:96:13) `