🐛 Bug: TypeError: Cannot read properties of null (reading 'date_format') while update external PG table

[swim2sun]

Please confirm that the bug report does not already exist

• I confirm there is no existing issue for this bug.

Steps to reproduce

1. add external Postgresql datasource
2. connect external datasource
3. update table field, fot this case I modify one column's datatype from 'single line text' to 'single select'

Desired Behavior

update datatype successfully

Project Details

instance start with docker compose:

version: '2.1'
services:
  nocodb:
    image: nocodb/nocodb:latest
    ports:
      - "8082:8080"
    restart: always
    volumes:

Attachments

error logs:

nocodb-1  | ╔══════════════════════════════════════════════════════════════════════════════╗║
                                                   ║║   EXCEPTION OCCURED!! in PGClient @ tableUpdate
           ║║   - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    ║║   - - - - - - - - - - - - - - - - - - - - - -                                ║║   MESSAGE:
           ║║   Cannot read properties of null (reading 'date_format')                     ║║
                                                   ║║   - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    ║║   - - - - - - - - - - - - - - - - - - - - - -                                ║║   CODE:
                                                   ║║   undefined
           ║║                                                                              ║║   - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    ║║   - - - - - - - - - - - - - - - - - - - - - -
           ║║   STACK:                                                                     ║║   TypeError: Cannot read properties of null (reading 'date_format')          ║║   at PGClient.alterTableColumn (/usr/src/app/docker/main.js:2:1000402)       ║║   at PGClient.alterTableChangeColumn                                         ║║   (/usr/src/app/docker/main.js:2:998868)                                     ║║   at PGClient.tableUpdate (/usr/src/app/docker/main.js:2:994363)             ║║   at SqlMgrv2.sqlOpPlus (/usr/src/app/docker/main.js:2:1089627)              ║║   at process.processTicksAndRejections                                       ║║   (node:internal/process/task_queues:95:5)
           ║║   at async ColumnsService.columnUpdate                                       ║║   (/usr/src/app/docker/main.js:2:2006326)                                    ║║   at async ColumnsService.columnBulk
           ║║   (/usr/src/app/docker/main.js:2:2036140)                                    ║║   at async ColumnsController.columnBulk                                      ║║   (/usr/src/app/docker/main.js:2:377471)
           ║║                                                                              ║║   - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    ║║   - - - - - - - - - - - - - - - - - - - - - -
           ║║                                                                              ║║
                                                   ║╚══════════════════════════════════════════════════════════════════════════════╝
nocodb-1  | TypeError: Cannot read properties of null (reading 'date_format')
nocodb-1  |     at PGClient.alterTableColumn (/usr/src/app/docker/main.js:2:1000402)
nocodb-1  |     at PGClient.alterTableChangeColumn (/usr/src/app/docker/main.js:2:998868)
nocodb-1  |     at PGClient.tableUpdate (/usr/src/app/docker/main.js:2:994363)
nocodb-1  |     at SqlMgrv2.sqlOpPlus (/usr/src/app/docker/main.js:2:1089627)
nocodb-1  |     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
nocodb-1  |     at async ColumnsService.columnUpdate (/usr/src/app/docker/main.js:2:2006326)
nocodb-1  |     at async ColumnsService.columnBulk (/usr/src/app/docker/main.js:2:2036140)
nocodb-1  |     at async ColumnsController.columnBulk (/usr/src/app/docker/main.js:2:377471)

[dosubot]

Hey there, @swim2sun! I'm here to help you with your bug report. I can assist with solving bugs, answering questions, and even becoming a contributor. Let's tackle this issue together while we wait for a human maintainer.

I found a similar closed issue related to a TypeError involving the date_format property when importing Excel or CSV files. The issue was resolved in version 0.202.5, where a user was able to import an XLSX file successfully. However, this specific issue was about importing files, not updating a column's datatype in an external PostgreSQL table ^[1].

For your case, it seems like the error occurs when trying to update a column's datatype from 'single line text' to 'single select' in an external PostgreSQL table. This might be related to how NocoDB handles datatype conversions or the specific implementation of the alterTableColumn method in the PGClient module. Unfortunately, I couldn't find specific information on this exact scenario.

You might want to check if there are any updates or patches available for NocoDB that address this issue, or if there are any workarounds suggested by the community. If the problem persists, consider providing more details or checking if there are any configuration settings that might affect this operation.

To continue talking to Dosu, mention @dosu.

[dstala]

Unable to reproduce this on latest release (0.260.2). Please reopen this ticket if issue persists, preferably with sample data that leads to this issue.