Issue upgrading to v22.09 from v22.07.3 #3118

Closed
opened 2026-02-05 06:03:45 +03:00 by OVERLORD · 0 comments
Owner

Originally created by @joe-eklund on GitHub (Sep 10, 2022).

Describe the Bug

After upgrading to v22.09 from v22.07.3 I cannot access any of my books. Instead, when I click on them I get An Error Occurred An unknown error occurred (See screenshot below). I get the same behavior when I attempt to login. I have attached the error logs.

Seems like a bug to me, but if anyone has any ideas for me to try please let me know. Thanks!

Rolling back to v22.07.3 and the app fires up as normal and there are no errors in the logs.

Steps to Reproduce

  1. Upgrade to v22.09. :)

Expected Behaviour

I can login and access books without error.

Screenshots or Additional Context

bs_error

cont-init: info: running /etc/cont-init.d/10-adduser
-------------------------------------
          _         ()
         | |  ___   _    __
         | | / __| | |  /  \
         | | \__ \ | | | () |
         |_| |___/ |_|  \__/
Brought to you by linuxserver.io
-------------------------------------
To support LSIO projects visit:
https://www.linuxserver.io/donate/
-------------------------------------
GID/UID
-------------------------------------
User uid:    1000
User gid:    1000
-------------------------------------
cont-init: info: /etc/cont-init.d/10-adduser exited 0
cont-init: info: running /etc/cont-init.d/11-folders
cont-init: info: /etc/cont-init.d/11-folders exited 0
cont-init: info: running /etc/cont-init.d/12-samples
cont-init: info: /etc/cont-init.d/12-samples exited 0
cont-init: info: running /etc/cont-init.d/13-nginx
cont-init: info: /etc/cont-init.d/13-nginx exited 0
cont-init: info: running /etc/cont-init.d/14-php
cont-init: info: /etc/cont-init.d/14-php exited 0
cont-init: info: running /etc/cont-init.d/15-keygen
using keys found in /config/keys
cont-init: info: /etc/cont-init.d/15-keygen exited 0
cont-init: info: running /etc/cont-init.d/20-permissions
cont-init: info: /etc/cont-init.d/20-permissions exited 0
cont-init: info: running /etc/cont-init.d/50-config
New container detected. Setting up app folder and fixing permissions.
App Key found - setting variable for seds
Running config - db_user set
/etc/cont-init.d/50-config: line 103: warning: command substitution: ignored null byte in input
/etc/cont-init.d/50-config: line 103: warning: command substitution: ignored null byte in input
Migrating: 2022_07_16_170051_drop_joint_permission_type
   Illuminate\Database\QueryException 
  SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `PRIMARY`; check that it exists (SQL: alter table `joint_permissions` drop primary key)
  at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712
    708▕         // If an exception occurs when attempting to run a query, we'll format the error
    709▕         // message to include the bindings with SQL, which will make this exception a
    710▕         // lot more helpful to the developer instead of just the database's errors.
    711▕         catch (Exception $e) {
  ➜ 712▕             throw new QueryException(
    713▕                 $query, $this->prepareBindings($bindings), $e
    714▕             );
    715▕         }
    716▕     }
      +9 vendor frames 
  10  /app/www/database/migrations/2022_07_16_170051_drop_joint_permission_type.php:25
      Illuminate\Support\Facades\Facade::__callStatic()
      +22 vendor frames 
  33  /app/www/artisan:37
      Illuminate\Foundation\Console\Kernel::handle()
cont-init: info: /etc/cont-init.d/50-config exited 0
cont-init: info: running /etc/cont-init.d/85-version-checks
**** The following active confs have different version dates than the samples that are shipped. ****
**** This may be due to user customization or an update to the samples. ****
**** You should compare the following files to the samples in the same folder and update them. ****
**** Use the link at the top of the file to view the changelog. ****
/config/nginx/site-confs/default.conf
/config/nginx/nginx.conf
cont-init: info: /etc/cont-init.d/85-version-checks exited 0
cont-init: info: running /etc/cont-init.d/90-custom-folders
cont-init: info: /etc/cont-init.d/90-custom-folders exited 0
cont-init: info: running /etc/cont-init.d/99-custom-files
[custom-init] no custom files found, skipping...
cont-init: info: /etc/cont-init.d/99-custom-files exited 0
s6-rc: info: service legacy-cont-init successfully started
s6-rc: info: service init-mods: starting
s6-rc: info: service init-mods successfully started
s6-rc: info: service init-mods-package-install: starting
s6-rc: info: service init-mods-package-install successfully started
s6-rc: info: service init-mods-end: starting
s6-rc: info: service init-mods-end successfully started
s6-rc: info: service init-services: starting
s6-rc: info: service init-services successfully started
s6-rc: info: service legacy-services: starting
services-up: info: copying legacy longrun cron (no readiness notification)
services-up: info: copying legacy longrun memcached (no readiness notification)
services-up: info: copying legacy longrun nginx (no readiness notification)
services-up: info: copying legacy longrun php-fpm (no readiness notification)
s6-rc: info: service legacy-services successfully started
s6-rc: info: service 99-ci-service-check: starting
[ls.io-init] done.
s6-rc: info: service 99-ci-service-check successfully started

Browser Details

Chrome Version 104.0.5112.102 (Official Build) (64-bit)

Exact BookStack Version

v22.09

PHP Version

No response

