Strange attachment filenames

**Paul B** · Tue 15 Feb '11, 8:26am

Any ideas?

**Steve Machol** · Tue 15 Feb '11, 8:29am

Non-English characters in the file names?

**Paul B** · Wed 16 Feb '11, 1:52pm

No non-English characters. Here's another screenshot of a typical mess...

**Steve Machol** · Wed 16 Feb '11, 1:54pm

What are the original names of those file then? What happens when you upload a file with an English name?

**Paul B** · Wed 16 Feb '11, 2:13pm

I made a quick test article and the images uploaded fine so I'm guessing it's fine but something happened during the upgrade.

One image file is called "sprinter.jpg" and in the "Manage Attachments" window in the editor it is listed as sprinter..jpg (12.4 KB)"

**Steve Machol** · Wed 16 Feb '11, 2:15pm

That is odd. Unfortunately I don't have a fix for the old attachments. Please report this in the vB4 Bug Tracker here:

http://tracker.vbulletin.com/secure/Dashboard.jspa

**Paul B** · Wed 16 Feb '11, 2:16pm

Found another image called "sprinterimage.gif" and this one shows up as "sprinterimage..gi f (17.5 KB)" so it seems like each letter in the filename is "&#number;"

**Michael König** · Wed 16 Feb '11, 2:25pm

You only can fix this by manually executing those two querys with phpMyAdmin:

Code:

Query 1:
UPDATE attachment SET filename = REPLACE(filename, ' ', ' '), filename = REPLACE(filename, '&#33;', '!'), filename = REPLACE(filename, '&#34;', '"'), filename = REPLACE(filename, '&#35;', '#'), filename = REPLACE(filename, '&#36;', '$'), filename = REPLACE(filename, '&#37;', '%'), filename = REPLACE(filename, '&#38;', '&'), filename = REPLACE(filename, '&#39;', '\''), filename = REPLACE(filename, '&#40;', '('), filename = REPLACE(filename, '&#41;', ')'), filename = REPLACE(filename, '&#42;', '*'), filename = REPLACE(filename, '&#43;', '+'), filename = REPLACE(filename, '&#44;', ','), filename = REPLACE(filename, '&#45;', '-'), filename = REPLACE(filename, '&#46;', '.'), filename = REPLACE(filename, '&#47;', '/'), filename = REPLACE(filename, '&#48;', '0'), filename = REPLACE(filename, '&#49;', '1'), filename = REPLACE(filename, '&#50;', '2'), filename = REPLACE(filename, '&#51;', '3'), filename = REPLACE(filename, '&#52;', '4'), filename = REPLACE(filename, '&#53;', '5'), filename = REPLACE(filename, '&#54;', '6'), filename = REPLACE(filename, '&#55;', '7'), filename = REPLACE(filename, '&#56;', '8'), filename = REPLACE(filename, '&#57;', '9'), filename = REPLACE(filename, '&#58;', ':'), filename = REPLACE(filename, '&#59;', ';'), filename = REPLACE(filename, '&#60;', '<'), filename = REPLACE(filename, '&#61;', '='), filename = REPLACE(filename, '&#62;', '>'), filename = REPLACE(filename, '&#63;', '?'), filename = REPLACE(filename, '&#64;', '@'), filename = REPLACE(filename, '&#65;', 'A'), filename = REPLACE(filename, '&#66;', 'B'), filename = REPLACE(filename, '&#67;', 'C'), filename = REPLACE(filename, '&#68;', 'D'), filename = REPLACE(filename, '&#69;', 'E'), filename = REPLACE(filename, '&#70;', 'F'), filename = REPLACE(filename, '&#71;', 'G'), filename = REPLACE(filename, '&#72;', 'H'), filename = REPLACE(filename, '&#73;', 'I'), filename = REPLACE(filename, '&#74;', 'J'), filename = REPLACE(filename, '&#75;', 'K'), filename = REPLACE(filename, '&#76;', 'L'), filename = REPLACE(filename, '&#77;', 'M'), filename = REPLACE(filename, '&#78;', 'N'), filename = REPLACE(filename, '&#79;', 'O'), filename = REPLACE(filename, '&#80;', 'P'), filename = REPLACE(filename, '&#81;', 'Q'), filename = REPLACE(filename, '&#82;', 'R'), filename = REPLACE(filename, '&#83;', 'S'), filename = REPLACE(filename, '&#84;', 'T'), filename = REPLACE(filename, '&#85;', 'U'), filename = REPLACE(filename, '&#86;', 'V'), filename = REPLACE(filename, '&#87;', 'W'), filename = REPLACE(filename, '&#88;', 'X'), filename = REPLACE(filename, '&#89;', 'Y'), filename = REPLACE(filename, '&#90;', 'Z'), filename = REPLACE(filename, '&#91;', '['), filename = REPLACE(filename, '&#92;', '\\'), filename = REPLACE(filename, '&#93;', ']'), filename = REPLACE(filename, '&#94;', '^'), filename = REPLACE(filename, '&#95;', '_'), filename = REPLACE(filename, '&#96;', '`'), filename = REPLACE(filename, '&#97;', 'a'), filename = REPLACE(filename, '&#98;', 'b'), filename = REPLACE(filename, '&#99;', 'c'), filename = REPLACE(filename, '&#100;', 'd'), filename = REPLACE(filename, '&#101;', 'e'), filename = REPLACE(filename, '&#102;', 'f'), filename = REPLACE(filename, '&#103;', 'g'), filename = REPLACE(filename, '&#104;', 'h'), filename = REPLACE(filename, '&#105;', 'i'), filename = REPLACE(filename, '&#106;', 'j'), filename = REPLACE(filename, '&#107;', 'k'), filename = REPLACE(filename, '&#108;', 'l'), filename = REPLACE(filename, '&#109;', 'm'), filename = REPLACE(filename, '&#110;', 'n'), filename = REPLACE(filename, '&#111;', 'o'), filename = REPLACE(filename, '&#112;', 'p'), filename = REPLACE(filename, '&#113;', 'q'), filename = REPLACE(filename, '&#114;', 'r'), filename = REPLACE(filename, '&#115;', 's'), filename = REPLACE(filename, '&#116;', 't'), filename = REPLACE(filename, '&#117;', 'u'), filename = REPLACE(filename, '&#118;', 'v'), filename = REPLACE(filename, '&#119;', 'w'), filename = REPLACE(filename, '&#120;', 'x'), filename = REPLACE(filename, '&#121;', 'y'), filename = REPLACE(filename, '&#122;', 'z'), filename = REPLACE(filename, '&#123;', '{'), filename = REPLACE(filename, '&#124;', '|'), filename = REPLACE(filename, '&#125;', '}'), filename = REPLACE(filename, '&#126;', '~'), filename = REPLACE(filename, '&#196;', 'Ä'), filename = REPLACE(filename, '&#214;', 'Ö'), filename = REPLACE(filename, '&#220;', 'Ü'), filename = REPLACE(filename, '&#223;', 'ß'), filename = REPLACE(filename, '&#228;', 'ä'), filename = REPLACE(filename, '&#246;', 'ö'), filename = REPLACE(filename, '&#252;', 'ü');

