Comments (4)
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.
auth.users is not available on directus but if i try to add DB_SEARCH_PATH, i got this error :
from directus.
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.
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)
- "Webhook/Request url" in flow url can not request two-way mtls api? HOT 1
- Wrong permissions typing in SDK HOT 2
- User Me, has App Access, Cant get fields:*
- Default value 0 changed to null on schema apply/snapshot HOT 1
- Local development of an extension
- DirectusPolicy types for typescript in SDK is incomplete HOT 2
- New CLI installation & Migration problem HOT 3
- Directus Extension (Integration) Testing Mocked Services HOT 1
- Incorrect Count Returned by Directus SDK Aggregation Method with Nested Filters
- "Create Item" pre-filled when used from Bookmark page HOT 1
- Do not return an empty body on user creation via API endpoint /users/register HOT 1
- Add note to the register user endpoint explaining the status code
- Include unsaved-changes notice in manual flow-confirmation
- Simpler way to get a user's policies needed HOT 3
- Input default value not being stored correctly HOT 2
- Notification drawer: item count missing
- Server crashed after trying to access deleted file HOT 5
- Default values has some weird behaviours with translations
- App: List within a Dashboard does not render M2M fields
- Icon in Email Template - Liquid HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from directus.