Bookstack LXC is not updating

[Salus70]

✅ Have you read and understood the above guidelines?

yes

📜 What is the name of the script you are using?

BookStack LXC

📂 What was the exact command used to execute the script?

update

⚙️ What settings are you using?

• Default Settings
• Advanced Settings

🖥️ Which Linux distribution are you using?

Debian 12

📝 Provide a clear and concise description of the issue.

The Bookstack LXC-Container (v25.2 created with the helper-script) does not update with the "update"-command to v25.02.2 .

🔄 Steps to reproduce the issue.

Type " bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/ct/bookstack.sh)" " in the container-CLI and hit enter.

❌ Paste the full error output (if available).

cp: cannot stat '/opt/bookstack-backup/themes/*': No such file or directory

[ERROR] in line 48: exit code 0: while executing command return 1

🖼️ Additional context (optional).

similar to #1339

[MickLesk]

Create the folder and try again

[Salus70]

Next error:

✔️ Services Stopped
⠹ Updating Bookstack to v25.02.2cp: cannot stat '/opt/bookstack-backup/.env': No such file or directory

[ERROR] in line 41: exit code 0: while executing command cp /opt/bookstack-backup/.env /opt/bookstack/.env

I'll keep trying...

[Salus70]

After a series of errors due to missing files or directories, I copied the entire /opt/bookstack directory to the /opt/bookstack-backup directory.
I got another error, probably because the themes directory is empty?

✔️ Services Stopped
⠋ Updating Bookstack to v25.02.2cp: cannot stat '/opt/bookstack-backup/themes/*': No such file or directory

[ERROR] in line 48: exit code 0: while executing command return 1

[tremor021]

this indicates that they've made some changes to how app is updated and/or installed. We will need to take a look at it

[MickLesk]

@michelroegl-brunner @tremor021 can you take a Look tomorrow?

I seem to remember that @CrazyWolf13 also uses the tool

[Salus70]

I tried to update Bookstack as the issue seemed to be fixed.
I still get an error, this time with less info:

✔️ Services Stopped
⠼ Updating Bookstack to v25.02.5
[ERROR] in line 48: exit code 0: while executing command return 1

Or have I misinterpreted it and the error still exists?

[MickLesk]

Verbose?

[Salus70]

Sorry, of course!:

✔️ Services Stopped
⠴ Updating Bookstack to v25.02.5> @php -r "!file_exists('bootstrap/cache/services.php') || @Unlink('bootstrap/cache/services.php');"
⠦ Updating Bookstack to v25.02.5Installing dependencies from lock file
Verifying lock file contents can be installed on current platform.
Package operations: 108 installs, 0 updates, 0 removals

• Downloading symfony/polyfill-mbstring (v1.32.0)
• Downloading sabberworm/php-css-parser (v8.8.0)
  ⠧ Updating Bookstack to v25.02.5 - Downloading symfony/http-foundation (v7.2.6)
• Downloading guzzlehttp/promises (2.2.0)
• Downloading symfony/polyfill-php80 (v1.32.0)
• Downloading intervention/gif (4.2.2)
• Downloading intervention/image (3.11.2)
• Downloading symfony/process (v7.2.5)
• Downloading symfony/string (v7.2.6)
• Downloading symfony/console (v7.2.6)
• Downloading laravel/serializable-closure (v2.0.4)
• Downloading guzzlehttp/psr7 (2.7.1)
• Downloading guzzlehttp/guzzle (7.9.3)
• Downloading vlucas/phpdotenv (v5.6.2)
• Downloading symfony/var-dumper (v7.2.6)
• Downloading symfony/polyfill-intl-idn (v1.32.0)
• Downloading symfony/mime (v7.2.6)
• Downloading egulias/email-validator (4.0.4)
• Downloading symfony/error-handler (v7.2.5)
• Downloading symfony/http-kernel (v7.2.6)
• Downloading ramsey/collection (2.1.1)
• Downloading brick/math (0.12.3)
• Downloading nunomaduro/termwind (v2.3.1)
• Downloading symfony/translation (v7.2.6)
• Downloading nesbot/carbon (3.9.1)
• Downloading monolog/monolog (3.9.0)
• Downloading nette/utils (v4.0.6)
• Downloading league/commonmark (2.7.0)
• Downloading laravel/framework (v11.44.7)
• Downloading firebase/php-jwt (v6.11.1)
• Downloading laravel/socialite (v5.20.0)
• Downloading psy/psysh (v0.12.8)
• Downloading aws/aws-sdk-php (3.343.13)
• Downloading league/oauth2-client (2.8.1)
• Downloading predis/predis (v2.4.0)
• Downloading socialiteproviders/manager (v4.8.1)
• Downloading socialiteproviders/okta (4.5.0)
• Installing aws/aws-crt-php (v1.2.7): Extracting archive
• Installing dasprid/enum (1.0.6): Extracting archive
• Installing bacon/bacon-qr-code (v3.0.1): Extracting archive
  ⠋ Updating Bookstack to v25.02.5 - Installing doctrine/inflector (2.0.10): Extracting archive