Hosting Environment

Docker on Ubuntu 22.04.

Originally created by @joe-eklund on GitHub (Sep 10, 2022). ### Describe the Bug After upgrading to v22.09 from v22.07.3 I cannot access any of my books. Instead, when I click on them I get `An Error Occurred An unknown error occurred` (See screenshot below). I get the same behavior when I attempt to login. I have attached the error logs. Seems like a bug to me, but if anyone has any ideas for me to try please let me know. Thanks! Rolling back to v22.07.3 and the app fires up as normal and there are no errors in the logs. ### Steps to Reproduce 1. Upgrade to v22.09. :) ### Expected Behaviour I can login and access books without error. ### Screenshots or Additional Context ![bs_error](https://user-images.githubusercontent.com/8761687/189462010-69355ee8-b4ce-496a-a4c5-91c0f6efeb8b.png) ``` cont-init: info: running /etc/cont-init.d/10-adduser ------------------------------------- _ () | | ___ _ __ | | / __| | | / \ | | \__ \ | | | () | |_| |___/ |_| \__/ Brought to you by linuxserver.io ------------------------------------- To support LSIO projects visit: https://www.linuxserver.io/donate/ ------------------------------------- GID/UID ------------------------------------- User uid: 1000 User gid: 1000 ------------------------------------- cont-init: info: /etc/cont-init.d/10-adduser exited 0 cont-init: info: running /etc/cont-init.d/11-folders cont-init: info: /etc/cont-init.d/11-folders exited 0 cont-init: info: running /etc/cont-init.d/12-samples cont-init: info: /etc/cont-init.d/12-samples exited 0 cont-init: info: running /etc/cont-init.d/13-nginx cont-init: info: /etc/cont-init.d/13-nginx exited 0 cont-init: info: running /etc/cont-init.d/14-php cont-init: info: /etc/cont-init.d/14-php exited 0 cont-init: info: running /etc/cont-init.d/15-keygen using keys found in /config/keys cont-init: info: /etc/cont-init.d/15-keygen exited 0 cont-init: info: running /etc/cont-init.d/20-permissions cont-init: info: /etc/cont-init.d/20-permissions exited 0 cont-init: info: running /etc/cont-init.d/50-config New container detected. Setting up app folder and fixing permissions. App Key found - setting variable for seds Running config - db_user set /etc/cont-init.d/50-config: line 103: warning: command substitution: ignored null byte in input /etc/cont-init.d/50-config: line 103: warning: command substitution: ignored null byte in input Migrating: 2022_07_16_170051_drop_joint_permission_type Illuminate\Database\QueryException SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `PRIMARY`; check that it exists (SQL: alter table `joint_permissions` drop primary key) at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712 708▕ // If an exception occurs when attempting to run a query, we'll format the error 709▕ // message to include the bindings with SQL, which will make this exception a 710▕ // lot more helpful to the developer instead of just the database's errors. 711▕ catch (Exception $e) { ➜ 712▕ throw new QueryException( 713▕ $query, $this->prepareBindings($bindings), $e 714▕ ); 715▕ } 716▕ } +9 vendor frames 10 /app/www/database/migrations/2022_07_16_170051_drop_joint_permission_type.php:25 Illuminate\Support\Facades\Facade::__callStatic() +22 vendor frames 33 /app/www/artisan:37 Illuminate\Foundation\Console\Kernel::handle() cont-init: info: /etc/cont-init.d/50-config exited 0 cont-init: info: running /etc/cont-init.d/85-version-checks **** The following active confs have different version dates than the samples that are shipped. **** **** This may be due to user customization or an update to the samples. **** **** You should compare the following files to the samples in the same folder and update them. **** **** Use the link at the top of the file to view the changelog. **** /config/nginx/site-confs/default.conf /config/nginx/nginx.conf cont-init: info: /etc/cont-init.d/85-version-checks exited 0 cont-init: info: running /etc/cont-init.d/90-custom-folders cont-init: info: /etc/cont-init.d/90-custom-folders exited 0 cont-init: info: running /etc/cont-init.d/99-custom-files [custom-init] no custom files found, skipping... cont-init: info: /etc/cont-init.d/99-custom-files exited 0 s6-rc: info: service legacy-cont-init successfully started s6-rc: info: service init-mods: starting s6-rc: info: service init-mods successfully started s6-rc: info: service init-mods-package-install: starting s6-rc: info: service init-mods-package-install successfully started s6-rc: info: service init-mods-end: starting s6-rc: info: service init-mods-end successfully started s6-rc: info: service init-services: starting s6-rc: info: service init-services successfully started s6-rc: info: service legacy-services: starting services-up: info: copying legacy longrun cron (no readiness notification) services-up: info: copying legacy longrun memcached (no readiness notification) services-up: info: copying legacy longrun nginx (no readiness notification) services-up: info: copying legacy longrun php-fpm (no readiness notification) s6-rc: info: service legacy-services successfully started s6-rc: info: service 99-ci-service-check: starting [ls.io-init] done. s6-rc: info: service 99-ci-service-check successfully started ``` ### Browser Details Chrome Version 104.0.5112.102 (Official Build) (64-bit) ### Exact BookStack Version v22.09 ### PHP Version _No response_ ### Hosting Environment Docker on Ubuntu 22.04.
OVERLORD added the 🐛 Bug label 2026-02-05 06:03:45 +03:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/BookStack#3118