starred/BookStack
1
0
Fork 0
mirror of https://github.com/BookStackApp/BookStack.git synced 2026-02-06 00:59:39 +03:00
Code Issues 784 Packages Projects Releases 10 Wiki Activity

[Support Request]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstackapp.mfa_values' doesn't exist #2534

New Issue
Closed
opened 2026-02-05 04:25:45 +03:00 by OVERLORD · 20 comments
OVERLORD commented 2026-02-05 04:25:45 +03:00
Owner
Copy Link

Originally created by @alexgdi on GitHub (Dec 19, 2021).

Attempted Debugging

  • I have read the debugging page

Searched GitHub Issues

  • I have searched GitHub for the issue.

Describe the Scenario

After installing Bookstack I'm open http://localhost:6875/ and get a blank page. I'm enable APP_DEBUG=true and get

Illuminate\Database\QueryException
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstackapp.mfa_values' doesn't exist (SQL: select exists(select * from `mfa_values` where `mfa_values`.`user_id` = 1 and `mfa_values`.`user_id` is not null) as `exists`)

Next, I go to container and run php artisan migrate:status and get

+------+---------------------------------------------------+-------+
| 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     |  
| No   | 2019_07_07_112515_add_template_support            |       |  
| No   | 2019_08_17_140214_add_user_invites_table          |       |  
| No   | 2019_12_29_120917_add_api_auth                    |       |  
| 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            |       |  
| No   | 2020_09_27_210059_add_entity_soft_deletes         |       |  
| No   | 2020_09_27_210528_create_deletions_table          |       |  
| No   | 2020_11_07_232321_simplify_activities_table       |       |  
| No   | 2020_12_30_173528_add_owned_by_field_to_entities  |       |  
| No   | 2021_01_30_225441_add_settings_type_column        |       |
| No   | 2021_03_08_215138_add_user_slug                   |       |
| No   | 2021_05_15_173110_create_favourites_table         |       |
| No   | 2021_06_30_173111_create_mfa_values_table         |       |
| No   | 2021_07_03_085038_add_mfa_enforced_to_roles_table |       |
| No   | 2021_08_28_161743_add_export_role_permission      |       |
| No   | 2021_09_26_044614_add_activities_ip_column        |       |
+------+---------------------------------------------------+-------+

Next I try to run php artisan migrate get

Illuminate\Database\QueryException

  SQLSTATE[HY000] [2002] Connection refused (SQL: alter table `pages` add index `pages_template_index`(`template`))

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:703
    699▕         // If an exception occurs when attempting to run a query, we'll format the error
    700▕         // message to include the bindings with SQL, which will make this exception a
    701▕         // lot more helpful to the developer instead of just the database's errors.
    702▕         catch (Exception $e) {
  ➜ 703▕             throw new QueryException(
    704▕                 $query, $this->prepareBindings($bindings), $e
    705▕             );
    706▕         }
    707▕     }

      +18 vendor frames
  19  database/migrations/2019_07_07_112515_add_template_support.php:20
      Illuminate\Support\Facades\Facade::__callStatic()

      +21 vendor frames
  41  artisan:37
      Illuminate\Foundation\Console\Kernel::handle()

After run php artisan migrate again get

Migrating: 2019_07_07_112515_add_template_support

Illuminate\Database\QueryException

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'template' (SQL: alter table `pages` add `template` tinyint(1) not null default '0')

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:703
    699▕         // If an exception occurs when attempting to run a query, we'll format the error
    700▕         // message to include the bindings with SQL, which will make this exception a
    701▕         // lot more helpful to the developer instead of just the database's errors.
    702▕         catch (Exception $e) {
  ➜ 703▕             throw new QueryException(
    704▕                 $query, $this->prepareBindings($bindings), $e
    705▕             );
    706▕         }
    707▕     }

      +9 vendor frames
  10  database/migrations/2019_07_07_112515_add_template_support.php:20
      Illuminate\Support\Facades\Facade::__callStatic()

      +21 vendor frames
  32  artisan:37
      Illuminate\Foundation\Console\Kernel::handle()

Please help. Thanx.

Exact BookStack Version

v21.11.3

Log Content

laravel.log
error.log
error.log

PHP Version

7.4.26

Hosting Environment

Docker on Windows. Bookstack is installed with LinuxServer.io Docker image.

Originally created by @alexgdi on GitHub (Dec 19, 2021). ### Attempted Debugging - [X] I have read the debugging page ### Searched GitHub Issues - [x] I have searched GitHub for the issue. ### Describe the Scenario After installing Bookstack I'm open http://localhost:6875/ and get a blank page. I'm enable `APP_DEBUG=true` and get ``` Illuminate\Database\QueryException SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstackapp.mfa_values' doesn't exist (SQL: select exists(select * from `mfa_values` where `mfa_values`.`user_id` = 1 and `mfa_values`.`user_id` is not null) as `exists`) ``` Next, I go to container and run `php artisan migrate:status` and get ``` +------+---------------------------------------------------+-------+ | 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 | | No | 2019_07_07_112515_add_template_support | | | No | 2019_08_17_140214_add_user_invites_table | | | No | 2019_12_29_120917_add_api_auth | | | 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 | | | No | 2020_09_27_210059_add_entity_soft_deletes | | | No | 2020_09_27_210528_create_deletions_table | | | No | 2020_11_07_232321_simplify_activities_table | | | No | 2020_12_30_173528_add_owned_by_field_to_entities | | | No | 2021_01_30_225441_add_settings_type_column | | | No | 2021_03_08_215138_add_user_slug | | | No | 2021_05_15_173110_create_favourites_table | | | No | 2021_06_30_173111_create_mfa_values_table | | | No | 2021_07_03_085038_add_mfa_enforced_to_roles_table | | | No | 2021_08_28_161743_add_export_role_permission | | | No | 2021_09_26_044614_add_activities_ip_column | | +------+---------------------------------------------------+-------+ ```` Next I try to run `php artisan migrate` get ``` Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: alter table `pages` add index `pages_template_index`(`template`)) at vendor/laravel/framework/src/Illuminate/Database/Connection.php:703 699▕ // If an exception occurs when attempting to run a query, we'll format the error 700▕ // message to include the bindings with SQL, which will make this exception a 701▕ // lot more helpful to the developer instead of just the database's errors. 702▕ catch (Exception $e) { ➜ 703▕ throw new QueryException( 704▕ $query, $this->prepareBindings($bindings), $e 705▕ ); 706▕ } 707▕ } +18 vendor frames 19 database/migrations/2019_07_07_112515_add_template_support.php:20 Illuminate\Support\Facades\Facade::__callStatic() +21 vendor frames 41 artisan:37 Illuminate\Foundation\Console\Kernel::handle() ``` After run `php artisan migrate` again get ``` Migrating: 2019_07_07_112515_add_template_support Illuminate\Database\QueryException SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'template' (SQL: alter table `pages` add `template` tinyint(1) not null default '0') at vendor/laravel/framework/src/Illuminate/Database/Connection.php:703 699▕ // If an exception occurs when attempting to run a query, we'll format the error 700▕ // message to include the bindings with SQL, which will make this exception a 701▕ // lot more helpful to the developer instead of just the database's errors. 702▕ catch (Exception $e) { ➜ 703▕ throw new QueryException( 704▕ $query, $this->prepareBindings($bindings), $e 705▕ ); 706▕ } 707▕ } +9 vendor frames 10 database/migrations/2019_07_07_112515_add_template_support.php:20 Illuminate\Support\Facades\Facade::__callStatic() +21 vendor frames 32 artisan:37 Illuminate\Foundation\Console\Kernel::handle() ```` Please help. Thanx. ### Exact BookStack Version v21.11.3 ### Log Content [laravel.log](https://github.com/BookStackApp/BookStack/files/7740902/laravel.log) [error.log](https://github.com/BookStackApp/BookStack/files/7740905/error.log) [error.log](https://github.com/BookStackApp/BookStack/files/7740906/error.log) ### PHP Version 7.4.26 ### Hosting Environment Docker on Windows. Bookstack is installed with LinuxServer.io Docker image.
OVERLORD added the 🐕 Support label 2026-02-05 04:25:45 +03:00
OVERLORD commented 2026-02-05 04:25:55 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Dec 19, 2021):

