starred/BookStack
1
0
Fork 0
mirror of https://github.com/BookStackApp/BookStack.git synced 2026-02-05 08:39:55 +03:00
Code Issues 784 Packages Projects Releases 10 Wiki Activity

Database error after update to v22.10.1 #3299

New Issue
Closed
opened 2026-02-05 06:17:28 +03:00 by OVERLORD · 2 comments
OVERLORD commented 2026-02-05 06:17:28 +03:00
Owner
Copy Link

Originally created by @InoryS on GitHub (Oct 22, 2022).

Describe the Bug

Update from v22.09 to v22.10.1
implement

git pull origin release
composer install --no-dev
php artisan migrate
php artisan cache:clear
php artisan config:clear
php artisan view:clear

Then got the 500 error.

Steps to Reproduce

1.cd website directory
2.git pull origin release
3.composer install --no-dev
4.php artisan migrate
5.php artisan cache:clear
6.php artisan config:clear
7.php artisan view:clear
8.get 500 error

Expected Behaviour

normal access to the website

Screenshots or Additional Context

error log:

CLICK ME 
2022/10/22 17:55:16 [error] 1241273#0: *14 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'view' in 'where clause' in "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368
Stack trace:
#0 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(368): PDO->prepare()
#1 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#3 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\Database\Connection->run()
#4 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#5 "web_dir"/vendor/laravel/framework/src/Illuminate/Databa...PHP message: PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'view' in 'where clause' in "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368
Stack trace:
#0 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(368): PDO->prepare()
#1 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#3 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\Database\Connection->run()
#4 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#5 "web_dir"/vendor/laravel/framework/src/Illuminate/Databa" while reading resp

Browser Details

No response

Exact BookStack Version

v22.09 to v22.10.1

PHP Version

PHP 8.1.7

Hosting Environment

RHEL 8
6.0.0-1.el8.elrepo.x86_64
nginx version: nginx/1.23.1

Originally created by @InoryS on GitHub (Oct 22, 2022). ### Describe the Bug Update from v22.09 to v22.10.1 implement ``` git pull origin release composer install --no-dev php artisan migrate php artisan cache:clear php artisan config:clear php artisan view:clear ``` Then got the 500 error. ### Steps to Reproduce 1.cd website directory 2.git pull origin release 3.composer install --no-dev 4.php artisan migrate 5.php artisan cache:clear 6.php artisan config:clear 7.php artisan view:clear 8.get 500 error ### Expected Behaviour normal access to the website ### Screenshots or Additional Context error log: <details><summary>CLICK ME</summary> ``` 2022/10/22 17:55:16 [error] 1241273#0: *14 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'view' in 'where clause' in "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368 Stack trace: #0 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(368): PDO->prepare() #1 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback() #3 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\Database\Connection->run() #4 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2414): Illuminate\Database\Connection->select() #5 "web_dir"/vendor/laravel/framework/src/Illuminate/Databa...PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'view' in 'where clause' in "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368 Stack trace: #0 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(368): PDO->prepare() #1 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback() #3 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\Database\Connection->run() #4 "web_dir"/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2414): Illuminate\Database\Connection->select() #5 "web_dir"/vendor/laravel/framework/src/Illuminate/Databa" while reading resp ``` </details> ### Browser Details _No response_ ### Exact BookStack Version v22.09 to v22.10.1 ### PHP Version PHP 8.1.7 ### Hosting Environment RHEL 8 6.0.0-1.el8.elrepo.x86_64 nginx version: nginx/1.23.1
OVERLORD added the 🐛 Bug label 2026-02-05 06:17:28 +03:00
OVERLORD commented 2026-02-05 06:17:34 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Oct 22, 2022):

Hi @InoryS,
I couldn't see any running of the php artisan migrate step in the command output. Are you sure this step was ran?
If so, please confirm the current output of running that update step.

@ssddanbrown commented on GitHub (Oct 22, 2022): Hi @InoryS, I couldn't see any running of the `php artisan migrate` step in the command output. Are you sure this step was ran? If so, please confirm the current output of running that update step.
OVERLORD commented 2026-02-05 06:17:39 +03:00
Author
Owner
Copy Link

@InoryS commented on GitHub (Oct 22, 2022):

Hi @InoryS, I couldn't see any running of the php artisan migrate step in the command output. Are you sure this step was ran? If so, please confirm the current output of running that update step.

Thanks for the quick reply, I'm sorry for any inconvenience.
I'm still editing the github code block, so you did not see update log.
I copied three pieces of updated code directly from the BookStack blog and pasted directly into ssh, and it seems that somehow php artisan migrate is missing.
I re-executed php artisan migrate which successfully solved the problem.

@InoryS commented on GitHub (Oct 22, 2022): > Hi @InoryS, I couldn't see any running of the `php artisan migrate` step in the command output. Are you sure this step was ran? If so, please confirm the current output of running that update step. Thanks for the quick reply, I'm sorry for any inconvenience. I'm still editing the github code block, so you did not see update log. I copied three pieces of updated code directly from the BookStack blog and pasted directly into ssh, and it seems that somehow `php artisan migrate is missing`. I re-executed `php artisan migrate` which successfully solved the problem.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
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 🐛 Bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/BookStack#3299
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?