XF 2.2 How do I find where an "attachment missing" is coming from?

Semper Fidelis

Semper Fidelis

Active member
Below is one example of an error I'm getting about missing attachments in the error log.

When I search the database, however, I cannot find the attachment referenced anywhere except in the error log table.

How do I find what's triggering the error and a few other annoying logs that reference other attachments that cannot be found?

Is there any way to clean up attachments and their references so all posts either map to existing attachments and, if not, those attachment references can be pruned?

Code: 
League\Flysystem\FileNotFoundException: File not found at path: attachments/5/5023-ccfc4f399ef4ec51cf5f6be7a0b66e31.data src/vendor/league/flysystem/src/Filesystem.php:389
Generated by: Anthony DeNicola Sep 4, 2023 at 7:04 PM
Stack trace
#0 src/vendor/league/flysystem/src/Filesystem.php(194): League\Flysystem\Filesystem->assertPresent('attachments/5/5...')
#1 [internal function]: League\Flysystem\Filesystem->readStream('attachments/5/5...', Array)
#2 src/vendor/league/flysystem-eventable-filesystem/src/EventableFilesystem.php(431): call_user_func_array('League\\Flysyste...', Array)
#3 src/vendor/league/flysystem-eventable-filesystem/src/EventableFilesystem.php(395): League\Flysystem\EventableFilesystem\EventableFilesystem->callFilesystemMethod('readStream', Array)
#4 src/vendor/league/flysystem-eventable-filesystem/src/EventableFilesystem.php(154): League\Flysystem\EventableFilesystem\EventableFilesystem->delegateMethodCall('readStream', Array)
#5 src/vendor/league/flysystem/src/MountManager.php(345): League\Flysystem\EventableFilesystem\EventableFilesystem->readStream('attachments/5/5...')
#6 src/XF/Pub/View/Attachment/View.php(25): League\Flysystem\MountManager->readStream('attachments/5/5...')
#7 src/XF/Mvc/Renderer/AbstractRenderer.php(91): XF\Pub\View\Attachment\View->renderRaw()
#8 src/XF/Mvc/Renderer/Raw.php(39): XF\Mvc\Renderer\AbstractRenderer->renderViewObject('XF:Attachment\\V...', '', Array)
#9 src/XF/Mvc/Dispatcher.php(460): XF\Mvc\Renderer\Raw->renderView('XF:Attachment\\V...', '', Array)
#10 src/XF/Mvc/Dispatcher.php(442): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Raw), Object(XF\Mvc\Reply\View))
#11 src/XF/Mvc/Dispatcher.php(402): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Raw), Object(XF\Mvc\Reply\View))
#12 src/XF/Mvc/Dispatcher.php(60): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'raw')
#13 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#14 src/XF.php(524): XF\App->run()
#15 index.php(20): XF::runApp('XF\\Pub\\App')
#16 {main}
 
Sort by date Sort by votes
Normally I'd say it shouldn't be possible to get such an error without a corresponding record in the database.

Try these queries to see if they return anything:
Code: 
SELECT * FROM xf_attachment WHERE data_id = 4593
SELECT * FROM xf_attachment_data WHERE data_id = 4593
SELECT * FROM xf_attachment_data WHERE file_hash = '737bf43379656942487fcf5be0c7901d'

Redis isn't used for anything related to attachments (wich standard XenForo, might be the case if Add-ons are used - I don't know).
 
Upvote 0 Downvote
Semper Fidelis said:
Could it be Cloudflare's cache?
Click to expand...
No. Even if a page that contains a (now gone) attachment is served from coudflare cache (which won't happen unless you configure CouldFlare to cache dynamic pages) the resulting request to the origin would not produce such an error - it just would generate an eror message for the client that the attachment doesn't exist.

The error message should show which URL actuall ygenerated the error.

Can you re-produce it by accessing that URL again?
 
Upvote 0 Downvote
Kirby said:
No. Even if a page that contains a (now gone) attachment is served from coudflare cache (which won't happen unless you configure CouldFlare to cache dynamic pages) the resulting request to the origin would not produce such an error - it just would generate an eror message for the client that the attachment doesn't exist.

The error message should show which URL actuall ygenerated the error.

Can you re-produce it by accessing that URL again?
Click to expand...
The only thing I have is the error log that I've pasted in full. I don't know what URL generated it.
 
Upvote 0 Downvote
Kirby said:
Thats strange :)

I tried to simulate the error you got (by intentionally deleting the file) and the eror log entry does show the URL that generated the error:
View attachment 291145

Maybe you could re-check the error log again and post a screenshot (like I did)?
Click to expand...
Thanks for showing me where to look. I was pasting the reported error part and not the Request State. Unfortunately, I deleted the error.

That actually will save me a ton of time because I've been searching for the data id and didn't even see that the referring URL was in that portion.

IIf it re-occurs then I'll post it. Right now, the reported errors is gone.
 
Upvote 0 Downvote
So if I understand correctly, to avoid these errors I need to search the attachments ID in the database and delete everything related to it?

I have the attachment ID in the URL in the error log showing as:
["url"] => string(19) "/attachments/11326/"

When I navigate to this URL I get an XF front end error that this attachment doesn’t exists but it doesn’t trigger another error log in the ACP
 
Upvote 0 Downvote
If this is related to the error you posted in the other thread...
League\Flysystem\FileNotFoundException: File not found at path: attachments/9/9609-f935b1f5e093cecfb3b4bd558ebfb35d.data
Click to expand...

9609 would be your attachment data id (not necessarily the same as your attachment id). You can get the attachment id for that data record with a SQL query like so:
SQL said:
SELECT attachment_id FROM xf_attachment WHERE data_id = 9609;
Click to expand...

Then you can at least know the attachment with the missing data and go from there...
 
Upvote 0 Downvote
digitalpoint said:
If this is related to the error you posted in the other thread...


9609 would be your attachment data id (not necessarily the same as your attachment id). You can get the attachment id for that data record with a SQL query like so:


Then you can at least know the attachment with the missing data and go from there...
Click to expand...
Thanks. So the URL string in the error message doesn't mean anything?

It looks like this:


Code: 
League\Flysystem\FileNotFoundException: File not found at path: attachments/9/9609-f935b1f5e093cecfb3b4bd558ebfb35d.data src/addons/DigitalPoint/Cloudflare/League/Flysystem/Adapter/R2.php:132
Generated by: Unknown account 3/10/23 at 20:49

Request state
array(4) {
  ["url"] => string(19) "/attachments/11326/"
 
Upvote 0 Downvote
The URL string in the error will tell you what URL triggered the problem, but that's not how you would search the database. Sometimes I'll use the URL as it is useful to find a post where the attachment itself is missing. You can sometimes use that URL string to get to the forum thread where the attachment is missing.

Many times, however, you have to search the xf_attachments table for the data_id that corresponds to the attachment number being reported (see in my first post it was 4393).

Once you find the row in the xf_attachments you can find the post id where the attachment is located (or in some cases it's in an AddOn location). You can go directly to the post id by https://forumurl.com/posts/post-id. From there you can edit the post and delete the attachment that's missing from the post.

Honestly, I've gotten weary of keeping up with the error reports as I've lost quite a few.
 
Upvote 0 Downvote
The hash is stored in xf_attachment_data and the container information is in xf_attachment, so you'd have to query like this:

Code: 
select * from xf_attachment join xf_attachment_data using (data_id) where file_hash = 'xxx';

Change xxx to the hash, and the returned row will have a value for the content type and ID the attachment is linked with.
 
Upvote 0 Downvote
mattrogowski said:
The hash is stored in xf_attachment_data and the container information is in xf_attachment, so you'd have to query like this:

Code: 
select * from xf_attachment join xf_attachment_data using (data_id) where file_hash = 'xxx';

Change xxx to the hash, and the returned row will have a value for the content type and ID the attachment is linked with.
Click to expand...
Thanks. I'm trying to figure out the post id or thread id the attachment is associated with the attachment. Is there a way to see this by running a query?
 
Upvote 0 Downvote
https://www.website.tld/posts/<id>
or
https://www.website.tld/threads/does-not-matter.1/post-<id>/
or
SELECT thread_id FROM xf_post WHERE post_id = <id>
or ...

Almost endless possibilities :)
 
Last edited:
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

eDaddi
  • Question Question
XF 2.2 R2 & File not found errors
Replies
16
Views
422
MattW
MattW
Semper Fidelis
  • Question Question
XF 2.2 League\Flysystem\FileNotFoundException
Replies
8
Views
643
digitalpoint
digitalpoint
B
  • Question Question
XF 2.2 failed to open stream: No such file or directory src/vendor/league/flysystem/src/Adapter/Local.php:135 What is the solution?
Replies
4
Views
607
Paul B
Paul B
Ferdinand
  • Question Question
XF 2.2 Rebuild master data error
Replies
1
Views
459
Paul B
Paul B
yousafsaeed
  • Question Question
XF 2.0 Fatal error: Array and string offset access syntax with curly braces is no longer supported
Replies
0
Views
562
yousafsaeed
yousafsaeed
Top Bottom