Hello this is my first time using linuxserver/bookstack and after copied and pasted the code found on dockerhub: Docker, i have problem with bookstack in particular i found in my log this SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘template’ (SQL: alter table pages add template tinyint(1) not null default ‘0’)
2023-12-02 11:10:02
2023-12-02 11:10:02 at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
2023-12-02 11:10:02 756▕ // If an exception occurs when attempting to run a query, we’ll format the error
2023-12-02 11:10:02 757▕ // message to include the bindings with SQL, which will make this exception a
2023-12-02 11:10:02 758▕ // lot more helpful to the developer instead of just the database’s errors.
2023-12-02 11:10:02 759▕ catch (Exception $e) {
2023-12-02 11:10:02 ➜ 760▕ throw new QueryException(
2023-12-02 11:10:02 761▕ $query, $this->prepareBindings($bindings), $e
2023-12-02 11:10:02 762▕ ); How i fix exactly, i search for days and i havem’t any luck
I fix that but now 2020_11_07_232321_simplify_activities_table … 177ms FAIL
2023-12-03 11:50:27
2023-12-03 11:50:27 Doctrine\DBAL\Schema\Exception\ColumnDoesNotExist
2023-12-03 11:50:27
2023-12-03 11:50:27 There is no column with name “key” on table “activities”.
2023-12-03 11:50:27
2023-12-03 11:50:27 at /app/www/vendor/doctrine/dbal/src/Schema/Exception/ColumnDoesNotExist.php:16
2023-12-03 11:50:27 12▕ final class ColumnDoesNotExist extends SchemaException
2023-12-03 11:50:27 13▕ {
2023-12-03 11:50:27 14▕ public static function new(string $columnName, string $table): self
2023-12-03 11:50:27 15▕ {
2023-12-03 11:50:27 ➜ 16▕ return new self(
2023-12-03 11:50:27 17▕ sprintf(‘There is no column with name “%s” on table “%s”.’, $columnName, $table),
2023-12-03 11:50:27 18▕ self::COLUMN_DOESNT_EXIST,
2023-12-03 11:50:27 19▕ );
2023-12-03 11:50:27 20▕ } I have this i had already try to add the column ALTER TABLE activities ADD COLUMN key INTEGER;
ERROR 1177 (42000): Can’t open table i have this message any help?
2023-12-04 10:27:38 SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘type’ (SQL: ALTER TABLE activities CHANGE key type INT DEFAULT NULL)
2023-12-04 10:27:38
2023-12-04 10:27:38 at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
2023-12-04 10:27:38 756▕ // If an exception occurs when attempting to run a query, we’ll format the error
2023-12-04 10:27:38 757▕ // message to include the bindings with SQL, which will make this exception a
2023-12-04 10:27:38 758▕ // lot more helpful to the developer instead of just the database’s errors.
2023-12-04 10:27:38 759▕ catch (Exception $e) {
2023-12-04 10:27:38 ➜ 760▕ throw new QueryException(
2023-12-04 10:27:38 761▕ $query, $this->prepareBindings($bindings), $e
2023-12-04 10:27:38 762▕ );
2023-12-04 10:27:38 763▕ }
2023-12-04 10:27:38 764▕ }
2023-12-04 10:27:38
2023-12-04 10:27:38 +9 vendor frames
2023-12-04 10:27:38 10 /app/www/database/migrations/2020_11_07_232321_simplify_activities_table.php:17
2023-12-04 10:27:38 Illuminate\Support\Facades\Facade::__callStatic()
2023-12-04 10:27:38
2023-12-04 10:27:38 +25 vendor frames
2023-12-04 10:27:38 36 /app/www/artisan:35
2023-12-04 10:27:38 Illuminate\Foundation\Console\Kernel::handle()
2023-12-04 10:27:38 [custom-init] No custom files found, skipping…
2023-12-04 10:27:38 [ls.io-init] done.
I can’t open my table i try everything
I see you opened a thread in the incorrect channel on discord. Bookstack is a container, not a docker mod. You’ve already been directed to the proper location.
In either case, whether you open a thread in the proper discord location or keep it in here, you need to provide your full docker run or docker compose and the full container logs, which begin with our ascii logo. It is also helpful for you to provide the output of uname -mr && docker version && docker compose version