FriendsOfFlarum upload, the intelligent file attachment extension

adam42

JohnP k Hi JohnP, I had checked that out, but the warning message says:

Are you sure you want to hide "unity-statement-20210903.pdf"? Hiding a file will only remove it from your media manager and will not affect existing posts.

I'm looking for a way to clear down unwanted files completely and free space. I assume just hiding them won't help.

luceos

adam42 although some information is stored about where files have been uploaded, there is no functionality implemented yet to actually delete files from posts that are deleted.

adam42

oh i see. no worries - do you think it would be implemented as part of this extension?

Just realised I haven't a clue whether you can clear down anything else in Flarum - for instance, a thread? I'm just wondering whether the resources would stay together, so if you deleted a thread, it would also delete the files that belong to the thread.

Guess I've got heightened awareness around this after spending hours trying to free up room on my iCloud account 🤣

R_Nath

Hello, I need some help with this extension.
My forum is available at https://kuriousmachine.community and I host it at FreeFlarum

Sometimes (not always), when I click on the upload button, it refuses to function, i.e. it does not open up the default "choose file" window.
Is there any way to delete files manually so that I save the local disk space?

R_Nath

R_Nath Can somebody please help me?
Thank you

hrvoje_hr

R_Nath Sometimes (not always), when I click on the upload button, it refuses to function, i.e. it does not open up the default "choose file" window.

Are there any errors in console?

R_Nath Is there any way to delete files manually so that I save the local disk space?

Yes, you can delete them from the media manager (hover on upper right corner of the image)

Amarok

R_Nath hello, you have to see this with Free Flarum 😉

IanM

hrvoje_hr Yes, you can delete them from the media manager (hover on upper right corner of the image)

At present, this only removes them from being displayed in the media manager. The files will remain on disk at this point in time.

R_Nath

hrvoje_hr Are there any errors in console?

No.
Any further help, please?

R_Nath

IanM Yes, It only removes it from the display. Any way for deleting that from disk?

TechTimeRo

Need your hep getting the extension working please or at least some clues on where I could dig further for errors.

I am trying to activate the extension but it toggles back to inactive in the forum dashboard, and there is a message asking me to refresh the page witn F5 and try again, Unfortunately nothing changes even after refreshing and/or clearing Flarum cache.

Could somebody please point me into how I can debug this? From the server log there's a 500 Error:

500 POST /api/extensions/fof-upload HTTP/2.0 nginx/SSL/TLS access

I'm also getting this error in /storage/logs/ in the Flarum log:

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'ttro_fl22_fof_upload_files_actor_id_hide_from_media_manager_index' is too long (SQL: alter table `ttro_fl22_fof_upload_files` add index `ttro_fl22_fof_upload_files_actor_id_hide_from_media_manager_index`(`actor_id`, `hide_from_media_manager`)) in /var/www/vhosts/techtime.ro/httpdocs/vendor/illuminate/datab>Stack trace:
#0 /var/www/vhosts/techtime.ro/httpdocs/vendor/illuminate/database/Connection.php(663): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/vhosts/techtime.ro/httpdocs/vendor/illuminate/database/Connection.php(493): Illuminate\Database\Connection->run()
#2 /var/www/vhosts/techtime.ro/httpdocs/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#3 /var/www/vhosts/techtime.ro/httpdocs/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#4 /var/www/vhosts/techtime.ro/httpdocs/vendor/illuminate/database/Schema/Builder.php(212): Illuminate\Database\Schema\Builder->build()
#5 /var/www/vhosts/techtime.ro/httpdocs/vendor/fof/upload/migrations/2021_09_30_000000_add_index_actor_id_and_hide_media.php(20): Illuminate\Database\Schema\Builder->table()
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#7 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#8 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#9 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#10 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#11 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Extension/Extension.php(503): Flarum\Database\Migrator->run()
#12 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#13 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#14 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Extension/Command/ToggleExtensionHandler.php(36): Flarum\Extension\ExtensionManager->enable()
#15 /var/www/vhosts/techtime.ro/httpdocs/vendor/illuminate/bus/Dispatcher.php(122): Flarum\Extension\Command\ToggleExtensionHandler->handle()
#16 /var/www/vhosts/techtime.ro/httpdocs/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#17 /var/www/vhosts/techtime.ro/httpdocs/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#18 /var/www/vhosts/techtime.ro/httpdocs/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#19 /var/www/vhosts/techtime.ro/httpdocs/vendor/illuminate/bus/Dispatcher.php(78): Illuminate\Bus\Dispatcher->dispatchNow()
#20 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(43): Illuminate\Bus\Dispatcher->dispatch()
#21 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#22 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#23 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ExecuteRoute->process()
#24 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#25 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\ThrottleApi->process()
#26 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#27 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\CheckCsrfToken->process()
#28 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#29 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ResolveRoute->process()
#30 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#31 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\SetLocale->process()
#32 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#33 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#34 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#35 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\AuthenticateWithSession->process()
#36 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#37 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\RememberFromCookie->process()
#38 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#39 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\StartSession->process()
#40 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#41 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Api\Middleware\FakeHttpMethods->process()
#42 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#43 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ParseJsonBody->process()
#44 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#45 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\HandleErrors->process()
#46 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#47 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\InjectActorReference->process()
#48 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#49 /var/www/vhosts/techtime.ro/httpdocs/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#50 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\RequestHandler->process()
#51 /var/www/vhosts/techtime.ro/httpdocs/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#52 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePathRouter->process()
#53 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#54 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Laminas\Stratigility\Middleware\OriginalMessages->process()
#55 /var/www/vhosts/techtime.ro/httpdocs/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#56 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Middlewares\BasePath->process()
#57 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#58 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/Next.php(51): Flarum\Http\Middleware\ProcessIp->process()
#59 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(76): Laminas\Stratigility\Next->handle()
#60 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(65): Laminas\Stratigility\MiddlewarePipe->process()
#61 /var/www/vhosts/techtime.ro/httpdocs/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#62 /var/www/vhosts/techtime.ro/httpdocs/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#63 /var/www/vhosts/techtime.ro/httpdocs/index.php(26): Flarum\Http\Server->listen()
#64 {main}

