mirror of
https://github.com/BookStackApp/BookStack.git
synced 2026-02-05 00:29:48 +03:00
Instance First Run Database Errors #238
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 @nh-mike on GitHub (Jan 18, 2017).
I am setting up an instance on my local machine on wiki.localhost
My Server Environment is as follows;
This install is an instance of XAMPP v3.2.2, and I have Mod_Rewrite installed, enabled and working.
I have followed the installation instructions here, which requires the following:
I have done all of these. An extra step, if not using apache or if htaccess is disabled, create my own rewrite rules, I have skipped because, as mentioned, I am running Apache with Mod_Rewrite enabled.
The problem that I am having now, is that while I should be able to access the website from my web browser now, I am being presented with the Laravel "Whoops, looks like something went wrong." page. I have set APP_DEBUG=true in my /.env file, and it gives me a much more descriptive error.
1/2
PDOException in Connection.php line 333:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'system_name' in 'where clause'
2/2
QueryException in Connection.php line 761:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'system_name' in 'where clause' (SQL: select * from
userswheresystem_name= public limit 1)I have checked my database, and it has been set up and has an administrator record in my users table, but no system_name column.
Short of adding in the column myself or modifying the PHP with no idea what implications it may have further in the code, what can I do? I followed the install instructions to the letter (so I believe), and I would really like to get this project running rather than finding an alternative solution.
@ssddanbrown commented on GitHub (Jan 18, 2017):
Hi @nh-mike, Sorry to hear you're about the issue you're having.
When you run
php artisan migrateis there any error output on the command line?Would you be able to post what's in your
migrationsSQL table?From what you've written it almost seems like some of the latest database migrations have not run.
@nh-mike commented on GitHub (Jan 18, 2017):
Hi
Thanks for your reply.
In deleting all the tables and re-running php artisan migrate, it has created all the tables, most of which were not there previously. I had already done this again but maybe I had not cleared the database correctly or something, as it didn't create the full database again.
This time I am presented with a login page. Thank you very much!
@ssddanbrown commented on GitHub (Jan 18, 2017):
@nh-mike Awesome, Glad to hear that worked!