I run my ubb forum for over 20 years and do several updates and upgrades. In the past there must something goes wrong with my attachments.

The control panel tells me that I have 867 files. In my server filesystem I can find 743 files. I knew the table ubbt_FILES which contains 1194 rows (this counts attachments and gallery pictures together). I found postings marked with attachment and the file is gone, I found files without any relations to a post and so on. I see the difference in handling attachments in the server directory. New attachments have only a number, old attachments have a name that the attachment shows up in the posting. So I can see what is new and what is old in the filesystem.

Now I go to cleanup it a litte bit. I check ubbt_FILES and try to find the post or file which belongs to a row. The table ubbt_FILES contans a field 'POST_ID'. Is it the propper way to find the post while entering this url?
http://<path to board>/ubbthreads.php/topics/<POST_ID>

Sometime I found a thread which contains the post, sometimes I got the message that nothing can be found. I'm not sure. Is this the right way to call a single post in the webbrowser?
My ubbt_FILES table has some strange entrys with FILE_SIZE = NULL and FILE_DIR = NULL and if I have some time I try the POST_ID from such a strange row. Is it save to delete the row If my forum tell me that the posting no longer exists?

Regards
Zarzal


my board: http://www.dragonclan-forum.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen