mirror of
https://github.com/BookStackApp/BookStack.git
synced 2026-02-11 03:13:15 +03:00
error adding new role #1927
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @minosso on GitHub (Nov 5, 2020).
We need some help to recovery the system.
After a DB recover, we are not able to add new roles.
1 - BookStack v0.30.4
2- GUI error DEBUG
Illuminate\Database\QueryException
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '' for key 'roles.roles_name_unique' (SQL: insert into
roles(display_name,description,external_auth_id,updated_at,created_at) values (SG-ITDocsUsers-RW, , SG-ITDocsUsers-RW, 2020-11-05 16:04:43, 2020-11-05 16:04:43))3-
mysql> select * from roles;
+----+--------+----------------+-----------------------------------------------------------+---------------------+---------------------+-------------+------------------+
| id | name | display_name | description | created_at | updated_at | system_name | external_auth_id |
+----+--------+----------------+-----------------------------------------------------------+---------------------+---------------------+-------------+------------------+
| 1 | admin | Admin | Administrator of the whole application | 2020-07-27 12:31:58 | 2020-07-27 12:31:58 | admin | |
| 2 | editor | Editor | User can edit Books, Chapters & Pages | 2020-07-27 12:31:59 | 2020-11-05 15:16:25 | | |
| 3 | viewer | Viewer | User can view books & their content behind authentication | 2020-07-27 12:31:59 | 2020-07-27 12:31:59 | | |
| 4 | public | Public | The role given to public visitors if allowed | 2020-07-27 12:32:21 | 2020-07-27 12:32:21 | public | |
| 5 | | ITDocsUsers | | 2020-11-05 14:29:35 | 2020-11-05 14:32:49 | | ITDocsUsers |
+----+--------+----------------+-----------------------------------------------------------+---------------------+---------------------+-------------+------------------+
4-
php artisan migrate:status
+------+--------------------------------------------------+-------+
| Ran? | Migration | Batch |
+------+--------------------------------------------------+-------+
| Yes | 2014_10_12_000000_create_users_table | 1 |
| Yes | 2014_10_12_100000_create_password_resets_table | 1 |
| Yes | 2015_07_12_114933_create_books_table | 1 |
| Yes | 2015_07_12_190027_create_pages_table | 1 |
| Yes | 2015_07_13_172121_create_images_table | 1 |
| Yes | 2015_07_27_172342_create_chapters_table | 1 |
| Yes | 2015_08_08_200447_add_users_to_entities | 1 |
| Yes | 2015_08_09_093534_create_page_revisions_table | 1 |
| Yes | 2015_08_16_142133_create_activities_table | 1 |
| Yes | 2015_08_29_105422_add_roles_and_permissions | 1 |
| Yes | 2015_08_30_125859_create_settings_table | 1 |
| Yes | 2015_08_31_175240_add_search_indexes | 1 |
| Yes | 2015_09_04_165821_create_social_accounts_table | 1 |
| Yes | 2015_09_05_164707_add_email_confirmation_table | 1 |
| Yes | 2015_11_21_145609_create_views_table | 1 |
| Yes | 2015_11_26_221857_add_entity_indexes | 1 |
| Yes | 2015_12_05_145049_fulltext_weighting | 1 |
| Yes | 2015_12_07_195238_add_image_upload_types | 1 |
| Yes | 2015_12_09_195748_add_user_avatars | 1 |
| Yes | 2016_01_11_210908_add_external_auth_to_users | 1 |
| Yes | 2016_02_25_184030_add_slug_to_revisions | 1 |
| Yes | 2016_02_27_120329_update_permissions_and_roles | 1 |
| Yes | 2016_02_28_084200_add_entity_access_controls | 1 |
| Yes | 2016_03_09_203143_add_page_revision_types | 1 |
| Yes | 2016_03_13_082138_add_page_drafts | 1 |
| Yes | 2016_03_25_123157_add_markdown_support | 1 |
| Yes | 2016_04_09_100730_add_view_permissions_to_roles | 1 |
| Yes | 2016_04_20_192649_create_joint_permissions_table | 1 |
| Yes | 2016_05_06_185215_create_tags_table | 1 |
| Yes | 2016_07_07_181521_add_summary_to_page_revisions | 1 |
| Yes | 2016_09_29_101449_remove_hidden_roles | 1 |
| Yes | 2016_10_09_142037_create_attachments_table | 1 |
| Yes | 2017_01_21_163556_create_cache_table | 1 |
| Yes | 2017_01_21_163602_create_sessions_table | 1 |
| Yes | 2017_03_19_091553_create_search_index_table | 1 |
| Yes | 2017_04_20_185112_add_revision_counts | 1 |
| Yes | 2017_07_02_152834_update_db_encoding_to_ut8mb4 | 1 |
| Yes | 2017_08_01_130541_create_comments_table | 1 |
| Yes | 2017_08_29_102650_add_cover_image_display | 1 |
| Yes | 2018_07_15_173514_add_role_external_auth_id | 1 |
| Yes | 2018_08_04_115700_create_bookshelves_table | 1 |
| Yes | 2019_07_07_112515_add_template_support | 1 |
| Yes | 2019_08_17_140214_add_user_invites_table | 1 |
| Yes | 2019_12_29_120917_add_api_auth | 1 |
| No | 2020_08_04_111754_drop_joint_permissions_id | |
| No | 2020_08_04_131052_remove_role_name_field | |
| No | 2020_09_19_094251_add_activity_indexes | |
+------+--------------------------------------------------+-------+
@minosso commented on GitHub (Nov 6, 2020):
solved with the upgrade command:
#git pull origin release && composer install --no-dev && php artisan migrate