NocoDB wont write edits, but reads data fine... please helpppp

[lauriiiipot]

i'm getting the following error when attempting to change data in nocodb

Record update failed: update "data"."uprns" set "additional_notes" = '123' where "id" = '202267' - function st_geometrytype(public.geometry) does not exist.

everything was working fine and then it suddenly started happening??

[dosubot[bot]]

The error message indicates that the st_geometrytype function is missing from your database. This function is typically part of the PostGIS extension in PostgreSQL, which provides support for spatial data types.

Here are some steps to troubleshoot and resolve this issue:

1. Check PostGIS Installation: Ensure that the PostGIS extension is installed and enabled in your PostgreSQL database. You can do this by running the following SQL command:

   CREATE EXTENSION IF NOT EXISTS postgis;

2. Verify Function Existence: Check if the st_geometrytype function exists in your database. You can do this by running:

   SELECT * FROM pg_proc WHERE proname = 'st_geometrytype';

3. Database Connection: Ensure that NocoDB is connected to the correct database where PostGIS is enabled.

4. Restart Services: Sometimes, restarting the database and NocoDB services can resolve transient issues.

If the issue persists after following these steps, it might be helpful to review recent changes or updates in your environment that could have affected the database configuration.

To continue talking to Dosu, mention @dosu.

[lauriiiipot]

I've verified the function existence and all is good.

i have another system using the database foe spatial purposes so i know that postGIS is installed

[o1lab]

Copy base info and paste it here

And also confirm if that field exists in your database.

Plus check if your metadata is in sync : https://docs.nocodb.com/data-sources/data-source-overview/#overview

[lauriiiipot]

hi, thanks for the quick reply, im on the cloud hosted version of nocodb and it doesnt seem to have an option to copy base info?

[lauriiiipot]

ive also verified the sync status and all is up to date.
and ive also ran : SELECT * FROM pg_proc WHERE proname = 'st_geometrytype'; in PG admin and it has returned a result.