Hi @alexgdi,
It looks like something may have gone wrong part way through a previous migration leaving the database in a state it can't migrate further upon.

We'd need to address the Duplicate column name 'template' issue first, then re-run the migration ensuring any initial errors on re-run are caught since that may be the real reason things have gone wrong here.

Do you have direct access to the database? The template column on the pages table needs to be dropped. Backup the database via a database dump beforehand.

@ssddanbrown commented on GitHub (Dec 19, 2021): Hi @alexgdi, It looks like something may have gone wrong part way through a previous migration leaving the database in a state it can't migrate further upon. We'd need to address the `Duplicate column name 'template'` issue first, then re-run the migration ensuring any initial errors on re-run are caught since that may be the real reason things have gone wrong here. Do you have direct access to the database? The `template` column on the `pages` table needs to be dropped. Backup the database via a database dump beforehand.
OVERLORD commented 2026-02-05 04:25:57 +03:00
Author
Owner
Copy Link

@alexgdi commented on GitHub (Dec 20, 2021):

and ALTER TABLE pages DROP COLUMN template; working. Thank you! I wonder why this happened on a clean bookstack installation. There may be an error in the container image...

@alexgdi commented on GitHub (Dec 20, 2021): and `ALTER TABLE pages DROP COLUMN template;` working. Thank you! I wonder why this happened on a clean bookstack installation. There may be an error in the container image...
OVERLORD commented 2026-02-05 04:26:00 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Dec 21, 2021):

Oh, It was a clean install? That's very odd then, although I think I vaguely remember a similar case with a docker user. Might be some possible network through he container that occurred at that specific time? Who knows, hard to track something like that down.

Since it's now working I'll close this off.

@ssddanbrown commented on GitHub (Dec 21, 2021): Oh, It was a clean install? That's very odd then, although I think I vaguely remember a similar case with a docker user. Might be some possible network through he container that occurred at that specific time? Who knows, hard to track something like that down. Since it's now working I'll close this off.
OVERLORD commented 2026-02-05 04:26:04 +03:00
Author
Owner
Copy Link

@jamolnng commented on GitHub (Mar 11, 2022):

@ssddanbrown I also have this issue with docker, it seems that database/migrations/2019_07_07_112515_add_template_support.php:20 fails on install

Schema::table('pages', function (Blueprint $table) {
            $table->boolean('template')->default(false);
            $table->index('template');
        });

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'template' (SQL: alter table `pages` add `template` tinyint(1) not null default '0')

this causes the program to exit and the tables to not be created, causing subsequent errors. Trying to manually fix, running php artisan migrate:refresh causes another crash at the same line

SQLSTATE[HY000] [2002] Connection refused (SQL: alter table `pages` add index `pages_template_index`(`template`))

@jamolnng commented on GitHub (Mar 11, 2022): @ssddanbrown I also have this issue with docker, it seems that [database/migrations/2019_07_07_112515_add_template_support.php:20](https://github.com/BookStackApp/BookStack/blob/ee6a2339b654d1a4537319fb1548fd311549dfc7/database/migrations/2019_07_07_112515_add_template_support.php#L20) fails on install ```php Schema::table('pages', function (Blueprint $table) { $table->boolean('template')->default(false); $table->index('template'); }); ``` ```SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'template' (SQL: alter table `pages` add `template` tinyint(1) not null default '0')``` this causes the program to exit and the tables to not be created, causing subsequent errors. Trying to manually fix, running `php artisan migrate:refresh` causes another crash at the same line ```SQLSTATE[HY000] [2002] Connection refused (SQL: alter table `pages` add index `pages_template_index`(`template`))```
OVERLORD commented 2026-02-05 04:26:08 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Mar 11, 2022):

