Files
supabase/apps/docs/content/troubleshooting/database-error-saving-new-user-RU_EwB.mdx
github-actions[bot] a42e17d0a9 [bot] sync troubleshooting guides to db (#32874)
Co-authored-by: github-docs-sync-bot <github-docs-sync-bot@supabase.com>
2025-01-17 21:43:43 +00:00

29 lines
1.2 KiB
Plaintext

---
title = "Database error saving new user"
github_url = "https://github.com/orgs/supabase/discussions/13043"
date_created = "2023-03-16T04:52:50+00:00"
topics = [ "auth", "studio" ]
keywords = [ "users" ]
database_id = "5d1c44ed-b2f6-4509-9312-1eeb8838e701"
[[errors]]
message = "Database error saving new user"
---
You generally get this error when trying to invite a new user from the dashboard or when trying to insert a user into a table using the table editor in the Supabase dashboard.
This error is normally associated with a side effect of a database transaction.
**Common causes of this error:**
- You have a trigger/trigger function setup on the `auth.users` table
- You have added a constraint on the `auth.users` table which isn't being met
- You are using Prisma and it has broken all the permissions on the `auth.users` table
**Debugging this error:**
- You can use the [Auth logs explorer](https://app.supabase.com/project/_/logs/auth-logs) to find the issue with more information
- You can use the [Postgres logs explorer](https://app.supabase.com/project/_/logs/postgres-logs)
https://user-images.githubusercontent.com/79497/225517698-b6e3ccaf-cd70-4acd-8124-ffbcee310d63.mp4