Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Database error upon first run #57

Open
dmaes opened this issue Nov 25, 2021 · 0 comments
Open

Database error upon first run #57

dmaes opened this issue Nov 25, 2021 · 0 comments

Comments

@dmaes
Copy link

dmaes commented Nov 25, 2021

Trying to run v0.2.0 of this bot with a postgresql database in the maubot standalone mode, and I get the following error:

sqlalchemy.exc.ProgrammingError: (psycopg2.errors.InvalidForeignKey) there is no unique constraint matching given keys for referenced table "token"

[SQL:
CREATE TABLE "default" (
	user_id VARCHAR(255) NOT NULL,
	gitlab_server TEXT,
	PRIMARY KEY (user_id),
	FOREIGN KEY(user_id) REFERENCES token (user_id),
	FOREIGN KEY(gitlab_server) REFERENCES token (gitlab_server)
)

]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@dmaes