• Installing doctrine/lexer (3.0.1): Extracting archive
• Installing masterminds/html5 (2.9.0): Extracting archive
• Installing symfony/polyfill-mbstring (v1.32.0): Extracting archive
• Installing sabberworm/php-css-parser (v8.8.0): Extracting archive
• Installing dompdf/php-svg-lib (1.0.0): Extracting archive
• Installing dompdf/php-font-lib (1.0.1): Extracting archive
• Installing dompdf/dompdf (v3.1.0): Extracting archive
• Installing symfony/polyfill-ctype (v1.32.0): Extracting archive
• Installing webmozart/assert (1.11.0): Extracting archive
• Installing dragonmantank/cron-expression (v3.4.0): Extracting archive
• Installing symfony/polyfill-php83 (v1.32.0): Extracting archive
• Installing symfony/deprecation-contracts (v3.5.1): Extracting archive
• Installing symfony/http-foundation (v7.2.6): Extracting archive
• Installing fruitcake/php-cors (v1.3.0): Extracting archive
• Installing guzzlehttp/promises (2.2.0): Extracting archive
• Installing symfony/polyfill-php80 (v1.32.0): Extracting archive
• Installing guzzlehttp/uri-template (v1.0.4): Extracting archive
• Installing intervention/gif (4.2.2): Extracting archive
• Installing intervention/image (3.11.2): Extracting archive
• Installing symfony/process (v7.2.5): Extracting archive
• Installing psr/log (3.0.2): Extracting archive
• Installing knplabs/knp-snappy (v1.5.1): Extracting archive
• Installing symfony/polyfill-intl-normalizer (v1.32.0): Extracting archive
• Installing symfony/polyfill-intl-grapheme (v1.32.0): Extracting archive
• Installing symfony/string (v7.2.6): Extracting archive
• Installing psr/container (2.0.2): Extracting archive
• Installing symfony/service-contracts (v3.5.1): Extracting archive
• Installing symfony/console (v7.2.6): Extracting archive
  ⠙ Updating Bookstack to v25.02.5 - Installing laravel/prompts (v0.3.5): Extracting archive
