Question Attachment not found

Thank you Rich,
That's very helpful. I'll work on digesting it. My database knowledge is very limited but I do have support folks I can call on.
Bill

Hi Rich,
I'm working on the information you provided. Thank you.
In the mean time I've come to realize that there are seemingly two different problems with my site. The "Attachment Not Found" is most likely caused by my having removed orphaned attachments however, even within the last 24 hours a member made a post with two attachments that gave him "You do not have permission to access this page." Do these different messages have different causes?
I was able to retrieve his attachments from his attachment folder and successfully re-add them to his post.
Thanks
Bill

"You do not have permission to access this page."

In principle is it the same issue when users upload attachments sloppy. It's only a wrong error message. You can test it on our test category here: www.kunena.org/forum/163-Feature-Playgro...4935-attachment-test
1. Upload a image and insert this image in the message.
2. Use the browser back button and then go with the browser forwards button to the editor again.
3. Click in the editor on Preview (admittedly you see the image in the preview but when you save the message, it lacks the mesid)
4. Save the message

Now you see the message "You do not have permission to access this page."

When you remove now the orphaned attachments, changes this message to "Attachment not found"

Hi Rich,
I've got a long way to go to learn enough about databases to reach in and pluck out the orphaned attachments, but I'm working on it. In the mean time I'd like to suggest that a great improvement for Kunena would be to enhance it to the point where it identifies the orphaned attachments so that users could retrieve them and restore them to their proper places.
Thanks for all your help!
Bill

You are right, thats not optimal and therefore I've added this problem in our bug list.
Manipulations in the database is always a high risk and can destroy the complete website, when mistakes are made. Never work on it without backup!

For now, maybe helps this trick for you. If you have copied back the database rows, then should displayed in the frontend at the posts again the message "You do not have permissions to access this page."
If you click on Edit and then on Preview, you should see the related images. (Nevertheless remains many manually work.)

Thank you! I can run with that.
Bill