Added a relation, did a rename of column and delete the relation [May 14]

:raising_hand_man: alfomin asked

Hi folks, I’m currently using v 0.90.11

I’ve got one of my tables broken after adding a relation to a different table in the same DB

My steps were something like:

add new O2M relation, rename the “read” column, delete the relation

Since then it refuses to load both in the UI and via API

Here’s what it throws in the console:

```

{“msg”:“DataLoader must be constructed with a function which accepts Array and returns Promise<Array>, but the function did not return a Promise of an Array of the same length as the Array of keys.\n\nKeys:\n1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100\n\nValues:\n”}

```

Please advise how can I fix that?

:person_tipping_hand: o1lab replied

is it an external database ?

:raising_hand_man: alfomin replied

yes

it’s a PostgreSQL

:person_tipping_hand: o1lab replied

you could either do metadata sync or recreate a new project connecting to that database

:person_tipping_hand: o1lab replied

can u pls paste project info

:person_tipping_hand: o1lab replied

right top menu

:raising_hand_man: alfomin replied

Node: v12.22.12

Arch: x64

Platform: linux

Docker: false

Database: pg

ProjectOnRootDB: false

RootDB: pg

PackageVersion: 0.90.11

:person_tipping_hand: o1lab replied

ya should be good

:person_tipping_hand: o1lab replied

Create a new project by connecting to same db

:raising_hand_man: alfomin replied

ok. will try

thanks!

:raising_hand_man: alfomin replied

all worked well

although all attachments and select fields were converted to long text

so it needs some manual tweaks

but the table came back alive )

thanks so much!

Autogenerated from discord


Join NocoDB’s community

DiscordTwitterRedditDocs