clarkwinkelmann

TechTimeRo this happens because your database table prefix is too long.

Flarum automatically creates database index names based on table names + column names, and when extensions use long column or table names, this increases the risk of creating too long index names.

There is unfortunately no easy solution to the problem. You can either manually create the index and add the migration name to the list of migrations that have been run, or modify your database table prefix. First solution requires digging into the migration files and comparing them with your database to make sure you changed everything correctly manually, while the second option requires renaming every table and index in the existing database. A third option would be to temporarily edit the migration files to hard-code a valid prefix name. Both first and third option might cause a migration rollback to fail (if you ever want to erase the extension data).

If this is a new Flarum installation, I suggest re-installing and choosing a shorter prefix. If you need to preserve the existing database we can try to provide help but it's going to require some tinkering with the database.

TechTimeRo

clarkwinkelmann Thank you. This is a new forum install so I am going to do a fresh reinstall, having my lesson learned 😀 now.

clarkwinkelmann

TechTimeRo good to hear!

Unfortunately we have not really defined a recommended table prefix length in Flarum so extensions don't take this into account for their index length.

You just need 2 less characters in your prefix to solve this particular error (max 64 characters length for the index name). But other extensions could have longer index names 😅 If you can avoid using a prefix, it's the safest method. Otherwise I could recommend 3 or 4 characters for the prefix length to be on the safe side.

We should do something to handle the error in a friendlier way, but I'm not sure how to handle this. We could throw a better exception when it happens, but it will still fail mid-migration which isn't great. In this extension we could provide a shorter index base name to try to avoid the issue, but there will still be a max prefix length to watch out for.

comseong

Can I make user upload the specific file type with FoF Upload extension?

I want for a user to be able to upload a ENT file extension which is not normal file type like image, video, pdf, etc. How could I do it? I tried to set the mime type like (application\/(ent)) on admin panel but it doesn't work.

I found the mime-type of the file I want to give a permission by Linux file command. The type was "application/x-gzip". So I added this conf, (application\/(x-(7z|rar|zip)-compressed|zip|arj|x-(bzip2|gzip|lha|stuffit|tar)|pdf|ent)) like the extension's recommandation. But it doesn't work, too.

luceos

comseong just split those mime types up into new entries, I don't think the regex does what you expect it to do. Start by adding one entry:

application\/x-gzip

comseong

luceos Thanks, I tried as you mentioned, but it doesn't work.
I have two rows for conf. ^image\/.*as a default for Imgur in first row. And in the next row, I added it application\/x-gzip for local. Do I have any mistake?

==============================
I tried one more thing by adding ^application\/.* instead of it. It works! But I think it's too broad to protect our forum from uploading abnormal file extension. How can I filter exactly by both file type and extension?

leanhduc

I got this error recently, it was working fine before
📌 path: /api/fof/upload

{
   "errors": [
       {
         "status": "405",
         "code": "method_not_allowed"
      }
   ]
}

Error can't upload photos!

Does anyone know how to fix this, thanks a lot!

luceos

leanhduc are you sure nothing changed? This should just work.

leanhduc

luceos I'm sure nothing has changed! I just got this error 2 days ago. Looking forward to hearing from you. Thanks for answering!

datlechin

leanhduc try set debug in config.php file to true, and see exacly the error messages

« Previous Page Next Page »