404 - Attachment Not Found

[FragaCampos]

Hi there.

I've found several people with the same problem after upgrading from SFM 1.x to SMF 2.x but I haven't found a satisfactory answer to this "serious" problem.
I have 7000 attachments and when I upgraded, in localhost and on live forum, almost 3 thousand disapppeared.
I don't have a clue why, but al atttachments were working and they are still in my attachments directory.
The attachments' table in the database is also intact.

Any lights on this?
Thanks.

[kat]

Got a link to a post where this is happening, so we can have a look at it? (Remember it'll need to be open for guest viewing)

[FragaCampos]

I'm analysing my old vs new database (attachment table) and I see something weird. All the old attachments don't have a file_hash, while the attachments that are ok do have a file_hash.
But I wonder why this was not an issue in SMF 1.1.18...

Any clue about this?
I really didn't want to upload 3000 attachments again

[FragaCampos]

My forum is in maintenance mode, but i can explain exactly what you want to see if you wish.

Got a link to a post where this is happening, so we can have a look at it? (Remember it'll need to be open for guest viewing)

[FragaCampos]

I detected a difference between the old and new attachments. Clearly a codification problem 



old hash ->
6553_Oea_Coaao_Eiaeai_Oaeiwau_199u_EIC_oao77ab11ea32cba108db8292a2a13f5a2b
6552_Oea_Coaao_Ciiaai_Waoieic_Oweiaia_2007_AODH_oaoc8aa15609d48e322240eeac091c31c56
6551_Oea_Coaao_Aoaadha_Oea_AEieceo_oi_AEoaaaii_2001_EIC_oaob48deeac0802547da7369a99a9d71307


new hash ->
6554_1bf7f29acc47fccdd9311d5d2b27577b7706a718
6555_029e9bbe42fdba0bd7e9684aa510df6b02bf3c07
6556_ff01e92a67b8b877fa3ac592822e2b9fd83e5b5e

[Arantor]

Did you change from ISO to UTF-8 at any point?

[kat]

That's a thought, innit?

I wondered if PrettyURLs might be involved, somewhere, too.

All I was going to try, to start with, was the ol' "Inspect element" thing.

Check a URL or two, that kinda thing.

Generally, a 404 means that the page simply doesn't exist.

A small hunchette... The attachments directory and the actual files, themselves... Are they all read-enabled?

Could it be a CHOWN permissions thing?

[FragaCampos]

Yes, when I upgraded I used "Convert HTML-entities to UTF-8 characters" in the admin panel. Could it be because of that?

Did you change from ISO to UTF-8 at any point?

My attachments directory is 0755 and all the files inside are 0644.
I don't have prettyurls or SimpleSEF installed...

That's a thought, innit?

I wondered if PrettyURLs might be involved, somewhere, too.

All I was going to try, to start with, was the ol' "Inspect element" thing.

Check a URL or two, that kinda thing.

Generally, a 404 means that the page simply doesn't exist.

A small hunchette... The attachments directory and the actual files, themselves... Are they all read-enabled?

Could it be a CHOWN permissions thing?

[kat]

What you've quoted is CHMOD, not CHOWN.

Your host will have to confirm that you have full CHOWN ownership of everything.

[FragaCampos]

Well, but there's no reason for being a problem with CHOWN, since I did the upgrade in the same server, and the attachments folder didn't change, because I didn't touch it. That folder was doing just fine UNTIL I did the upgrade.

[kat]

* K@ wanders-off, scratching his head, to try and figure this out...0

[FragaCampos]

Ok, I've installed the forum in my pc like it was before the upgrade, and all attachments are correct and working fine.
I'm going to upgrade on localhost and see if I get the same results, this time without activating the "Convert HTML-entities to UTF-8 characters" afterwords.

[Arantor]

And don't use FileZilla to transfer attachments

[FragaCampos]

Ok, tested and proved.

After the upgrade I went directly to the attachments zone, and the problem is there.
Like I said here, old attachments don't work.

PS: I use Total Commander, although I think that's not the problem...

[kat]

I use that, too. It's perfectly OK, for this kinda stuff.

This sure is an odd one.

[ziycon]

I've just come across this issue on one of my live forums using 2.0.1, going to digg deeper and see what I can come up with.

[ziycon]

I've had a look into this more. All the files in the attachment directory are named 'ID_Hash' and the references in the attachment table match the Id and the file hash. Can't seem to see why it's not working all of a sudden. :S

[FragaCampos]

Well, my job is not finished yet... I'm still uploading like 20 attachments per day to correct this.

[kat]

Had any luck, so far?

[ziycon]

I've come up with nothing, some attachments work but most don't, can't see anything causing it or anything common between failing attachments.