While fetching getting error, Please check the below video issue explained deatiled-
https://www.loom.com/share/94c606a366fd4cb89a95fff3a02edbf2
#Accessing people result in `Cannot return null for non-nullable field FullName.lastName.`
stiff skiff
stiff skiff
Hi twenty crm team I am waiting for your help!
fallen cosmos
Accessing people result in Cannot return nul for non-nullable field FullName.lastName.
Hello @stiff skiff
What does you twenty-server logs looks like ?
Seems like you have a null lastname in db in your people's table
stiff skiff
any way to drop all the people's table data???
fallen cosmos
If you do so you'll loose all your data
If I was you I would change any fullname null value to either empty string or whatever placeholder
stiff skiff
Actually I have 4000 records in people's table
The people's table data not able to get the records to check which has null in lastName
So how can i change null data to string in lastname
Give an solution to resolve this.
fallen cosmos
Either use a db GUI explorer or psql directly
Something like
But first check:
SELECT *
FROM YOUR_WORKSPACE_SCHEMA.YOUR_TABLE
WHERE YOUR_COLUMN IS NULL;
To update
UPDATE YOUR_WORKSPACE_SCHEMA.YOUR_TABLE
SET YOUR_COLUMN = ''
WHERE YOUR_COLUMN IS NULL;
I strongly recommend that you backup your database before
stiff skiff
Sure Thank you for your support. Any thing else i will come back to you.