mirror of
https://github.com/BookStackApp/BookStack.git
synced 2026-02-08 19:06:06 +03:00
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxxxxxxxxxxxx.users' doesn't exist #4522
Reference in New Issue
Block 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 @simpsoncraig25 on GitHub (Mar 20, 2024).
Attempted Debugging
Searched GitHub Issues
Describe the Scenario
Hello, I am currently trying to install Bookstack on my Cloudways web server - I believe this is possible since Cloudways (Digital Ocean host) offer an out of the box Laravel application install.
I have installed the Bookstack git v23.02-branch inside a folder called "bookstack" within the "public_html" route and changed web root addresses to this location.
I have followed the install steps as best as possible and a webpage does load - although all it says is "Page Not Found. Sorry, The page you were looking for could not be found. If you expected this page to exist, you might not have permission to view it. Image attached. Also the link to Login on this page does reside at "https://phplaravel-817644-4410496.cloudwaysapps.com/bookstack/login" but the same error is shown. So I feel "maybe" the route directory and probably apache business etc is all fine.
The install process appeared all fine and the database connection must be correct since it is now populated with tables. And the table "users" does exist with an admin and public user inside.
I did ask Cloudways support to check permissions, and there were "apparently" fine, as per the install guide. And I have reset on their recommendation (to which still no difference).
I am new to github, Laravel and Bookstack but have some fair web experience. Your support would be much appreciated. Please gudie me where to start and I will jump! Your help much appreciated.
FYI - I wanted a web install to future users can access the Bookstack wiki inside and remotely from the work place.
Regards Craig
Exact BookStack Version
v23.02-branch
Log Content
Next Illuminate\View\ViewException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pjnmkcfctz.users' doesn't exist (SQL: select * from
userswheresystem_name= public limit 1) (View: /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/resources/views/layouts/base.blade.php) (View: /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/resources/views/layouts/base.blade.php) in /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760Stack trace:
#0 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php(60): Illuminate\View\Engines\CompilerEngine->handleViewException()
#1 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php(70): Illuminate\View\Engines\PhpEngine->evaluatePath()
#2 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/View/View.php(195): Illuminate\View\Engines\CompilerEngine->get()
#3 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/View/View.php(178): Illuminate\View\View->getContents()
#4 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/View/View.php(147): Illuminate\View\View->renderContents()
#5 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/Http/Response.php(69): Illuminate\View\View->render()
#6 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/Http/Response.php(35): Illuminate\Http\Response->setContent()
#7 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/Routing/ResponseFactory.php(57): Illuminate\Http\Response->__construct()
#8 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/Routing/ResponseFactory.php(87): Illuminate\Routing\ResponseFactory->make()
#9 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Exceptions/Handler.php(629): Illuminate\Routing\ResponseFactory->view()
#10 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Exceptions/Handler.php(554): Illuminate\Foundation\Exceptions\Handler->renderHttpException()
#11 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Exceptions/Handler.php(460): Illuminate\Foundation\Exceptions\Handler->prepareResponse()
#12 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Exceptions/Handler.php(377): Illuminate\Foundation\Exceptions\Handler->renderExceptionResponse()
#13 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/app/Exceptions/Handler.php(66): Illuminate\Foundation\Exceptions\Handler->render()
#14 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(229): BookStack\Exceptions\Handler->render()
#15 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(206): Illuminate\Foundation\Bootstrap\HandleExceptions->renderHttpResponse()
#16 /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(266): Illuminate\Foundation\Bootstrap\HandleExceptions->handleException()
#17 [internal function]: Illuminate\Foundation\Bootstrap\HandleExceptions->Illuminate\Foundation\Bootstrap\{closure}()
#18 {main}
thrown at /home/817644.cloudwaysapps.com/pjnmkcfctz/public_html/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760)
[stacktrace]
#0 {main}
"}
Hosting Environment
PHP 8.1
MySQL - MariaDB 10.4