@jamolnng

Trying to manually fix, running php artisan migrate:refresh causes another crash at the same line

That command isn't intended to be used to fix this. migrate:refresh can cause loss of database data.

If you need some level of support it'd be better to open a new support issue so we can gather details of your specific instance.

@ssddanbrown commented on GitHub (Mar 11, 2022): @jamolnng > Trying to manually fix, running php artisan migrate:refresh causes another crash at the same line That command isn't intended to be used to fix this. `migrate:refresh` can cause loss of database data. If you need some level of support it'd be better to open a new support issue so we can gather details of your specific instance.
OVERLORD commented 2026-02-05 04:26:10 +03:00
Author
Owner
Copy Link

@jamolnng commented on GitHub (Mar 11, 2022):

@ssddanbrown

This is also a clean install from docker on Debian 11.2.0 amd64

This may be an issue with the way the linuxserver bookstack image is handling the install. Will go look there when I get a chance and open a ticket in whichever repository is causing the issue when i find out

@jamolnng commented on GitHub (Mar 11, 2022): @ssddanbrown This is also a clean install from docker on Debian 11.2.0 amd64 This may be an issue with the way the [linuxserver bookstack image](https://hub.docker.com/r/linuxserver/bookstack) is handling the install. Will go look there when I get a chance and open a ticket in whichever repository is causing the issue when i find out
OVERLORD commented 2026-02-05 04:26:13 +03:00
Author
Owner
Copy Link

@sdkcarlos commented on GitHub (Mar 17, 2022):

For anyone that's trying to test BookStack with Docker and is unable to make it work, this could be of help. I just launched a fresh instance of Docker Bookstack and found a similar issue. In my case, I wasn't able to login to the application, so I decided to run php artisan migrate to fix the database schema, however the following error appeared:

image

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'template' (SQL: alter table `pages` add `template` tinyint(1) not null default '0')

To solve it, I accessed the DB instance, opened MySQL and ran the following query to remove the column that already existed:

ALTER TABLE pages DROP COLUMN template;

It seems as well that Laravel actually caches the config file, so I had to clean it as well because after removing the duplicated column and re-running the migration, I got another error:

SQLSTATE[HY000] [2002] Connection refused (SQL: alter table `activities` add index `activities_ip_index`(`ip`))

image

I fixed it clearing the cache of the configuration files with:

php artisan config:clear

Finally run the migration:

php artisan migrate

It should succeed now. I was able to access Bookstack using the default credentials admin@admin.com and password.

@sdkcarlos commented on GitHub (Mar 17, 2022): For anyone that's trying to test BookStack with Docker and is unable to make it work, this could be of help. I just launched a fresh instance of [Docker Bookstack](https://docs.linuxserver.io/images/docker-bookstack) and found a similar issue. In my case, I wasn't able to login to the application, so I decided to run `php artisan migrate` to fix the database schema, however the following error appeared: ![image](https://user-images.githubusercontent.com/11634719/158835311-a18d9ccc-95fe-4a9a-a70c-22682350e2ad.png) ```bash SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'template' (SQL: alter table `pages` add `template` tinyint(1) not null default '0') ``` To solve it, I accessed the DB instance, opened MySQL and ran the following query to remove the column that already existed: ```sql ALTER TABLE pages DROP COLUMN template; ``` It seems as well that Laravel actually caches the config file, so I had to clean it as well because after removing the duplicated column and re-running the migration, I got another error: ```bash SQLSTATE[HY000] [2002] Connection refused (SQL: alter table `activities` add index `activities_ip_index`(`ip`)) ``` ![image](https://user-images.githubusercontent.com/11634719/158834334-087a86fb-54f4-4519-af4b-524324e90456.png) I fixed it clearing the cache of the configuration files with: `php artisan config:clear` Finally run the migration: `php artisan migrate` It should succeed now. I was able to access Bookstack using the default credentials `admin@admin.com` and `password`.
OVERLORD commented 2026-02-05 04:26:16 +03:00
Author
Owner
Copy Link

@Nicks182 commented on GitHub (Aug 17, 2022):

I know this is a closed issue, but I've been struggling with the exact same issue and getting the exact same error message with a clean setup using the docker containers I pulled today. If I do a search for '1146' under issues quite a few pop up and they are all marked as closed.

Not sure if this is a bookstack issue or a issue with the containers, but the issue seems to still be there either way.

I just wanted a quick local instance for some demo purposes and I'm using Windows 10. sdkcalos post above help me get around it, but I just wanted to make the devs aware. ;)

@Nicks182 commented on GitHub (Aug 17, 2022): I know this is a closed issue, but I've been struggling with the exact same issue and getting the exact same error message with a clean setup using the docker containers I pulled today. If I do a search for '1146' under issues quite a few pop up and they are all marked as closed. Not sure if this is a bookstack issue or a issue with the containers, but the issue seems to still be there either way. I just wanted a quick local instance for some demo purposes and I'm using Windows 10. sdkcalos post above help me get around it, but I just wanted to make the devs aware. ;)
OVERLORD commented 2026-02-05 04:26:18 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Aug 17, 2022):

