Ok, it took me ages to prepare to answer your question, ... but I think this will help. This is a screencap of the Files table in the database.
Files 1902 and above were posted after the import, and they appear inline.
Below 1902 are files that were posted before the import. These did appear inline in the old forum, but now they appear as attachments.
I really hope this answers your question. After looking at the database (a place I usually avoid at all costs), it seems to me that this is probably not fixable, and even if it is, it would be VERY difficult. I'm not sure that I want this that bad.
Express Hosting
"We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#183734 - 05/03/0712:02 AMRe: File Manager is missing
[Re: Rose]
Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Let me rephraise again...
Ok, go to a post that doesn't work, edit the post, paste me exactly what was posted, using the [code] tags...
I want to examine how the old posts look as to see if theres any reason why it wouldn't allow it to be incuded inine, so I need to be able to see exactly what the user inserted into the database.
oh gee .. I meant to add that bit in my last post.
I did that, but there is nothing but the actual text entered. I can do that if you want, but all it shows is text - no code. Here's one ..
Code:
This is one of our photos which ran in the Courier Mail Sept '93, we had professional photos taken but I always liked this B & W one. We were married in Brisbane, same church as my parents and sister were also married in..
so come on, share your pics....
Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Humm, odd, not sure hwo the prior hack attached images then lol... It's not incuded in the post (like I figured it might be, it was a hack afterall)...
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
It's the file type being blank. Inline images will only be displayed if the file type is known to be a valid image type. You could fix this with a couple of queries like this:
update ubbt_FILES set FILE_TYPE='jpg' where FILE_NAME like '%.jpg'
update ubbt_FILES set FILE_TYPE='gif' where FILE_NAME like '%.gif'
update ubbt_FILES set FILE_TYPE='png' where FILE_NAME like '%.png'