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

clake_userextended_route_restriction.attempts cant be NULL #128

Open
mnvx opened this issue Jun 18, 2017 · 1 comment
Open

clake_userextended_route_restriction.attempts cant be NULL #128

mnvx opened this issue Jun 18, 2017 · 1 comment
Assignees

Comments

@mnvx
Copy link

mnvx commented Jun 18, 2017

When I try to create restriction on page backend/clake/userextended/routes/update/3:

"SQLSTATE[23502]: Not null violation: 7 ОШИБКА: нулевое значение в столбце "attempts" нарушает ограничение NOT NULL
DETAIL: Ошибочная строка содержит (1, 2, null, null, , 2017-06-18 07:01:17, 2017-06-18 07:01:17, null, null, Доступ для Участника, , UE_WHITELIST). (SQL: insert into "clake_userextended_route_restriction" ("name", "description", "type", "ip", "user_id", "group_id", "role_id", "updated_at", "created_at") values (Доступ для Участника, , UE_WHITELIST, , , , 2, 2017-06-18 07:01:17, 2017-06-18 07:01:17) returning "id")" on line 666 of /var/www/zabor/vendor/laravel/framework/src/Illuminate/Database/Connection.php

My database is PostgreSQL.

@mnvx
Copy link
Author

mnvx commented Jun 18, 2017

I has resolved it by

ALTER TABLE public.clake_userextended_route_restriction ALTER COLUMN attempts SET DEFAULT 0;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants