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.

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

Integrity constraint violation: 19 columns title, project_id are not unique #1399

Closed
austinbarrington opened this issue Oct 21, 2015 · 0 comments

Comments

@austinbarrington
Copy link

commented Oct 21, 2015

Hello,

Just downloaded and setup kanboard and love it. However, we have found a problem. After creating two projects the system then stops any user (including admin) creating new projects.
We are using the default sqlite database. Let me know if you need any more information.

This is the debug output:

[2015-10-21 16:44:31] [debug] SELECT * FROM "actions"
[2015-10-21 16:44:31] [debug] DURATION=0.0015559196472168
[2015-10-21 16:44:31] [debug] SELECT * FROM "action_has_params"
[2015-10-21 16:44:31] [debug] DURATION=6.0796737670898E-5
[2015-10-21 16:44:31] [debug] SELECT "version" FROM "plugin_schema_versions"   WHERE "plugin" = ?    LIMIT 1
[2015-10-21 16:44:31] [debug] DURATION=9.2029571533203E-5
[2015-10-21 16:44:31] [debug] SELECT "version" FROM "plugin_schema_versions"   WHERE "plugin" = ?    LIMIT 1
[2015-10-21 16:44:31] [debug] DURATION=8.082389831543E-5
[2015-10-21 16:44:31] [debug] SELECT 1 FROM "users"  WHERE "id" = ?
[2015-10-21 16:44:31] [debug] DURATION=7.0095062255859E-5
[2015-10-21 16:44:31] [debug] INSERT INTO "projects" ("is_private", "name", "token", "last_modified") VALUES (?, ?, ?, ?)
[2015-10-21 16:44:31] [debug] DURATION=0.00012803077697754
[2015-10-21 16:44:31] [debug] INSERT INTO "columns" ("title", "position", "project_id", "task_limit", "description") VALUES (?, ?, ?, ?, ?)
[2015-10-21 16:44:31] [debug] SQLSTATE[23000]: Integrity constraint violation: 19 columns title, project_id are not unique

@fguillot fguillot closed this Jul 24, 2016

@kanboard kanboard locked and limited conversation to collaborators Feb 6, 2018

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
2 participants
You can’t perform that action at this time.