updated from 0.20.0 to 0.24.2, bookshelves don't exist #915

New Issue

OVERLORD · 2026-02-04T22:54:12+03:00

OVERLORD commented

2026-02-04 22:54:12 +03:00

Originally created by @jasoncheng7115 on GitHub (Nov 17, 2018).

Hello,
I updated from 0.20.0 to 0.24.2, bookshelves don't exist.

The first case
I set the Application Homepage to "set", and when I enter the Homepage, I will see "An unknown error occurred".

Second case
This error message appears in the log file:
[2018-11-17 15:50:27] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstack.bookshelves' doesn't exist (SQL: select id, restricted, created_by from bookshelves order by bookshelves.id asc limit 50 offset 0) {"exception":"[object] (Illuminate\Database\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstack.bookshelves' doesn't exist (SQL: select id, restricted, created_by from bookshelves order by bookshelves.id asc limit 50 offset 0) at /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Doctrine\DBAL\Driver\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstack.bookshelves' doesn't exist at /var/www/bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:79, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstack.bookshelves' doesn't exist at /var/www/bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:77)

Originally created by @jasoncheng7115 on GitHub (Nov 17, 2018). Hello, I updated from 0.20.0 to 0.24.2, bookshelves don't exist. **The first case** I set the Application Homepage to "set", and when I enter the Homepage, I will see "An unknown error occurred". **Second case** This error message appears in the log file: [2018-11-17 15:50:27] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstack.bookshelves' doesn't exist (SQL: select `id`, `restricted`, `created_by` from `bookshelves` order by `bookshelves`.`id` asc limit 50 offset 0) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstack.bookshelves' doesn't exist (SQL: select `id`, `restricted`, `created_by` from `bookshelves` order by `bookshelves`.`id` asc limit 50 offset 0) at /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Doctrine\\DBAL\\Driver\\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstack.bookshelves' doesn't exist at /var/www/bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:79, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bookstack.bookshelves' doesn't exist at /var/www/bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:77)

OVERLORD added the 🐕 Support label 2026-02-04 22:54:12 +03:00

OVERLORD closed this issue

2026-02-04 22:54:17 +03:00

OVERLORD commented

2026-02-04 22:54:23 +03:00

@ssddanbrown commented on GitHub (Nov 24, 2018):

Hi @jasoncheng7115, Did you run php artisan migrate when you updated?
Or did you get any errors when running that command at all?

@ssddanbrown commented on GitHub (Nov 24, 2018): Hi @jasoncheng7115, Did you run `php artisan migrate` when you updated? Or did you get any errors when running that command at all?

OVERLORD commented

2026-02-04 22:54:27 +03:00

@jasoncheng7115 commented on GitHub (Nov 26, 2018):

Hooo...

I'll just do PHP artisan migrate one more time,That's normal.
Thank you @ssddanbrown very much for your reply!

@jasoncheng7115 commented on GitHub (Nov 26, 2018): Hooo... I'll just do `PHP artisan migrate` one more time,That's normal. Thank you @ssddanbrown very much for your reply!

OVERLORD commented

2026-02-04 22:54:31 +03:00

@ssddanbrown commented on GitHub (Nov 29, 2018):

@jasoncheng7115 No problem, Happy to hear you got things working.

@ssddanbrown commented on GitHub (Nov 29, 2018): @jasoncheng7115 No problem, Happy to hear you got things working.

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/BookStack#915