mirror of
https://github.com/BookStackApp/BookStack.git
synced 2026-07-17 05:33:47 +03:00
Error saving / updating pages #362
Closed
opened 2026-02-04 19:01:44 +03:00 by OVERLORD
·
8 comments
No Branch/Tag Specified
development
l10n_development
release
snyk-action
ci_and_static
mfa_key
phpstan_june26
MilnerMart/development
GamerClassN7/impersonations-for-admin
Zhey-on/feature/csp-image-css-controls-6033
tortillas5/development
llm_only
vectors
McTom234/oidc-key-algorithms
captcha_example
v26.05.2
v26.05.1
v26.05
v26.03.5
v26.03.4
v26.03.3
v26.03.2
v26.03.1
v26.03
v25.12.9
v25.12.8
v25.12.7
v25.12.6
v25.12.5
v25.12.4
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
pull-request
Mirrored from GitHub Pull Request
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#362
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 @the4ndy on GitHub (Jun 27, 2017).
For Bug Reports
I had setup Bookstack and have been using it since prior to the update that had user management. I then updated to the latest version (this was a week or so ago). Since then, I have not been able to save pages. I get an error when saving that says:
There is obviously more to the errors but I cannot paste it all here as it has sensitive information in it. I am going to replicate the error on a page without sensitive information in case more information is needed.
Troubleshooting done
I took my best educated guess and noticed that the column revision_count was not in the pages table, so i added it, this moved us on to a similar error about a column missing from the page_revisions table, added that. Finally i was greeted with an even worse error that i could not deduce and so I started over. Earlier today I went ahead and spun up a new Ubuntu 16.04 VM. I went ahead and ran the installation script. Everything is working. Copy over my backup. Copy the .env file in place (but move the DB password from the fresh install into the restored .env file). copied the public and storage folders back. ran the command to restore the SQL database. From there it was all great. I was able to log in and see the data and access all my pages. However the saving pages bug is still present. Same errors as above.
What should I do? Any help is greatly appreciated. Thanks.
@the4ndy commented on GitHub (Jun 27, 2017):
Here is some more log information i was able to pull from the fancy little PHP debug thing in the footer of the error page:
@the4ndy commented on GitHub (Jun 27, 2017):
Also here is a full copy of the error (With content that is not sensitive)
@ssddanbrown commented on GitHub (Jul 1, 2017):
Hi @the4ndy, Are you running migrations (
php artisan migrate) after updating or restoring past data?From your errors above it just seems the latest migration have not run at all. This can be verified by checking the
migrationstable and comparing it to the filenames in thedatabase/migrations/folder.@the4ndy commented on GitHub (Jul 3, 2017):
I do run the
php artisan migratecommand after the update, however I am not sure that it has ever run successfully. In the past when it runs, I will get big red blocks of errors. I could have sworn I read somewhere that these are ok to ignore and up until recently i have not had any issues at all. I just jumped on to the box again and ran the update. there were some changes that downloaded via the git pull. I noticed that Composer is NOT installed via the Ubuntu 16.04 install script (and when i install Composer manually the command isphp composer.phar installas I cannot runcomposer installas by default, composer does not get added to /usr/bin/ or somewhere in the unix PATH.Here is the error I get when running
php artisan migratefirst as my local user and then again as sudo.@ssddanbrown commented on GitHub (Jul 12, 2017):
Sorry for my late reply. Composer should be installed with the ubuntu install script starting the following point: https://github.com/BookStackApp/devops/blob/master/scripts/installation-ubuntu-16.04.sh#L28
Big red blocks of errors are not usually okay to ignore in regards to BookStack.
The logs above are showing two errors. The first is that php (running as the user executing the command) does not have permission to write to the logs files in
storage. The second is that some tables already exist before the migrations run for those tables. This could happen if tables have manually been changed or themigrationstable is out of sync with the rest of the DB.If you have an original backup from a working instance I'd advise the following steps:
@domainzero commented on GitHub (Aug 4, 2017):
@ssddanbrown Probably good to close this out. It's been 31 days since last reply.
@ssddanbrown commented on GitHub (Aug 4, 2017):
@domainzero Yeah, Thanks for letting me know.
@the4ndy If you're still having issues feel free to continue to comment and it can always be re-opened.
@the4ndy commented on GitHub (Aug 30, 2017):
Hey sorry I couldn't respond to this earlier, I got distracted with other work.
At this point, i revisited the issue I was having with the following steps and sadly am still having issues.
git pull origin release && composer install && php artisan migrate)-- At this point, i get an error that composer is not installed on my machine (I know you said it should be installed via the script, but it doesn't appear to be)
-- install composer via
apt-get install composermysql -u bookstack -p bookstack < bookstack.backup.sqlcommand instructed in the docs page. this succeededphp artisan migrate-- this errors out with the following error:
Let me know if there is anything i can do to revive this, i really dont want to have to copy and paste the data from all my pages / books and manually recreate them in a new instance of the app (that would be painstakingly tedious).