mirror of
https://github.com/BookStackApp/BookStack.git
synced 2026-02-05 00:29:48 +03:00
Unable to restore from previous database #2150
Closed
opened 2026-02-05 03:06:52 +03:00 by OVERLORD
·
7 comments
No Branch/Tag Specified
development
l10n_development
further_theme_development
release
llm_only
vectors
v25-11
docker_env
drawio_rendering
user_permissions
ldap_host_failover
svg_image
prosemirror
captcha_example
fix/video-export
v25.12.3
v25.12.2
v25.12.1
v25.12
v25.11.6
v25.11.5
v25.11.4
v24.11.4
v25.11.3
v25.11.2
v25.11.1
v25.11
v25.07.3
v25.07.2
v25.07.1
v25.07
v25.05.2
v25.05.1
v25.05
v25.02.5
v25.02.4
v25.02.3
v25.02.2
v25.02.1
v25.02
v24.12.1
v24.12
v24.10.3
v24.10.2
v24.10.1
v24.10
v24.05.4
v24.05.3
v24.05.2
v24.05.1
v24.05
v24.02.3
v24.02.2
v24.02.1
v24.02
v23.12.3
v23.12.2
v23.12.1
v23.12
v23.10.4
v23.10.3
v23.10.2
v23.10.1
v23.10
v23.08.3
v23.08.2
v23.08.1
v23.08
v23.06.2
v23.06.1
v23.06
v23.05.2
v23.05.1
v23.05
v23.02.3
v23.02.2
v23.02.1
v23.02
v23.01.1
v23.01
v22.11.1
v22.11
v22.10.2
v22.10.1
v22.10
v22.09.1
v22.09
v22.07.3
v22.07.2
v22.07.1
v22.07
v22.06.2
v22.06.1
v22.06
v22.04.2
v22.04.1
v22.04
v22.03.1
v22.03
v22.02.3
v22.02.2
v22.02.1
v22.02
v21.12.5
v21.12.4
v21.12.3
v21.12.2
v21.12.1
v21.12
v21.11.3
v21.11.2
v21.11.1
v21.11
v21.10.3
v21.10.2
v21.10.1
v21.10
v21.08.6
v21.08.5
v21.08.4
v21.08.3
v21.08.2
v21.08.1
v21.08
v21.05.4
v21.05.3
v21.05.2
v21.05.1
v21.05
v21.04.6
v21.04.5
v21.04.4
v21.04.3
v21.04.2
v21.04.1
v21.04
v0.31.8
v0.31.7
v0.31.6
v0.31.5
v0.31.4
v0.31.3
v0.31.2
v0.31.1
v0.31.0
v0.30.7
v0.30.6
v0.30.5
v0.30.4
v0.30.3
v0.30.2
v0.30.1
v0.30.0
v0.29.3
v0.29.2
v0.29.1
v0.29.0
v0.28.3
v0.28.2
v0.28.1
v0.28.0
v0.27.5
v0.27.4
v0.27.3
v0.27.2
v0.27.1
v0.27
v0.26.4
v0.26.3
v0.26.2
v0.26.1
v0.26.0
v0.25.5
v0.25.4
v0.25.3
v0.25.2
v0.25.1
v0.25.0
v0.24.3
v0.24.2
v0.24.1
v0.24.0
v0.23.2
v0.23.1
v0.23.0
v0.22.0
v0.21.0
v0.20.3
v0.20.2
v0.20.1
v0.20.0
v0.19.0
v0.18.5
v0.18.4
v0.18.3
v0.18.2
v0.18.1
v0.18.0
v0.17.4
v0.17.3
v0.17.2
v0.17.1
v0.17.0
v0.16.3
v0.16.2
v0.16.1
v0.16.0
v0.15.3
v0.15.2
v0.15.1
v0.15.0
v0.14.3
v0.14.2
v0.14.1
v0.14.0
v0.13.1
v0.13.0
v0.12.2
v0.12.1
v0.12.0
v0.11.2
v0.11.1
v0.11.0
v0.10.0
v0.9.3
v0.9.2
v0.9.1
v0.9.0
v0.8.2
v0.8.1
v0.8.0
v0.7.6
v0.7.5
v0.7.4
v0.7.3
0.7.2
v.0.7.1
v0.7.0
v0.6.3
v0.6.2
v0.6.1
v0.6.0
v0.5.0
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
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: starred/BookStack#2150
Reference in New Issue
Block a user
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking 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 @eferreira2 on GitHub (Mar 10, 2021).
We recently had a security issue with our bookstack server that required me to rebuild it from the ground up on the latest version.
I followed the instructions provided in this article:
https://www.bookstackapp.com/docs/admin/backup-restore/
However, it has not restored our bookstack instance to a usable state. I am able to log in with an existing user account but all I get is a completely blank webpage.
@ssddanbrown commented on GitHub (Mar 10, 2021):
@eferreira2 A blank white page often indicates a permissions problem, I'd start there.
Otherwise check your
storage/logs/laravel.logfile in addition to php/webserver logs on your system for clues. To be able to provide any further assistance I'd need details of your environment & setup (Operating system, webserver, install method etc..)@eferreira2 commented on GitHub (Mar 10, 2021):
Permissions shouldn't be an issue since I chmod'd everything to 777 out of
sheer frustration. Here's what I get now.
Please use the argument -v to see more details.
administrator@tri-bookstack:/var/www/bookstack$ sudo php artisan migrate -v
Do you really wish to run this command? (yes/no) [no]:
Migrating: 2019_08_17_140214_add_user_invites_table
Illuminate\Database\QueryException : SQLSTATE[42S01]: Base table or
view already exists: 1050 Table 'user_invites' already exists (SQL: create
table
user_invites(idint unsigned not null auto_increment primarykey,
user_idint not null,tokenvarchar(191) not null,created_attimestamp null,
updated_attimestamp null) default character set utf8mb4collate 'utf8mb4_unicode_ci')
at
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669
665| // If an exception occurs when attempting to run a query,
we'll format the error
666| // message to include the bindings with SQL, which will
make this exception a
667| // lot more helpful to the developer instead of just the
database's errors.
668| catch (Exception $e) {
Exception trace:
1 Doctrine\DBAL\Driver\PDOException::("SQLSTATE[42S01]: Base table or
view already exists: 1050 Table 'user_invites' already exists")
/var/www/bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:131
2 PDOException::("SQLSTATE[42S01]: Base table or view already exists:
1050 Table 'user_invites' already exists")
/var/www/bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129
3 PDOStatement::execute()
/var/www/bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129
4 Doctrine\DBAL\Driver\PDOStatement::execute()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:463
5 Illuminate\Database\Connection::Illuminate\Database{closure}()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:662
6 Illuminate\Database\Connection::runQueryCallback()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:629
7 Illuminate\Database\Connection::run()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:464
8 Illuminate\Database\Connection::statement()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:97
9 Illuminate\Database\Schema\Blueprint::build()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:290
10 Illuminate\Database\Schema\Builder::build()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:167
11 Illuminate\Database\Schema\Builder::create()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
12 Illuminate\Support\Facades\Facade::__callStatic()
/var/www/bookstack/database/migrations/2019_08_17_140214_add_user_invites_table.php:21
13 AddUserInvitesTable::up()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:392
14
Illuminate\Database\Migrations\Migrator::Illuminate\Database\Migrations{closure}()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:401
15 Illuminate\Database\Migrations\Migrator::runMigration()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:200
16 Illuminate\Database\Migrations\Migrator::runUp()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:165
17 Illuminate\Database\Migrations\Migrator::runPending()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:110
18 Illuminate\Database\Migrations\Migrator::run()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:71
19 Illuminate\Database\Console\Migrations\MigrateCommand::handle()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
20 Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Container/Util.php:37
21 Illuminate\Container\Util::unwrapIfClosure()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
22 Illuminate\Container\BoundMethod::callBoundMethod()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:37
23 Illuminate\Container\BoundMethod::call()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Container/Container.php:590
24 Illuminate\Container\Container::call()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Console/Command.php:134
25 Illuminate\Console\Command::execute()
/var/www/bookstack/vendor/symfony/console/Command/Command.php:255
26 Symfony\Component\Console\Command\Command::run()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Console/Command.php:121
27 Illuminate\Console\Command::run()
/var/www/bookstack/vendor/symfony/console/Application.php:1009
28 Symfony\Component\Console\Application::doRunCommand()
/var/www/bookstack/vendor/symfony/console/Application.php:273
29 Symfony\Component\Console\Application::doRun()
/var/www/bookstack/vendor/symfony/console/Application.php:149
30 Symfony\Component\Console\Application::run()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Console/Application.php:93
31 Illuminate\Console\Application::run()
/var/www/bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:131
32 Illuminate\Foundation\Console\Kernel::handle()
/var/www/bookstack/artisan:37
On Tue, Mar 9, 2021 at 5:17 PM Dan Brown notifications@github.com wrote:
@eferreira2 commented on GitHub (Mar 10, 2021):
Upon further investigation this appears to be a database schema issue between v.28 and the latest?
From SQL backup
DROP TABLE IF EXISTS
activities;/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE
activities(idint(10) unsigned NOT NULL AUTO_INCREMENT,keyvarchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,extratext COLLATE utf8mb4_unicode_ci NOT NULL,book_idint(11) NOT NULL,user_idint(11) NOT NULL,entity_idint(11) NOT NULL,entity_typevarchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,created_attimestamp NULL DEFAULT NULL,updated_attimestamp NULL DEFAULT NULL,PRIMARY KEY (
id),KEY
activities_book_id_index(book_id),KEY
activities_user_id_index(user_id),KEY
activities_entity_id_index(entity_id)) ENGINE=InnoDB AUTO_INCREMENT=853 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;
From clean database on latest bookstack

@eferreira2 commented on GitHub (Mar 10, 2021):
Even restoring our old database and manually upgrading results in the error above. I really need some help here.
@ssddanbrown commented on GitHub (Mar 10, 2021):
I wouldn't worry about schema differences between your old system and a fresh one, Any differences should be applied when re-running the migrations.
Quick question, Are you migrating the new instance first before restoring your data? If so, don't do this. Restore your backup into the DB without migrating first then migrate afterwards.
@eferreira2 commented on GitHub (Mar 11, 2021):
I was restoring before migrating. The issue is that the upgrade kept hanging because it wouldn't delete specific tables in the database and kept erroring because of it. The api_tokens and user_views tables had to be manually deleted before the update would succeed.
@gchamon commented on GitHub (May 27, 2021):
I know this is old, but I just came across this issue and I forced bookstack to skip the
2019_08_17_140214_add_user_invites_tablemigration by adding it to the migrations table manually