Giter Club home page Giter Club logo

Comments (4)

br41nslug avatar br41nslug commented on September 27, 2024 1

I have a user table which have relationship to auth.users used to supabase auth .

Have you configured this auth.users collection and the relationship properly in directus? Because the error looks like it is trying to relate to a non-existent table.

have you tried adding the auth schema to directus search_path? DB_SEARCH_PATH="public,auth"

from directus.

GhosTHaise avatar GhosTHaise commented on September 27, 2024

auth.users is not available on directus but if i try to add DB_SEARCH_PATH, i got this error :
image

from directus.

GhosTHaise avatar GhosTHaise commented on September 27, 2024

I have a user table which have relationship to auth.users used to supabase auth .

Have you configured this auth.users collection and the relationship properly in directus? Because the error looks like it is trying to relate to a non-existent table.

have you tried adding the auth schema to directus search_path? DB_SEARCH_PATH="public,auth"

my full log :

   ╭───────────────────────────────────────────────────╮
   │                                                   │
   │                 Update available!                 │
   │                                                   │
   │                 10.11.0 → 10.11.1                 │
   │                 1 version behind                  │
   │                                                   │
   │                 More information:                 │
   │   https://github.com/directus/directus/releases   │
   │                                                   │
   ╰───────────────────────────────────────────────────╯

error: WITH geometries as (
                                        select * from geometry_columns
                                        union
                                        select * from geography_columns
                                )
                                SELECT f_table_name as table_name
                                        , f_geometry_column as column_name
                                        , type as data_type
                                FROM geometries g
                                JOIN information_schema.tables t
                                        ON g.f_table_name = t.table_name
                                        AND t.table_type = 'BASE TABLE'
                                WHERE f_table_schema in ($1,$2)
                                 - relation "geometry_columns" does not exist
    at Parser.parseErrorMessage (/home/ghosthaise/dev/tottem-project/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/home/ghosthaise/dev/tottem-project/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/home/ghosthaise/dev/tottem-project/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/home/ghosthaise/dev/tottem-project/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:517:28)
    at addChunk (node:internal/streams/readable:335:12)
    at readableAddChunk (node:internal/streams/readable:308:9)
    at Readable.push (node:internal/streams/readable:245:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
  length: 115,
  severity: 'ERROR',
  code: '42P01',
  detail: undefined,
  hint: undefined,
  position: '41',
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'parse_relation.c',
  line: '1392',
  routine: 'parserOpenTable'
}
[15:02:46.784] WARN: Couldn't load extensions
[15:02:46.784] WARN: WITH geometries as (
                                        select * from geometry_columns
                                        union
                                        select * from geography_columns
                                )
                                SELECT f_table_name as table_name
                                        , f_geometry_column as column_name
                                        , type as data_type
                                FROM geometries g
                                JOIN information_schema.tables t
                                        ON g.f_table_name = t.table_name
                                        AND t.table_type = 'BASE TABLE'
                                WHERE f_table_schema in ($1,$2)
                                 - relation "geometry_columns" does not exist
    err: {
      "type": "DatabaseError",
      "message": "WITH geometries as (\n\t\t\t\t\tselect * from geometry_columns\n\t\t\t\t\tunion\n\t\t\t\t\tselect * from geography_columns\n\t\t\t\t)\n\t\t\t\tSELECT f_table_name as table_name\n\t\t\t\t\t, f_geometry_column as column_name\n\t\t\t\t\t, type as data_type\n\t\t\t\tFROM geometries g\n\t\t\t\tJOIN information_schema.tables t\n\t\t\t\t\tON g.f_table_name = t.table_name\n\t\t\t\t\tAND t.table_type = 'BASE TABLE'\n\t\t\t\tWHERE f_table_schema in ($1,$2)\n\t\t\t\t - relation \"geometry_columns\" does not exist",
      "stack":
          error: WITH geometries as (
                                                select * from geometry_columns
                                                union
                                                select * from geography_columns
                                        )
                                        SELECT f_table_name as table_name
                                                , f_geometry_column as column_name
                                                , type as data_type
                                        FROM geometries g
                                        JOIN information_schema.tables t
                                                ON g.f_table_name = t.table_name
                                                AND t.table_type = 'BASE TABLE'
                                        WHERE f_table_schema in ($1,$2)
                                         - relation "geometry_columns" does not exist
              at Parser.parseErrorMessage (/home/ghosthaise/dev/tottem-project/node_modules/pg-protocol/dist/parser.js:283:98)
              at Parser.handlePacket (/home/ghosthaise/dev/tottem-project/node_modules/pg-protocol/dist/parser.js:122:29)
              at Parser.parse (/home/ghosthaise/dev/tottem-project/node_modules/pg-protocol/dist/parser.js:35:38)
              at Socket.<anonymous> (/home/ghosthaise/dev/tottem-project/node_modules/pg-protocol/dist/index.js:11:42)
              at Socket.emit (node:events:517:28)
              at addChunk (node:internal/streams/readable:335:12)
              at readableAddChunk (node:internal/streams/readable:308:9)
              at Readable.push (node:internal/streams/readable:245:10)
              at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
      "length": 115,
      "name": "error",
      "severity": "ERROR",
      "code": "42P01",
      "position": "41",
      "file": "parse_relation.c",
      "line": "1392",
      "routine": "parserOpenTable"
    }
[15:02:47.027] WARN: "PUBLIC_URL" should be a full URL```

from directus.

rijkvanzanten avatar rijkvanzanten commented on September 27, 2024

I'm not able to reproduce this with the reproduction steps provided against the current version of Supabase cloud + Directus v10.13.1 so I'll close this for now. Happy to reopen if more information becomes available 🙂

from directus.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.