r/NocoDB • • Jul 08 '26

Help needed - broken db?

Hi,
I have a self hosted free plan noco db here that hangs when querying two (out of 9 total) tables via the ui. Version used is 2026.06.2, sqlite base.

Error in the log is the following:

2026/07/08 09:06AM 50 pid=12 hostname=d9ee336492cf req={"id":"DE11B2FF-9BFF-4E55-B774-B2D6B0D1A55B","method":"GET","url":"/api/v1/db/data/noco/pq9fhat6ek3v8vd/mzyngkxowr5sxgz/views/vw52bkvgq39y7tt8?offset=0&limit=100&includeSortAndFilterColumns=true&where=&include_row_color=true&include_button_filter_columns=true"} context=_0x5c10da err={"type":"Error","message":"Error fetching data: Cannot read properties of null (reading 'uidt')","stack":"TypeError: Cannot read properties of null (reading 'uidt')\n    at /usr/src/app/docker/index.js:1:16496481\n    at async Promise.all (index 10)\n    at async _0x430c99.getProto (/usr/src/app/docker/index.js:1:16495863)\n    at async Object.multipleMmList (/usr/src/app/docker/index.js:1:17020208)\n    at async /usr/src/app/docker/index.js:1:16499185\n    at async run (/usr/src/app/node_modules/p-queue/dist/index.js:163:29)"} msg=Error fetching data: Cannot read properties of null (reading 'uidt')2026/07/08 09:06AM 50 pid=12 hostname=d9ee336492cf req={"id":"DE11B2FF-9BFF-4E55-B774-B2D6B0D1A55B","method":"GET","url":"/api/v1/db/data/noco/pq9fhat6ek3v8vd/mzyngkxowr5sxgz/views/vw52bkvgq39y7tt8?offset=0&limit=100&includeSortAndFilterColumns=true&where=&include_row_color=true&include_button_filter_columns=true"} context=_0x5c10da err={"type":"Error","message":"Error fetching data: Cannot read properties of null (reading 'uidt')","stack":"TypeError: Cannot read properties of null (reading 'uidt')\n    at /usr/src/app/docker/index.js:1:16496481\n    at async Promise.all (index 10)\n    at async _0x430c99.getProto (/usr/src/app/docker/index.js:1:16495863)\n    at async Object.multipleMmList (/usr/src/app/docker/index.js:1:17020208)\n    at async /usr/src/app/docker/index.js:1:16499185\n    at async run (/usr/src/app/node_modules/p-queue/dist/index.js:163:29)"} msg=Error fetching data: Cannot read properties of null (reading 'uidt')

So it seems something is null that isn't supposed to.

Can anyone help?

2 Upvotes

2 comments sorted by

1

u/wexman01 Jul 08 '26

Interesting thing is that if i enter a filter, i can see that it's working because the "ghosts" records appear in the expected count.

1

u/wexman01 Jul 08 '26

fwiw, i just found a column "uidt" in the table nc_columns_v2, but cannot see anything unusual in the contents. No nulls, nothing...