mirror of
https://github.com/BookStackApp/BookStack.git
synced 2026-02-06 09:09:38 +03:00
SQlite: migration failing #524
Reference in New Issue
Block a user
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?
Originally created by @bridgeyuwa on GitHub (Dec 15, 2017).
SQlite: migration failing
*Sqlite
Trying to install bookstack on an Sqlite database
Throwing This Exception
[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 1 Cannot add a NOT NULL column with default
value NULL (SQL: alter table "pages" add column "created_by" integer not n
ull)
[PDOException]
SQLSTATE[HY000]: General error: 1 Cannot add a NOT NULL column with default
value NULL
Steps to Reproduce
Just run "php artisan migrate"
@AbijeetP commented on GitHub (Dec 15, 2017):
BookStack does not support SQLite, only MySQL and by extension, MariaDB is supported.
@bridgeyuwa commented on GitHub (Dec 15, 2017):
Bookstack is built on laravel... it sure can support SQlite. Just Altering the migrations should do that
@ssddanbrown commented on GitHub (Dec 16, 2017):
@bridgeyuwa Thanks for creating this issue.
@AbijeetP is correct. While Laravel does support SQLite, BookStack does currently not.
An issue to add support is already open under #367 so I will close this. I would like to support SQLite at some stage to make setup for smaller instances even easier/more manageable but we do have to take into account the extra amount of testing and maintenance required going forward to add SQLite support.