@Nicks182

I'm using Windows 10

Likely related to https://github.com/linuxserver/docker-bookstack/issues/125

@ssddanbrown commented on GitHub (Aug 17, 2022): @Nicks182 > I'm using Windows 10 Likely related to https://github.com/linuxserver/docker-bookstack/issues/125
OVERLORD commented 2026-02-05 04:26:23 +03:00
Author
Owner
Copy Link

@Nicks182 commented on GitHub (Aug 17, 2022):

I see... obviously it's a windows issue. We would host it properly on Linux anyway. Sorry to bother and thank you.

@Nicks182 commented on GitHub (Aug 17, 2022): > I see... obviously it's a windows issue. We would host it properly on Linux anyway. Sorry to bother and thank you.
OVERLORD commented 2026-02-05 04:26:27 +03:00
Author
Owner
Copy Link

@balalogic commented on GitHub (Dec 6, 2022):

Not sure if it's only a Windows issue. The problem occurs even on WSL2, where Docker is running within the WSL instance, rather than directly on Windows.

@balalogic commented on GitHub (Dec 6, 2022): Not sure if it's only a Windows issue. The problem occurs even on WSL2, where Docker is running within the WSL instance, rather than directly on Windows.
OVERLORD commented 2026-02-05 04:26:32 +03:00
Author
Owner
Copy Link

@balalogic commented on GitHub (Dec 6, 2022):

Not sure if it's only a Windows issue. The problem occurs even on WSL2, where Docker is running within the WSL instance, rather than directly on Windows.

What I mean is that WSL2 uses a Linux VM running on HyperV. The Linux VM effectively isolates Windows from the VM. Docker is installed and running within the Linux VM rather than on the host. So broadly speaking, the error is not "Windows only"

@balalogic commented on GitHub (Dec 6, 2022): > Not sure if it's only a Windows issue. The problem occurs even on WSL2, where Docker is running within the WSL instance, rather than directly on Windows. What I mean is that WSL2 uses a Linux VM running on HyperV. The Linux VM effectively isolates Windows from the VM. Docker is installed and running within the Linux VM rather than on the host. So broadly speaking, the error is not "Windows only"
OVERLORD commented 2026-02-05 04:26:35 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Dec 6, 2022):

