New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Error updating to Ghost 5.80 from 5.23, blog down, please help #19839
Comments
Ok, I managed to solve it manually. The issue is in the script Specifically, in this function:
The problem is the batch size. I guess it does not make sense to have it set to 1000 if the maximum size for batch inserts in MySQL is 500. So lowering to 100 for example does the trick. Now, can you kindly confirm that even by reducing the batch size to 100, all posts would be updated in the database as per the new Ghost 5.80 requirements? (looking at the code, it seems that is the case, but just want to be sure). Thank you. A PR here would be quite easy I guess, just decreasing the limit to 100. |
Issue Summary
Hello, I just updated my Ghost blog from 5.23 to 5.80.
After the update, I tried to restart Ghost, but it fails with this message:
Ghost instance is not running! Starting...
✖ Starting Ghost
A GhostError occurred.
Debug Information:
OS: Debian GNU/Linux, v11
Node Version: v18.19.1
Ghost Version: 5.80.2
Ghost-CLI Version: 1.25.3
Environment: development
Command: 'ghost restart'
mysql Ver 8.0.27 for Linux on x86_64 (MySQL Community Server - GPL)
Steps to Reproduce
Start with an install of v5.23 or below 5.80
Apparently the number of posts can be a cause, so get more than 500 posts.
Run ghost update and ghost restart
Ghost Version
5.80.2
Node.js Version
v18.19.1
How did you install Ghost?
Command line
Database type
MySQL 5.7
Browser & OS version
Chrome, MacOS
Relevant log / error output
Code of Conduct
The text was updated successfully, but these errors were encountered: