Can't seem to enable attachments

[mzw123]

For Bug Reports

• BookStack Version: BookStack v0.16.3
• PHP Version: PHP 5.6.30
• MySQL Version: mysql Ver 15.1 Distrib 5.5.52-MariaDB
  Installed on RHEL7 as per CentOS 7 Install by Deviant Engineer

attachment upload limit set to 10M in php.conf:
post_max_size = 10M
upload_max_filesize = 10M

attachment upload limit set to 10M in nginx.conf:

http {
    client_max_body_size 10m;
    client_body_timeout 120s;
...

/var/www/BookStack/public
drwxrwxrwx. 7 nginx nginx 4096 Jun 15 14:35 public
/var/www/BookStack/storage/uploads
drwxrwxrwx. 3 nginx nginx 4096 Apr 18 14:11 uploads

Expected Behavior

I would be able to set attachment permissions and upload attachments.

Actual Behavior

I do not see the paperclip icon when editing pages so there is no way to open the attachment interface.
When I try to set the attachment permissions in settings/roles the changes are not saved. i.e. I check all the boxes, save the role and they are unchecked when I open the role again.

I'm not sure what I am missing in order to enable attachments. Any help would be appreciated.
Thanks

[ssddanbrown]

Hi @mzw123, I'm assuming your account is an admin account in BookStack? Would you be able to post a screenshot of what the admin role permissions look like?

[mzw123]

I have tried checking all the Attachments boxes but the changes are not saved. Current Admin settings: [cid:image002.jpg@01D2F3DC.D991C750] From: Dan Brown [mailto:notifications@github.com] Sent: Saturday, July 01, 2017 3:09 AM To: BookStackApp/BookStack <BookStack@noreply.github.com> Cc: Warren, Michael Z <mwarren@lanl.gov>; Mention <mention@noreply.github.com> Subject: Re: [BookStackApp/BookStack] Can't seem to enable attachments (#418) Hi @mzw123<https://github.com/mzw123>, I'm assuming your account is an admin account in BookStack? Would you be able to post a screenshot of what the admin role permissions look like? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#418 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/Aa9uz-fKp5QjmO4yu7kYlt6Tb7a8Aacrks5sJgyegaJpZM4OBFxF>.

[mzw123]

Hi @ssddanbrown, Do you have any thoughts on what I could investigate to enable attachments?

[ssddanbrown]

@mzw123 Please try updating to the latest BookStack version. Also, If possible, Please could you post a screenshot of the role configuration for admin users?

[mzw123]

As you can see the attachments aren't enabled. When I select the attachment checkboxes they do not save.

[ssddanbrown]

@mzw123 Could you try enabling attachments on another role? The admin account is handled a little differently so just want to see if things act differently for a non-admin role.

I'm suspecting an upgrade may have gone wrong at some point and you don't have the latest correct role permissions in your database. Definitely all up-to-date when running php artisan migrate. Ever seen errors when running that upon updating?

[mzw123]

I tried updating and did get an error regarding the attachments table:

[Illuminate\Database\QueryException]
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'attachments
' already exists (SQL: create table attachments (id int unsigned not nu
ll auto_increment primary key, name varchar(191) not null, path varchar
(191) not null, extension varchar(20) not null, uploaded_to int not nul
l, external tinyint(1) not null, order int not null, created_by int n
ot null, updated_by int not null, created_at timestamp null, updated_a t timestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci
)

[PDOException]
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'attachments
' already exists

[ssddanbrown]

@mzw123 Okay, That indicates that something wrong has occurred on a previous update and, as per my previous comment, You don't have the latest permission options in your system.

Sorting this out might be tricky as it's hard to know what the original issue is. In your database, You can try manually dropping the attachments table and then re-running the migrate. Please backup first and note any errors.

[mzw123]

This may stem from the fact that I originally started with a docker install that broke when I patched the server it was on. I rebuilt the app outside of docker and added back the db and files from the docker installation.

I dropped the attachments table and re-ran the update. I got the following error:

[Illuminate\Database\QueryException]
SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO) (SQL: select * from
information_schema.tables where table_schema = forge and table_name = migrations)

[PDOException]
SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO)

[Abijeet]

Under the instructions section on the page here - https://www.bookstackapp.com/docs/admin/installation/

Did you follow step 3 ?

Copy the .env.example file to .env and fill with your own database and mail details.

You need to use your database credentials to connect to the database.

[ssddanbrown]

Closing due to time since last response. If this remains to be an issue feel free to comment and this can be re-opened.

[spike3579]

I was not able to fix the DB so I started over from scratch and everything worked as expected.