# "Error loading data" in a table

**URL:** <https://community.nocodb.com/t/error-loading-data-in-a-table/889>\
**Category:** Grid-View\
**Created:** [October 13, 2023, 5:35am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889 "2023-10-13T05:35:33Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Petrogrado\_1917](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/petrogrado_1917/32/313_2.png) [@Petrogrado\_1917](https://community.nocodb.com/u/Petrogrado_1917)\
**Post date:** [October 13, 2023, 5:35am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/1 "2023-10-13T05:35:33Z")

</div>

Hi, there.

Suddenly, when I click one specific table of my database, nocodb shows the message “Error loading data”, appearing as the attached image.

 ![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/3eef29d20ab31fd58ce35e0a36898f2de6e1352f.png)

How can I solve this?

---

<div class="post-metadata">

**Author:** ![Navi](https://avatars.discourse-cdn.com/v4/letter/n/3be4f8/32.png) [@Navi](https://community.nocodb.com/u/Navi)\
**Post date:** [October 13, 2023, 5:57am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/2 "2023-10-13T05:57:25Z")

</div>

If you are self hosting NocoDB on your server - please send error logs from docker. And errors from chrome console (cmd+alt+i or ctrl+alt+i)

---

<div class="post-metadata">

**Author:** ![Petrogrado\_1917](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/petrogrado_1917/32/313_2.png) [@Petrogrado\_1917](https://community.nocodb.com/u/Petrogrado_1917)\
**Post date:** [October 13, 2023, 7:10am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/3 "2023-10-13T07:10:30Z")

</div>

Thanks a lot for you fast response.

Here is what you requested to me:

Chrome console:

 ![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/0503301d1ff4affae873f565e6561dc43e53fd85.png)

Error logs from my self hosting server:

[Nest] 10 - 10/13/2023, 7:01:23 AM ERROR [i] Cannot read properties of null (reading ‘columns’)  
TypeError: Cannot read properties of null (reading ‘columns’)  
at s (/usr/src/app/docker/main.js:1:692165)  
at /usr/src/app/docker/main.js:1:693601  
at processTicksAndRejections (node:internal/process/task\_queues:96:5)  
at async /usr/src/app/docker/main.js:1:694147  
at async s (/usr/src/app/docker/main.js:1:692767)  
at async w.getDataList (/usr/src/app/docker/main.js:1:1228700)  
at async w.dataList (/usr/src/app/docker/main.js:1:1226894)  
at async p.dataList (/usr/src/app/docker/main.js:1:53356)

---

<div class="post-metadata">

**Author:** ![Petrogrado\_1917](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/petrogrado_1917/32/313_2.png) [@Petrogrado\_1917](https://community.nocodb.com/u/Petrogrado_1917)\
**Post date:** [October 13, 2023, 7:23am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/4 "2023-10-13T07:23:35Z")

</div>

Maybe it’s relevant to know this other error:

When I try to get the swagger:

![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/baf2b109d00b68f5e2fdc576652b2f7adb6b37e1.png)

the navigator responses like this:

 ![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/2564f86de8b3613b7e165011bd13b34d195bb245.png)

---

<div class="post-metadata">

**Author:** ![pranavxc](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@pranavxc](https://community.nocodb.com/u/pranavxc)\
**Post date:** [October 13, 2023, 7:28am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/5 "2023-10-13T07:28:33Z")

</div>

Hi @Petrogrado_1917, Can you share the docker version you are using ? Which will help us to debug more easily.

---

<div class="post-metadata">

**Author:** ![Navi](https://avatars.discourse-cdn.com/v4/letter/n/3be4f8/32.png) [@Navi](https://community.nocodb.com/u/Navi)\
**Post date:** [October 13, 2023, 7:29am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/6 "2023-10-13T07:29:48Z")

</div>

We suspect there might be a comma or . in one of your column name. Possible to confirm it ?

Also please reach out in [discord](https://discord.gg/XjMBRzZg) - one of us can help.

---

<div class="post-metadata">

**Author:** ![Petrogrado\_1917](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/petrogrado_1917/32/313_2.png) [@Petrogrado\_1917](https://community.nocodb.com/u/Petrogrado_1917)\
**Post date:** [October 13, 2023, 8:14am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/7 "2023-10-13T08:14:08Z")

</div>

Docker version 20.10.7, build f0df350

---

<div class="post-metadata">

**Author:** ![pranavxc](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@pranavxc](https://community.nocodb.com/u/pranavxc)\
**Post date:** [October 13, 2023, 8:26am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/8 "2023-10-13T08:26:01Z")

</div>

@Petrogrado_1917 : Sorry for the confusion, NocoDB docker version is what we need. And it’s look like you are using an older version of NocoDB, we always recommends to use the latest version of our docker image.

---

<div class="post-metadata">

**Author:** ![Petrogrado\_1917](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/petrogrado_1917/32/313_2.png) [@Petrogrado\_1917](https://community.nocodb.com/u/Petrogrado_1917)\
**Post date:** [October 13, 2023, 10:17am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/9 "2023-10-13T10:17:49Z")

</div>

Hi.

I updated to the latest version but still got the same error in the conflicting table:

 ![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/beadf1ff773b5cc46898d5ad075a7209b77d7ae3.png)

I also attach the Chrome console output:

 ![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/a308d057232ad2e2a5f534d8e50ac8318a1d0693.png)

Please, help. This table is the core of my nocodb.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![pranavxc](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@pranavxc](https://community.nocodb.com/u/pranavxc)\
**Post date:** [October 13, 2023, 11:57am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/10 "2023-10-13T11:57:46Z")

</div>

@Petrogrado_1917 : Can you include the backend error log as well, including the call stack.

---

<div class="post-metadata">

**Author:** ![Petrogrado\_1917](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/petrogrado_1917/32/313_2.png) [@Petrogrado\_1917](https://community.nocodb.com/u/Petrogrado_1917)\
**Post date:** [October 13, 2023, 12:20pm UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/11 "2023-10-13T12:20:29Z")

</div>

[Nest] 10 - 10/13/2023, 12:16:42 PM ERROR [GlobalExceptionFilter] Cannot read properties of null (reading ‘columns’)  
TypeError: Cannot read properties of null (reading ‘columns’)  
at r (/usr/src/app/docker/main.js:2:971090)  
at /usr/src/app/docker/main.js:2:972552  
at process.processTicksAndRejections (node:internal/process/task\_queues:95:5)  
at async /usr/src/app/docker/main.js:2:973098  
at async r (/usr/src/app/docker/main.js:2:971718)  
at async DatasService.getDataList (/usr/src/app/docker/main.js:2:1574486)  
at async DatasService.dataList (/usr/src/app/docker/main.js:2:1572660)  
at async DataAliasController.dataList (/usr/src/app/docker/main.js:2:361509)

---

<div class="post-metadata">

**Author:** ![pranavxc](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@pranavxc](https://community.nocodb.com/u/pranavxc)\
**Post date:** [October 13, 2023, 1:09pm UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/12 "2023-10-13T13:09:22Z")

</div>

> [@Petrogrado\_1917](#):
>
> 2:971718

@Petrogrado_1917 : Thanks for your quick reply. I would like to know few more things,

1. Do you have a LinkToAnotherRecord column in your table ?
2. Which column is your display value (primary value) ?
3. Are you altering the meta db using any external database tools ?
4. Are you using Redis for caching ?

---

<div class="post-metadata">

**Author:** ![Petrogrado\_1917](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/petrogrado_1917/32/313_2.png) [@Petrogrado\_1917](https://community.nocodb.com/u/Petrogrado_1917)\
**Post date:** [October 13, 2023, 3:48pm UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/13 "2023-10-13T15:48:26Z")

</div>

1. Yes
2. A SingleLineText column called ‘Nombre y Apellidos’
3. No. We just were using REST API to fill this table.
4. No

I’m trying to delete this column but it is not deleted:

 ![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/2b12809df517598268f4c73862cb7b9e9ba17f73.png)

---

<div class="post-metadata">

**Author:** ![pranavxc](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@pranavxc](https://community.nocodb.com/u/pranavxc)\
**Post date:** [October 14, 2023, 6:22am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/14 "2023-10-14T06:22:00Z")

</div>

Please try the following image and let me know that it still causing problem or not.

```auto
docker run -d -p 8888:8080 nocodb/nocodb-timely:0.202.4-pr-6690-20231014-0527

```

---

<div class="post-metadata">

**Author:** ![Petrogrado\_1917](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/petrogrado_1917/32/313_2.png) [@Petrogrado\_1917](https://community.nocodb.com/u/Petrogrado_1917)\
**Post date:** [October 16, 2023, 6:34am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/15 "2023-10-16T06:34:23Z")

</div>

Good morning.

The error still persists.

Any other idea?

Thanks.

---

<div class="post-metadata">

**Author:** ![pranavxc](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@pranavxc](https://community.nocodb.com/u/pranavxc)\
**Post date:** [October 16, 2023, 8:43am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/16 "2023-10-16T08:43:12Z")

</div>

Can you share the error backend error log with above image.

---

<div class="post-metadata">

**Author:** ![Petrogrado\_1917](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/petrogrado_1917/32/313_2.png) [@Petrogrado\_1917](https://community.nocodb.com/u/Petrogrado_1917)\
**Post date:** [October 16, 2023, 12:35pm UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/17 "2023-10-16T12:35:54Z")

</div>

Ok.

By now I give you the Chrome capture after clicking the table with the problem:

 ![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/2ba0383759e8f4dfb79c3d24bcad555651ce1731.png)

Same error, it seems…

---

<div class="post-metadata">

**Author:** ![pranavxc](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@pranavxc](https://community.nocodb.com/u/pranavxc)\
**Post date:** [October 16, 2023, 8:04pm UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/18 "2023-10-16T20:04:10Z")

</div>

> [@pranavxc](#):
>
> backend error log with above image

Please share the backend error log (from docker logs) with following image `nocodb/nocodb-timely:0.202.4-pr-6690-20231014-0527`

---

<div class="post-metadata">

**Author:** ![Petrogrado\_1917](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/petrogrado_1917/32/313_2.png) [@Petrogrado\_1917](https://community.nocodb.com/u/Petrogrado_1917)\
**Post date:** [October 17, 2023, 10:47am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/19 "2023-10-17T10:47:28Z")

</div>

[Nest] 9 - 10/16/2023, 7:15:51 AM ERROR [GlobalExceptionFilter] Cannot read properties of null (reading ‘columns’)  
TypeError: Cannot read properties of null (reading ‘columns’)  
at r (/usr/src/app/docker/main.js:2:971090)  
at /usr/src/app/docker/main.js:2:972572  
at process.processTicksAndRejections (node:internal/process/task\_queues:95:5)  
at async /usr/src/app/docker/main.js:2:973118  
at async r (/usr/src/app/docker/main.js:2:971718)  
at async DatasService.getDataList (/usr/src/app/docker/main.js:2:1574506)  
at async DatasService.dataList (/usr/src/app/docker/main.js:2:1572680)  
at async DataAliasController.dataList (/usr/src/app/docker/main.js:2:361509)

This table has a Link field to another table that I deleted before. I mean this column persists even after was deleted the linked table and, in fact, I can’t delete it manually in the frontend.

---

<div class="post-metadata">

**Author:** ![pranavxc](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@pranavxc](https://community.nocodb.com/u/pranavxc)\
**Post date:** [October 25, 2023, 5:55am UTC](https://community.nocodb.com/t/error-loading-data-in-a-table/889/20 "2023-10-25T05:55:06Z")

</div>

Sorry for the delayed reply I will have a look and get back to you soon.