• Installing laravel/serializable-closure (v2.0.4): Extracting archive
• Installing paragonie/random_compat (v9.99.100): Extracting archive
• Installing paragonie/constant_time_encoding (v3.0.0): Extracting archive
• Installing phpseclib/phpseclib (3.0.43): Extracting archive
• Installing ralouphie/getallheaders (3.0.3): Extracting archive
• Installing psr/http-message (2.0): Extracting archive
• Installing psr/http-factory (1.1.0): Extracting archive
• Installing guzzlehttp/psr7 (2.7.1): Extracting archive
• Installing psr/http-client (1.0.3): Extracting archive
• Installing guzzlehttp/guzzle (7.9.3): Extracting archive
• Installing league/oauth1-client (v1.11.0): Extracting archive
• Installing voku/portable-ascii (2.0.3): Extracting archive
• Installing phpoption/phpoption (1.9.3): Extracting archive
• Installing graham-campbell/result-type (v1.1.3): Extracting archive
• Installing vlucas/phpdotenv (v5.6.2): Extracting archive
• Installing symfony/css-selector (v7.2.0): Extracting archive
• Installing tijsverkoyen/css-to-inline-styles (v2.3.0): Extracting archive
• Installing symfony/var-dumper (v7.2.6): Extracting archive
• Installing symfony/polyfill-uuid (v1.32.0): Extracting archive
• Installing symfony/uid (v7.2.0): Extracting archive
• Installing symfony/routing (v7.2.3): Extracting archive
• Installing symfony/polyfill-intl-idn (v1.32.0): Extracting archive
• Installing symfony/mime (v7.2.6): Extracting archive
• Installing psr/event-dispatcher (1.0.0): Extracting archive
• Installing symfony/event-dispatcher-contracts (v3.5.1): Extracting archive
• Installing symfony/event-dispatcher (v7.2.0): Extracting archive
• Installing egulias/email-validator (4.0.4): Extracting archive
• Installing ssddanbrown/symfony-mailer (7.2.x-dev e9de8dc): Extracting archive
• Installing symfony/error-handler (v7.2.5): Extracting archive
• Installing symfony/http-kernel (v7.2.6): Extracting archive
• Installing symfony/finder (v7.2.2): Extracting archive
• Installing ramsey/collection (2.1.1): Extracting archive
• Installing brick/math (0.12.3): Extracting archive
• Installing ramsey/uuid (4.7.6): Extracting archive
• Installing psr/simple-cache (3.0.0): Extracting archive
• Installing nunomaduro/termwind (v2.3.1): Extracting archive
• Installing symfony/translation-contracts (v3.5.1): Extracting archive
• Installing symfony/translation (v7.2.6): Extracting archive
• Installing psr/clock (1.0.0): Extracting archive
• Installing symfony/clock (v7.2.0): Extracting archive
• Installing carbonphp/carbon-doctrine-types (3.2.0): Extracting archive
• Installing nesbot/carbon (3.9.1): Extracting archive
• Installing monolog/monolog (3.9.0): Extracting archive
• Installing league/uri-interfaces (7.5.0): Extracting archive
• Installing league/uri (7.5.1): Extracting archive
• Installing league/mime-type-detection (1.16.0): Extracting archive
• Installing league/flysystem-local (3.29.0): Extracting archive
• Installing league/flysystem (3.29.1): Extracting archive
• Installing nette/utils (v4.0.6): Extracting archive
• Installing nette/schema (v1.3.2): Extracting archive
• Installing dflydev/dot-access-data (v3.0.3): Extracting archive
• Installing league/config (v1.2.0): Extracting archive
• Installing league/commonmark (2.7.0): Extracting archive
• Installing laravel/framework (v11.44.7): Extracting archive
• Installing firebase/php-jwt (v6.11.1): Extracting archive
• Installing laravel/socialite (v5.20.0): Extracting archive
• Installing nikic/php-parser (v5.4.0): Extracting archive
• Installing psy/psysh (v0.12.8): Extracting archive
• Installing laravel/tinker (v2.10.1): Extracting archive
• Installing mtdowling/jmespath.php (2.8.0): Extracting archive
• Installing aws/aws-sdk-php (3.343.13): Extracting archive
• Installing league/flysystem-aws-s3-v3 (3.29.0): Extracting archive
• Installing league/html-to-markdown (5.1.1): Extracting archive
• Installing league/oauth2-client (2.8.1): Extracting archive
• Installing robrichards/xmlseclibs (3.1.3): Extracting archive
• Installing onelogin/php-saml (4.2.0): Extracting archive
• Installing pragmarx/google2fa (v8.0.3): Extracting archive
• Installing predis/predis (v2.4.0): Extracting archive
• Installing socialiteproviders/manager (v4.8.1): Extracting archive
• Installing socialiteproviders/discord (4.2.0): Extracting archive
• Installing socialiteproviders/gitlab (4.1.0): Extracting archive
• Installing socialiteproviders/microsoft-azure (5.2.0): Extracting archive
• Installing socialiteproviders/okta (4.5.0): Extracting archive
• Installing socialiteproviders/twitch (5.4.0): Extracting archive
• Installing ssddanbrown/htmldiff (v1.0.4): Extracting archive
  ⠹ Updating Bookstack to v25.02.5Generating optimized autoload files
  ⠧ Updating Bookstack to v25.02.5> Illuminate\Foundation\ComposerScripts::postAutoloadDump

@php artisan package:discover --ansi
⠋ Updating Bookstack to v25.02.5
INFO Discovering packages.

laravel/socialite ........................................................................................................................... DONE
laravel/tinker .............................................................................................................................. DONE
nesbot/carbon ............................................................................................................................... DONE
nunomaduro/termwind ......................................................................................................................... DONE
socialiteproviders/manager .................................................................................................................. DONE

58 packages you are using are looking for funding.
Use the composer fund command to find out more!
⠙ Updating Bookstack to v25.02.5> @php artisan cache:clear
⠸ Updating Bookstack to v25.02.5
INFO Application cache cleared successfully.

@php artisan view:clear
⠼ Updating Bookstack to v25.02.5
INFO Compiled views cleared successfully.

⠇ Updating Bookstack to v25.02.5
INFO Running migrations.

2025_01_29_180933_create_sort_rules_table ............................................................................................ 3.10ms FAIL

In Connection.php line 825:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sort_rules' already exists (Connection: mysql, SQL: create table sort_rules (id int unsigned not null auto_increment prima
ry key, name varchar(191) not null, sequence text not null, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

In Connection.php line 571:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sort_rules' already exists

⠏ Updating Bookstack to v25.02.5
[ERROR] in line 48: exit code 0: while executing command $STD php artisan migrate --force

[MickLesk]

Its there PHP Database. What an Shit Tool Sometimes...

[Salus70]

Is this something that can be solved via the script or do I have to clarify this with Bookstack myself?

[Salus70]

In case anyone has the same problem again:
After logging into MariaDB and then checking whether the sort_rules table is empty, this solved the problem:

Change in database:

mysql -u root -p
--> Login

USE bookstack;
select * from sort_rules;      (empty)
DROP TABLE sort_rules;
quit;

Then in the directory /opt/bookstack/:
php artisan migrate --force

The script then ran without errors.