Adding a new Admin/User breaks at 3 max #2309

Closed
opened 2026-02-05 03:37:13 +03:00 by OVERLORD · 6 comments
Owner

Originally created by @aroldjacx on GitHub (Jun 28, 2021).

The bug
As an admin when I create three (3) additional users. After that, the system throughs an error if you want to create more users.

Steps To Reproduce
Steps to reproduce the behavior:

  1. Go to 'Settings'
  2. Click on 'Users'
  3. Add A New User 'Click Add New User button', and now add more than three (3) ADMINS until it Barks at you!.
  4. See error
**Illuminate\Database\QueryException**
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '' for key 'users.users_slug_unique' (SQL: insert into `users` (`name`, `email`, `password`, `updated_at`, `created_at`) values (xtimx, xtimx@gmail.com, $2y$10$3VZvuaT9oG/.O9n7Cs4R../oFLxf7W9cgio0w3IsqyrJ8DGHj2rH6, 2021-06-28 13:45:27, 2021-06-28 13:45:27))
http://bookstack.localhost/settings/users/create

Expected behavior
I expect to have the ability to create as much user/admin as needed without errors.

Screenshots
admin

Your Configuration (please complete the following information):

  • Exact BookStack Version (Found in settings): BookStack v0.31.8
  • PHP Version:
  • Hosting Method: Nginx

Additional context
Add any other context about the problem here.

Originally created by @aroldjacx on GitHub (Jun 28, 2021). **The bug** As an admin when I create three (3) additional users. After that, the system throughs an error if you want to create more users. **Steps To Reproduce** Steps to reproduce the behavior: 1. Go to 'Settings' 2. Click on 'Users' 3. Add A New User 'Click Add New User button', and now add more than three (3) ADMINS until it Barks at you!. 4. See error ``` **Illuminate\Database\QueryException** SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '' for key 'users.users_slug_unique' (SQL: insert into `users` (`name`, `email`, `password`, `updated_at`, `created_at`) values (xtimx, xtimx@gmail.com, $2y$10$3VZvuaT9oG/.O9n7Cs4R../oFLxf7W9cgio0w3IsqyrJ8DGHj2rH6, 2021-06-28 13:45:27, 2021-06-28 13:45:27)) http://bookstack.localhost/settings/users/create ``` **Expected behavior** I expect to have the ability to create as much user/admin as needed without errors. **Screenshots** ![admin](https://user-images.githubusercontent.com/8050442/123655052-a7178900-d7fc-11eb-8ab6-3e5867324d62.png) **Your Configuration (please complete the following information):** - Exact BookStack Version (Found in settings): BookStack v0.31.8 - PHP Version: - Hosting Method: Nginx **Additional context** Add any other context about the problem here.
OVERLORD added the 🐕 Support label 2026-02-05 03:37:13 +03:00
Author
Owner

@ssddanbrown commented on GitHub (Jun 28, 2021):

Hi @aroldjacx,
I'm pretty sure your BookStack codebase and database state versions have got muddled here. Have you pehaps done some level of restore or attempted an upgrade to a more recent version? The column reported in the issue thrown was added in a later BookStack release than that shown in your reported version number.

@ssddanbrown commented on GitHub (Jun 28, 2021): Hi @aroldjacx, I'm pretty sure your BookStack codebase and database state versions have got muddled here. Have you pehaps done some level of restore or attempted an upgrade to a more recent version? The column reported in the issue thrown was added in a later BookStack release than that shown in your reported version number.
Author
Owner

@aroldjacx commented on GitHub (Jun 28, 2021):

Upgrade yes! I did attempt an upgrade last month. are you saying the upgrade procedure was not complete? How would i go about cleaning this up?

@aroldjacx commented on GitHub (Jun 28, 2021): Upgrade yes! I did attempt an upgrade last month. are you saying the upgrade procedure was not complete? How would i go about cleaning this up?
Author
Owner

@ssddanbrown commented on GitHub (Jun 28, 2021):

@aroldjacx I don't think it's complete, That version of BookStack is a few months old. It depends on the errors that occured upon upgrade. Do you get any errors when running the upgrade command?

@ssddanbrown commented on GitHub (Jun 28, 2021): @aroldjacx I don't think it's complete, That version of BookStack is a few months old. It depends on the errors that occured upon upgrade. Do you get any errors when running the upgrade command?
Author
Owner

@aroldjacx commented on GitHub (Jun 29, 2021):

Yes! what I have don is install the latest and now it working. You practically helped solve the issue from your first response. now i am just porting my setting over via the database

@aroldjacx commented on GitHub (Jun 29, 2021): Yes! what I have don is install the latest and now it working. You practically helped solve the issue from your first response. now i am just porting my setting over via the database
Author
Owner

@aroldjacx commented on GitHub (Jun 29, 2021):

THANKS much for your help solider!

@aroldjacx commented on GitHub (Jun 29, 2021): THANKS much for your help solider!
Author
Owner

@ssddanbrown commented on GitHub (Jun 29, 2021):

@aroldjacx Glad to hear you got things working. Will therefore close this off.

@ssddanbrown commented on GitHub (Jun 29, 2021): @aroldjacx Glad to hear you got things working. Will therefore close this off.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/BookStack#2309