Announcement

Collapse
No announcement yet.

Strange attachment filenames

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [CMS] Strange attachment filenames

    Just upgraded to 4.1.1 and image filenames are long and odd. Any clues to fix? Thanks.

    Click image for larger version

Name:	manattach.png
Views:	1
Size:	30.6 KB
ID:	3719988

  • #2
    Any ideas?

    Comment


    • #3
      Non-English characters in the file names?
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


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

        Click image for larger version

Name:	moreweird.png
Views:	1
Size:	19.2 KB
ID:	3681418

        Comment


        • #5
          What are the original names of those file then? What happens when you upload a file with an English name?
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment


          • #6
            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)"

            Comment


            • #7
              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
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment


              • #8
                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;"

                Comment


                • #9
                  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.

                  Comment


                  • #10
                    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.

                    Comment

                    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                    Working...
                    X