starred/BookStack
1
0
Fork 0
mirror of https://github.com/BookStackApp/BookStack.git synced 2026-02-05 00:29:48 +03:00
Code Issues 303 Packages Projects Releases 10 Wiki Activity

Errors When updateing to .24.1 -> Database issues #898

New Issue
Closed
opened 2026-02-04 22:46:24 +03:00 by OVERLORD · 12 comments
OVERLORD commented 2026-02-04 22:46:24 +03:00
Owner
Copy Link

Originally created by @s0n- on GitHub (Nov 10, 2018).

Updateing from .20 -> .24.1
Managed to update to .24.1 in the GUI but getting weird errors. So went to reinstall

Ran the command

git pull origin release && composer install && php artisan migrate

Got the error

[Illuminate\Database\QueryException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u
nique' (SQL: insert into role_permissions (name, display_name, created_at, updated_at) values (comment-creat
e-all, Create All Comments, 2018-11-09 21:43:18, 2018-11-09 21:43:18))

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u
nique'

[PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u
nique'

Originally created by @s0n- on GitHub (Nov 10, 2018). Updateing from .20 -> .24.1 Managed to update to .24.1 in the GUI but getting weird errors. So went to reinstall Ran the command git pull origin release && composer install && php artisan migrate Got the error [Illuminate\Database\QueryException] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u nique' (SQL: insert into `role_permissions` (`name`, `display_name`, `created_at`, `updated_at`) values (comment-creat e-all, Create All Comments, 2018-11-09 21:43:18, 2018-11-09 21:43:18)) [Doctrine\DBAL\Driver\PDOException] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u nique' [PDOException] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u nique'
OVERLORD added the 🐕 Support label 2026-02-04 22:46:24 +03:00
OVERLORD commented 2026-02-04 22:46:37 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Nov 10, 2018):

Hi @s0n-,
Sounds like something went wrong on a migration.

Can you run the following command and share the output?:

php artisan migrate:status
@ssddanbrown commented on GitHub (Nov 10, 2018): Hi @s0n-, Sounds like something went wrong on a migration. Can you run the following command and share the output?: ``` php artisan migrate:status ```
OVERLORD commented 2026-02-04 22:46:47 +03:00
Author
Owner
Copy Link

@s0n- commented on GitHub (Nov 10, 2018):

root@dev-wiki:/var/www/bookstack# php artisan migrate:status
+------+--------------------------------------------------+
| Ran? | Migration |
+------+--------------------------------------------------+
| Y | 2014_10_12_000000_create_users_table |
| Y | 2014_10_12_100000_create_password_resets_table |
| Y | 2015_07_12_114933_create_books_table |
| Y | 2015_07_12_190027_create_pages_table |
| Y | 2015_07_13_172121_create_images_table |
| Y | 2015_07_27_172342_create_chapters_table |
| Y | 2015_08_08_200447_add_users_to_entities |
| Y | 2015_08_09_093534_create_page_revisions_table |
| Y | 2015_08_16_142133_create_activities_table |
| Y | 2015_08_29_105422_add_roles_and_permissions |
| Y | 2015_08_30_125859_create_settings_table |
| Y | 2015_08_31_175240_add_search_indexes |
| Y | 2015_09_04_165821_create_social_accounts_table |
| Y | 2015_09_05_164707_add_email_confirmation_table |
| Y | 2015_11_21_145609_create_views_table |
| Y | 2015_11_26_221857_add_entity_indexes |
| Y | 2015_12_05_145049_fulltext_weighting |
| Y | 2015_12_07_195238_add_image_upload_types |
| Y | 2015_12_09_195748_add_user_avatars |
| Y | 2016_01_11_210908_add_external_auth_to_users |
| Y | 2016_02_25_184030_add_slug_to_revisions |
| Y | 2016_02_27_120329_update_permissions_and_roles |
| Y | 2016_02_28_084200_add_entity_access_controls |
| Y | 2016_03_09_203143_add_page_revision_types |
| Y | 2016_03_13_082138_add_page_drafts |
| Y | 2016_03_25_123157_add_markdown_support |
| Y | 2016_04_09_100730_add_view_permissions_to_roles |
| Y | 2016_04_20_192649_create_joint_permissions_table |
| Y | 2016_05_06_185215_create_tags_table |
| Y | 2016_07_07_181521_add_summary_to_page_revisions |
| Y | 2016_09_29_101449_remove_hidden_roles |
| Y | 2016_10_09_142037_create_attachments_table |
| Y | 2017_01_21_163556_create_cache_table |
| Y | 2017_01_21_163602_create_sessions_table |
| Y | 2017_03_19_091553_create_search_index_table |
| Y | 2017_04_20_185112_add_revision_counts |
| Y | 2017_07_02_152834_update_db_encoding_to_ut8mb4 |
| N | 2017_08_01_130541_create_comments_table |
| N | 2017_08_29_102650_add_cover_image_display |
| N | 2018_07_15_173514_add_role_external_auth_id |
| N | 2018_08_04_115700_create_bookshelves_table |
+------+--------------------------------------------------+

@s0n- commented on GitHub (Nov 10, 2018): root@dev-wiki:/var/www/bookstack# php artisan migrate:status +------+--------------------------------------------------+ | Ran? | Migration | +------+--------------------------------------------------+ | Y | 2014_10_12_000000_create_users_table | | Y | 2014_10_12_100000_create_password_resets_table | | Y | 2015_07_12_114933_create_books_table | | Y | 2015_07_12_190027_create_pages_table | | Y | 2015_07_13_172121_create_images_table | | Y | 2015_07_27_172342_create_chapters_table | | Y | 2015_08_08_200447_add_users_to_entities | | Y | 2015_08_09_093534_create_page_revisions_table | | Y | 2015_08_16_142133_create_activities_table | | Y | 2015_08_29_105422_add_roles_and_permissions | | Y | 2015_08_30_125859_create_settings_table | | Y | 2015_08_31_175240_add_search_indexes | | Y | 2015_09_04_165821_create_social_accounts_table | | Y | 2015_09_05_164707_add_email_confirmation_table | | Y | 2015_11_21_145609_create_views_table | | Y | 2015_11_26_221857_add_entity_indexes | | Y | 2015_12_05_145049_fulltext_weighting | | Y | 2015_12_07_195238_add_image_upload_types | | Y | 2015_12_09_195748_add_user_avatars | | Y | 2016_01_11_210908_add_external_auth_to_users | | Y | 2016_02_25_184030_add_slug_to_revisions | | Y | 2016_02_27_120329_update_permissions_and_roles | | Y | 2016_02_28_084200_add_entity_access_controls | | Y | 2016_03_09_203143_add_page_revision_types | | Y | 2016_03_13_082138_add_page_drafts | | Y | 2016_03_25_123157_add_markdown_support | | Y | 2016_04_09_100730_add_view_permissions_to_roles | | Y | 2016_04_20_192649_create_joint_permissions_table | | Y | 2016_05_06_185215_create_tags_table | | Y | 2016_07_07_181521_add_summary_to_page_revisions | | Y | 2016_09_29_101449_remove_hidden_roles | | Y | 2016_10_09_142037_create_attachments_table | | Y | 2017_01_21_163556_create_cache_table | | Y | 2017_01_21_163602_create_sessions_table | | Y | 2017_03_19_091553_create_search_index_table | | Y | 2017_04_20_185112_add_revision_counts | | Y | 2017_07_02_152834_update_db_encoding_to_ut8mb4 | | N | 2017_08_01_130541_create_comments_table | | N | 2017_08_29_102650_add_cover_image_display | | N | 2018_07_15_173514_add_role_external_auth_id | | N | 2018_08_04_115700_create_bookshelves_table | +------+--------------------------------------------------+
OVERLORD commented 2026-02-04 22:46:53 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Nov 10, 2018):

@s0n- Thanks, Looks like the comments table did not migrate properly.

If you can get access to the database the below SQL can hopefully clean up any issues. You'll need to change the first line if you're database is not named bookstack.

Ensure the database is backed up before running

USE bookstack;
DROP TABLE IF EXISTS comments;
DELETE FROM role_permissions where name LIKE "comment-%";

Afterwards you can retry running php artisan migrate. Please note any errors that show the first time you run this since they should identify the issue if still existing.

@ssddanbrown commented on GitHub (Nov 10, 2018): @s0n- Thanks, Looks like the comments table did not migrate properly. If you can get access to the database the below SQL can hopefully clean up any issues. You'll need to change the first line if you're database is not named `bookstack`. **Ensure the database is backed up before running** ```sql USE bookstack; DROP TABLE IF EXISTS comments; DELETE FROM role_permissions where name LIKE "comment-%"; ``` Afterwards you can retry running `php artisan migrate`. Please note any errors that show the **first** time you run this since they should identify the issue if still existing.
OVERLORD commented 2026-02-04 22:47:05 +03:00
Author
Owner
Copy Link

@s0n- commented on GitHub (Nov 10, 2018):

Ran the commands - it deleted 6 entries under role_permissions

Re-ran and got the same error

[Illuminate\Database\QueryException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u
nique' (SQL: insert into role_permissions (name, display_name, created_at, updated_at) values (comment-creat
e-all, Create All Comments, 2018-11-09 22:15:43, 2018-11-09 22:15:43))

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u
nique'

[PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u
nique'

With the same status
| N | 2017_08_01_130541_create_comments_table |
| N | 2017_08_29_102650_add_cover_image_display |
| N | 2018_07_15_173514_add_role_external_auth_id |
| N | 2018_08_04_115700_create_bookshelves_table |
+------+--------------------------------------------------+

@s0n- commented on GitHub (Nov 10, 2018): Ran the commands - it deleted 6 entries under role_permissions Re-ran and got the same error [Illuminate\Database\QueryException] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u nique' (SQL: insert into `role_permissions` (`name`, `display_name`, `created_at`, `updated_at`) values (comment-creat e-all, Create All Comments, 2018-11-09 22:15:43, 2018-11-09 22:15:43)) [Doctrine\DBAL\Driver\PDOException] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u nique' [PDOException] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u nique' With the same status | N | 2017_08_01_130541_create_comments_table | | N | 2017_08_29_102650_add_cover_image_display | | N | 2018_07_15_173514_add_role_external_auth_id | | N | 2018_08_04_115700_create_bookshelves_table | +------+--------------------------------------------------+
OVERLORD commented 2026-02-04 22:47:11 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Nov 10, 2018):

This is really strange, I don't know why you'd already have a duplicate entry if you just deleted them.

Can you run the above SQL commands again but, before migrating, run the following SQL command to check if you have existing comment permissions. This should return no results:

USE bookstack;
SELECT * from role_permissions where name LIKE "comment-%";
@ssddanbrown commented on GitHub (Nov 10, 2018): This is really strange, I don't know why you'd already have a duplicate entry if you just deleted them. Can you run the above SQL commands again but, before migrating, run the following SQL command to check if you have existing comment permissions. This should return no results: ```sql USE bookstack; SELECT * from role_permissions where name LIKE "comment-%"; ```
OVERLORD commented 2026-02-04 22:47:16 +03:00
Author
Owner
Copy Link

@s0n- commented on GitHub (Nov 10, 2018):

mysql> USE bookstack;
Database changed
mysql> SELECT * from role_permissions where name LIKE "comment-%";
Empty set (0.00 sec)

php artisan migrate

[Illuminate\Database\QueryException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u
nique' (SQL: insert into role_permissions (name, display_name, created_at, updated_at) values (comment-creat
e-all, Create All Comments, 2018-11-09 22:31:14, 2018-11-09 22:31:14))

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u
nique'

[PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u
nique'

Also for good measure

ysql> show tables;
+---------------------+
| Tables_in_bookstack |
+---------------------+
| activities |
| attachments |
| books |
| cache |
| chapters |
| email_confirmations |
| entity_permissions |
| images |
| joint_permissions |
| migrations |
| page_revisions |
| pages |
| password_resets |
| permission_role |
| role_permissions |
| role_user |
| roles |
| search_terms |
| sessions |
| settings |
| social_accounts |
| tags |
| users |
| views |
+---------------------+
24 rows in set (0.00 sec)

mysql> select * from role_permissions;
+----+-------------------------+------------------------------------------+-------------+---------------------+---------------------+
| id | name | display_name | description | created_at | updated_at |
+----+-------------------------+------------------------------------------+-------------+---------------------+---------------------+
| 19 | settings-manage | Manage Settings | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 20 | users-manage | Manage Users | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 21 | user-roles-manage | Manage Roles & Permissions | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 22 | restrictions-manage-all | Manage All Entity Permissions | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 23 | restrictions-manage-own | Manage Entity Permissions On Own Content | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 24 | book-create-all | Create All Books | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 25 | book-create-own | Create Own Books | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 26 | book-update-all | Update All Books | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 27 | book-update-own | Update Own Books | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 28 | book-delete-all | Delete All Books | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 29 | book-delete-own | Delete Own Books | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 30 | page-create-all | Create All Pages | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 31 | page-create-own | Create Own Pages | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 32 | page-update-all | Update All Pages | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 33 | page-update-own | Update Own Pages | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 34 | page-delete-all | Delete All Pages | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 35 | page-delete-own | Delete Own Pages | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 36 | chapter-create-all | Create All Chapters | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 37 | chapter-create-own | Create Own Chapters | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 38 | chapter-update-all | Update All Chapters | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 39 | chapter-update-own | Update Own Chapters | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 40 | chapter-delete-all | Delete All Chapters | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 41 | chapter-delete-own | Delete Own Chapters | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 42 | image-create-all | Create All Images | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 43 | image-create-own | Create Own Images | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 44 | image-update-all | Update All Images | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 45 | image-update-own | Update Own Images | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 46 | image-delete-all | Delete All Images | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 47 | image-delete-own | Delete Own Images | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 |
| 48 | book-view-all | View All Books | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 |
| 49 | book-view-own | View Own Books | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 |
| 50 | page-view-all | View All Pages | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 |
| 51 | page-view-own | View Own Pages | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 |
| 52 | chapter-view-all | View All Chapters | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 |
| 53 | chapter-view-own | View Own Chapters | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 |
| 54 | attachment-create-all | Create All Attachments | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 |
| 55 | attachment-create-own | Create Own Attachments | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 |
| 56 | attachment-update-all | Update All Attachments | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 |
| 57 | attachment-update-own | Update Own Attachments | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 |
| 58 | attachment-delete-all | Delete All Attachments | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 |
| 59 | attachment-delete-own | Delete Own Attachments | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 |
+----+-------------------------+------------------------------------------+-------------+---------------------+---------------------+
41 rows in set (0.00 sec)

@s0n- commented on GitHub (Nov 10, 2018): mysql> USE bookstack; Database changed mysql> SELECT * from role_permissions where name LIKE "comment-%"; Empty set (0.00 sec) php artisan migrate [Illuminate\Database\QueryException] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u nique' (SQL: insert into `role_permissions` (`name`, `display_name`, `created_at`, `updated_at`) values (comment-creat e-all, Create All Comments, 2018-11-09 22:31:14, 2018-11-09 22:31:14)) [Doctrine\DBAL\Driver\PDOException] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u nique' [PDOException] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'comment-create-all' for key 'permissions_name_u nique' Also for good measure ysql> show tables; +---------------------+ | Tables_in_bookstack | +---------------------+ | activities | | attachments | | books | | cache | | chapters | | email_confirmations | | entity_permissions | | images | | joint_permissions | | migrations | | page_revisions | | pages | | password_resets | | permission_role | | role_permissions | | role_user | | roles | | search_terms | | sessions | | settings | | social_accounts | | tags | | users | | views | +---------------------+ 24 rows in set (0.00 sec) mysql> select * from role_permissions; +----+-------------------------+------------------------------------------+-------------+---------------------+---------------------+ | id | name | display_name | description | created_at | updated_at | +----+-------------------------+------------------------------------------+-------------+---------------------+---------------------+ | 19 | settings-manage | Manage Settings | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 20 | users-manage | Manage Users | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 21 | user-roles-manage | Manage Roles & Permissions | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 22 | restrictions-manage-all | Manage All Entity Permissions | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 23 | restrictions-manage-own | Manage Entity Permissions On Own Content | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 24 | book-create-all | Create All Books | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 25 | book-create-own | Create Own Books | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 26 | book-update-all | Update All Books | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 27 | book-update-own | Update Own Books | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 28 | book-delete-all | Delete All Books | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 29 | book-delete-own | Delete Own Books | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 30 | page-create-all | Create All Pages | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 31 | page-create-own | Create Own Pages | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 32 | page-update-all | Update All Pages | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 33 | page-update-own | Update Own Pages | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 34 | page-delete-all | Delete All Pages | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 35 | page-delete-own | Delete Own Pages | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 36 | chapter-create-all | Create All Chapters | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 37 | chapter-create-own | Create Own Chapters | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 38 | chapter-update-all | Update All Chapters | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 39 | chapter-update-own | Update Own Chapters | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 40 | chapter-delete-all | Delete All Chapters | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 41 | chapter-delete-own | Delete Own Chapters | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 42 | image-create-all | Create All Images | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 43 | image-create-own | Create Own Images | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 44 | image-update-all | Update All Images | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 45 | image-update-own | Update Own Images | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 46 | image-delete-all | Delete All Images | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 47 | image-delete-own | Delete Own Images | NULL | 2017-11-07 17:50:43 | 2017-11-07 17:50:43 | | 48 | book-view-all | View All Books | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 | | 49 | book-view-own | View Own Books | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 | | 50 | page-view-all | View All Pages | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 | | 51 | page-view-own | View Own Pages | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 | | 52 | chapter-view-all | View All Chapters | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 | | 53 | chapter-view-own | View Own Chapters | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 | | 54 | attachment-create-all | Create All Attachments | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 | | 55 | attachment-create-own | Create Own Attachments | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 | | 56 | attachment-update-all | Update All Attachments | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 | | 57 | attachment-update-own | Update Own Attachments | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 | | 58 | attachment-delete-all | Delete All Attachments | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 | | 59 | attachment-delete-own | Delete Own Attachments | NULL | 2017-11-07 17:50:45 | 2017-11-07 17:50:45 | +----+-------------------------+------------------------------------------+-------------+---------------------+---------------------+ 41 rows in set (0.00 sec)
OVERLORD commented 2026-02-04 22:47:24 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Nov 10, 2018):

Even more strange...

You definitely don't have multiple bookstack databases in MySQL?
That's the only thing I can think of now, If your manual commands are running against a different database to BookStack when you run migrate.

@ssddanbrown commented on GitHub (Nov 10, 2018): Even more strange... You definitely don't have multiple bookstack databases in MySQL? That's the only thing I can think of now, If your manual commands are running against a different database to BookStack when you run `migrate`.
OVERLORD commented 2026-02-04 22:47:25 +03:00
Author
Owner
Copy Link

@s0n- commented on GitHub (Nov 10, 2018):

unfortunately not - this is just our dev server before we upgrade our production but not looking good.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| bookstack |
| mysql |
| performance_schema |
| sys |
+--------------------+

@s0n- commented on GitHub (Nov 10, 2018): unfortunately not - this is just our dev server before we upgrade our production but not looking good. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | bookstack | | mysql | | performance_schema | | sys | +--------------------+
OVERLORD commented 2026-02-04 22:47:30 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Nov 10, 2018):

It's strange that the comments migration hasn't run thinking about it, Since that was included from v0.18.
Indicates an error occurred on your previous update to v0.20. Possibly an issue caused by the DB encoding migration? I'm at a loss as to why that particular error shows though.

@ssddanbrown commented on GitHub (Nov 10, 2018): It's strange that the comments migration hasn't run thinking about it, Since that was included from v0.18. Indicates an error occurred on your previous update to v0.20. Possibly an issue caused by the DB encoding migration? I'm at a loss as to why that particular error shows though.
OVERLORD commented 2026-02-04 22:47:35 +03:00
Author
Owner
Copy Link

@s0n- commented on GitHub (Nov 10, 2018):

Ok talked to the sysadmin and looks like you were right - we moved to RDS from our local mysql - ran though and got this now

[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes. (SQL: alter table bookshelves add index bookshelves_slu g_index(slug))

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes.

[PDOException]
SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes.

Which looks a bit more interesting.

@s0n- commented on GitHub (Nov 10, 2018): Ok talked to the sysadmin and looks like you were right - we moved to RDS from our local mysql - ran though and got this now [Illuminate\Database\QueryException] SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes. (SQL: alter table `bookshelves` add index `bookshelves_slu g_index`(`slug`)) [Doctrine\DBAL\Driver\PDOException] SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes. [PDOException] SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes. Which looks a bit more interesting.
OVERLORD commented 2026-02-04 22:47:44 +03:00
Author
Owner
Copy Link

@s0n- commented on GitHub (Nov 10, 2018):

adding some additional context after talking it out with one of my guys. We are using the barracuda file format

innodb_file_format=Barracuda
innodb_large_prefix=1

Came across a laravel post that says we can change this.

config/database.php to use 'engine' => 'innodb row_format=dynamic
from here https://github.com/BookStackApp/BookStack/issues/727

Looks like it worked - fixed

@s0n- commented on GitHub (Nov 10, 2018): adding some additional context after talking it out with one of my guys. We are using the barracuda file format innodb_file_format=Barracuda innodb_large_prefix=1 Came across a laravel post that says we can change this. config/database.php to use 'engine' => 'innodb row_format=dynamic from here https://github.com/BookStackApp/BookStack/issues/727 Looks like it worked - fixed
OVERLORD commented 2026-02-04 22:47:56 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Nov 10, 2018):

@s0n- Awesome, Glad to hear you got things working!

@ssddanbrown commented on GitHub (Nov 10, 2018): @s0n- Awesome, Glad to hear you got things working!
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
🎨 Design
📖 Docs Update
🐛 Bug
🐛 Bug
:cat2:🐈 Possible duplicate
💿 Database
☕ Open to discussion
💻 Front-End
🐕 Support
🚪 Authentication
🌍 Translations
🔌 API Task
🏭 Back-End
⛲ Upstream
🔨 Feature Request
🛠️ Enhancement
🛠️ Enhancement
🛠️ Enhancement
❤️ Happy feedback
🔒 Security
🔍 Pending Validation
💆 UX
📝 WYSIWYG Editor
🌔 Out of scope
🔩 API Request
:octocat: Admin/Meta
🖌️ View Customization
❓ Question
🚀 Priority
🛡️ Blocked
🚚 Export System
♿ A11y
🔧 Maintenance
> Markdown Editor
No Label 🐕 Support
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/BookStack#898
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?