@balalogic Sure, but I don't think anyone has said it's a "Windows only" issue, but from what we've seen so far this has only seen to be an issue with windows involved. A Linux docker environment via WSL is not fully insulated from the host, extra layers of abstraction and adaption can always provide extra layers of complexity that can affect things.

@ssddanbrown commented on GitHub (Dec 6, 2022): @balalogic Sure, but I don't think anyone has said it's a "Windows only" issue, but from what we've seen so far this has only seen to be an issue with windows involved. A Linux docker environment via WSL is not fully insulated from the host, extra layers of abstraction and adaption can always provide extra layers of complexity that can affect things.
OVERLORD commented 2026-02-05 04:26:37 +03:00
Author
Owner
Copy Link

@shaig4 commented on GitHub (Jun 30, 2023):

why nobody fix this bug reported 2 years ago?

@shaig4 commented on GitHub (Jun 30, 2023): why nobody fix this bug reported 2 years ago?
OVERLORD commented 2026-02-05 04:26:43 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Jun 30, 2023):

@shaig4 because this occurs in a particular complex stack of technologies where emulation is at play, and many of the software projects involved probably don't see this issue in scope of their support, like I effectively don't for BookStack.

@ssddanbrown commented on GitHub (Jun 30, 2023): @shaig4 because this occurs in a particular complex stack of technologies where emulation is at play, and many of the software projects involved probably don't see this issue in scope of their support, like I effectively don't for BookStack.
OVERLORD commented 2026-02-05 04:26:47 +03:00
Author
Owner
Copy Link

@shaig4 commented on GitHub (Jul 5, 2023):

@ssddanbrown its happening when trying to run it by docker. Fresh without any mounts. Very common case

@shaig4 commented on GitHub (Jul 5, 2023): @ssddanbrown its happening when trying to run it by docker. Fresh without any mounts. Very common case
OVERLORD commented 2026-02-05 04:26:51 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Jul 5, 2023):

@shaig4 Okay. If you find that the particular cause of the issue is within our project feel free to detail the issue within a fresh bug report here, otherwise I wouldn't look to add environment specific workarounds for what are likely external issues.

There are likely some alternative approaches you could likely take. I'd guess that running MySQL natively (out of docker) may help.

@ssddanbrown commented on GitHub (Jul 5, 2023): @shaig4 Okay. If you find that the particular cause of the issue is within our project feel free to detail the issue within a fresh bug report here, otherwise I wouldn't look to add environment specific workarounds for what are likely external issues. There are likely some alternative approaches you could likely take. I'd guess that running MySQL natively (out of docker) may help.
OVERLORD commented 2026-02-05 04:26:53 +03:00
Author
Owner
Copy Link

@garrettHensley commented on GitHub (Apr 25, 2024):

So then is the linuxserver.io install just completely broken then? I've ran into all of the issues above.

@garrettHensley commented on GitHub (Apr 25, 2024): So then is the linuxserver.io install just completely broken then? I've ran into all of the issues above.
OVERLORD commented 2026-02-05 04:26:55 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Apr 25, 2024):

@garrettHensley Nope, but you can run into issues if you have a specific combination of OS and volume storage option as mentioned in the discussions above.

@ssddanbrown commented on GitHub (Apr 25, 2024): @garrettHensley Nope, but you can run into issues if you have a specific combination of OS and volume storage option as mentioned in the discussions above.
OVERLORD commented 2026-02-05 04:27:00 +03:00
Author
Owner
Copy Link

@garrettHensley commented on GitHub (Apr 25, 2024):

Gotcha, makes sense I must fall into that category. I'm running into all the issues above from a clean install.

edit: Yeah, I was able to get it working using the workaround in the linked thread above. Thanks for all your hard work.

@garrettHensley commented on GitHub (Apr 25, 2024): Gotcha, makes sense I must fall into that category. I'm running into all the issues above from a clean install. edit: Yeah, I was able to get it working using the workaround in the linked thread above. Thanks for all your hard work.
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
pull-request
Mirrored from GitHub Pull Request
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#2534
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?