mirror of
https://github.com/BookStackApp/BookStack.git
synced 2026-02-11 03:13:15 +03:00
Permissions not working #1061
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 @madsmka on GitHub (Feb 22, 2019).
Describe the bug
When we are trying to give a role perimssions it will fail to save with the error "An unknown error occurred".
Steps To Reproduce
Expected behavior
I expected it to save the role with the new permission setup.
Screenshots
If applicable, add screenshots to help explain your problem.
Your Configuration (please complete the following information):
Additional context
After trying to upgrade our bookstack from version 0.21 to version 0.25.1 it failed after not being able to use/get composer. I did a restore from our backup, spinned up a new ubuntu 18.04.1 did a sqldump from the old server and restored it into the new server with bookstack version 0.25.1 installed.
We use LDAP to authenticate into our AD.
Error found in Laravel.log:
"[2019-02-22 08:12:08] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'external_auth_id' in 'field list' (SQL: updaterolessetupdated_at= 2019-02-22 08:12:08,external_auth_id= whereid= 1) {"userId":9,"email":"<my mail>","exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'external_auth_id' in 'field list' (SQL: updaterolessetupdated_at= 2019-02-22 08:12:08,external_auth_id= whereid= 1) at /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'external_auth_id' in 'field list' at /var/www/bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:79, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'external_auth_id' in 'field list' at /var/www/bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:77) [stacktrace]"@ssddanbrown commented on GitHub (Feb 22, 2019):
Hi @madsmka,
Sorry to hear you're having issues.
From the issue posted about it looks like your database is not up-to-date.
Have you migrated the database as per the upgrade instructions by running
php artisan migrate.Do you get any errors when running that?
@madsmka commented on GitHub (Feb 25, 2019):
Hello @ssddanbrown
I ran the command and it fixed everything. After reading the restore documentation again I can see that it actually says to run that commmand... I must have missed it. So thank you! :)