Query 2:
UPDATE attachmentcategoryuser SET filename = REPLACE(filename, ' ', ' '), filename = REPLACE(filename, '&#33;', '!'), filename = REPLACE(filename, '&#34;', '"'), filename = REPLACE(filename, '&#35;', '#'), filename = REPLACE(filename, '&#36;', '$'), filename = REPLACE(filename, '&#37;', '%'), filename = REPLACE(filename, '&#38;', '&'), filename = REPLACE(filename, '&#39;', '\''), filename = REPLACE(filename, '&#40;', '('), filename = REPLACE(filename, '&#41;', ')'), filename = REPLACE(filename, '&#42;', '*'), filename = REPLACE(filename, '&#43;', '+'), filename = REPLACE(filename, '&#44;', ','), filename = REPLACE(filename, '&#45;', '-'), filename = REPLACE(filename, '&#46;', '.'), filename = REPLACE(filename, '&#47;', '/'), filename = REPLACE(filename, '&#48;', '0'), filename = REPLACE(filename, '&#49;', '1'), filename = REPLACE(filename, '&#50;', '2'), filename = REPLACE(filename, '&#51;', '3'), filename = REPLACE(filename, '&#52;', '4'), filename = REPLACE(filename, '&#53;', '5'), filename = REPLACE(filename, '&#54;', '6'), filename = REPLACE(filename, '&#55;', '7'), filename = REPLACE(filename, '&#56;', '8'), filename = REPLACE(filename, '&#57;', '9'), filename = REPLACE(filename, '&#58;', ':'), filename = REPLACE(filename, '&#59;', ';'), filename = REPLACE(filename, '&#60;', '<'), filename = REPLACE(filename, '&#61;', '='), filename = REPLACE(filename, '&#62;', '>'), filename = REPLACE(filename, '&#63;', '?'), filename = REPLACE(filename, '&#64;', '@'), filename = REPLACE(filename, '&#65;', 'A'), filename = REPLACE(filename, '&#66;', 'B'), filename = REPLACE(filename, '&#67;', 'C'), filename = REPLACE(filename, '&#68;', 'D'), filename = REPLACE(filename, '&#69;', 'E'), filename = REPLACE(filename, '&#70;', 'F'), filename = REPLACE(filename, '&#71;', 'G'), filename = REPLACE(filename, '&#72;', 'H'), filename = REPLACE(filename, '&#73;', 'I'), filename = REPLACE(filename, '&#74;', 'J'), filename = REPLACE(filename, '&#75;', 'K'), filename = REPLACE(filename, '&#76;', 'L'), filename = REPLACE(filename, '&#77;', 'M'), filename = REPLACE(filename, '&#78;', 'N'), filename = REPLACE(filename, '&#79;', 'O'), filename = REPLACE(filename, '&#80;', 'P'), filename = REPLACE(filename, '&#81;', 'Q'), filename = REPLACE(filename, '&#82;', 'R'), filename = REPLACE(filename, '&#83;', 'S'), filename = REPLACE(filename, '&#84;', 'T'), filename = REPLACE(filename, '&#85;', 'U'), filename = REPLACE(filename, '&#86;', 'V'), filename = REPLACE(filename, '&#87;', 'W'), filename = REPLACE(filename, '&#88;', 'X'), filename = REPLACE(filename, '&#89;', 'Y'), filename = REPLACE(filename, '&#90;', 'Z'), filename = REPLACE(filename, '&#91;', '['), filename = REPLACE(filename, '&#92;', '\\'), filename = REPLACE(filename, '&#93;', ']'), filename = REPLACE(filename, '&#94;', '^'), filename = REPLACE(filename, '&#95;', '_'), filename = REPLACE(filename, '&#96;', '`'), filename = REPLACE(filename, '&#97;', 'a'), filename = REPLACE(filename, '&#98;', 'b'), filename = REPLACE(filename, '&#99;', 'c'), filename = REPLACE(filename, '&#100;', 'd'), filename = REPLACE(filename, '&#101;', 'e'), filename = REPLACE(filename, '&#102;', 'f'), filename = REPLACE(filename, '&#103;', 'g'), filename = REPLACE(filename, '&#104;', 'h'), filename = REPLACE(filename, '&#105;', 'i'), filename = REPLACE(filename, '&#106;', 'j'), filename = REPLACE(filename, '&#107;', 'k'), filename = REPLACE(filename, '&#108;', 'l'), filename = REPLACE(filename, '&#109;', 'm'), filename = REPLACE(filename, '&#110;', 'n'), filename = REPLACE(filename, '&#111;', 'o'), filename = REPLACE(filename, '&#112;', 'p'), filename = REPLACE(filename, '&#113;', 'q'), filename = REPLACE(filename, '&#114;', 'r'), filename = REPLACE(filename, '&#115;', 's'), filename = REPLACE(filename, '&#116;', 't'), filename = REPLACE(filename, '&#117;', 'u'), filename = REPLACE(filename, '&#118;', 'v'), filename = REPLACE(filename, '&#119;', 'w'), filename = REPLACE(filename, '&#120;', 'x'), filename = REPLACE(filename, '&#121;', 'y'), filename = REPLACE(filename, '&#122;', 'z'), filename = REPLACE(filename, '&#123;', '{'), filename = REPLACE(filename, '&#124;', '|'), filename = REPLACE(filename, '&#125;', '}'), filename = REPLACE(filename, '&#126;', '~'), filename = REPLACE(filename, '&#196;', 'Ä'), filename = REPLACE(filename, '&#214;', 'Ö'), filename = REPLACE(filename, '&#220;', 'Ü'), filename = REPLACE(filename, '&#223;', 'ß'), filename = REPLACE(filename, '&#228;', 'ä'), filename = REPLACE(filename, '&#246;', 'ö'), filename = REPLACE(filename, '&#252;', 'ü');

If you also have the problem of two dots (..) showing in front of the extension, you also need those querys:

Code:

Query 3:
UPDATE attachment
LEFT JOIN filedata ON (filedata.filedataid = attachment.filedataid)
SET filename = REPLACE(filename, CONCAT('..', filedata.extension), CONCAT('.', filedata.extension))
WHERE filename LIKE CONCAT('%..', filedata.extension);

Query 4:
UPDATE attachmentcategoryuser
LEFT JOIN filedata ON (filedata.filedataid = attachmentcategoryuser.filedataid)
SET filename = REPLACE(filename, CONCAT('..', filedata.extension), CONCAT('.', filedata.extension))
WHERE filename LIKE CONCAT('%..', filedata.extension);

If you are using a table prefix, you have to change the table names accordingly.

**Paul B** · Wed 16 Feb '11, 3:51pm

OK I will give these a try. I had noticed the "two dots" issue since starting with vB 4.0.2 but thought it was harmless.

vBulletin 4 End of Life

Strange attachment filenames

[CMS] Strange attachment filenames

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment