Old attachments not showing - (Ticketid: 1420256)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tomcoleman
    Senior Member
    • Aug 2010
    • 112

    Old attachments not showing - (Ticketid: 1420256)

    We have since migrated back from V5 to V4.2.3 (as v5 was too buggy)

    We did a complete restore from our old backups.

    Everything seems to be fine apart from the attachments do not show, it just shows the image place holders.

    I have used the upload diagnostics tool which comes back with no errors, so presume it just cant see or read the old attachments

    Attachments on the server are stored in

    /public_html/forum/attachments/ with CHMOD 0777

    A Good example is here you can see no attachments showing

    http://www.thesaltybox.com/forum/showthread.php?t=156737&page=11&p=1542470#post1542470
  • kh99
    Senior Member
    • Aug 2009
    • 533

    #2
    The call to attachment.php is retuning clear.gif (which of course is invisible), and it looks like that happens when the attachment file can't be opened. So I guess they're not in the right place or there's a permission problem. I see you said the directory is 0777, what about the subdirectories and the files themselves?

    Comment

    • Wayne Luke
      vBulletin Technical Support Lead
      • Aug 2000
      • 73979

      #3
      Does the directory in your AdminCP settings match? Place the Site into Debug mode and go to Settings -> Options -> Version and Other Untouchables and check the Attachment Directory settings.

      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API

      Comment

      • tomcoleman
        Senior Member
        • Aug 2010
        • 112

        #4
        yes the directory is correct.

        Everything in Attachments has also been CHMODD'd to 777 still no attachments display as per my link above.

        I can post new attachments, so the directy/writing is fine.
        Click image for larger version

Name:	Capture.JPG
Views:	60
Size:	21.5 KB
ID:	4325592


        Click image for larger version

Name:	permissions.JPG
Views:	46
Size:	61.5 KB
ID:	4325595

        Comment

        • tomcoleman
          Senior Member
          • Aug 2010
          • 112

          #5
          i do have a .htaccess in the attachments folder not sure if the code is right inside that

          see here:

          Click image for larger version

Name:	htaccess.JPG
Views:	51
Size:	83.4 KB
ID:	4325597

          Comment

          • kh99
            Senior Member
            • Aug 2009
            • 533

            #6
            Hmm...the files should be stored in subdirectories named for the digits of the userid. So if you're userid 12345, your attachments should be in attachments/1/2/3/4/5/attachid.attach, but that picture makes it look like the 2 directory is the only one with any subdirectories.

            Comment

            • Wayne Luke
              vBulletin Technical Support Lead
              • Aug 2000
              • 73979

              #7
              Building off what was said above, do you have the directory attachments/1/5/5/5/0/?
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud demonstration site.
              vBulletin 5 API

              Comment

              • tomcoleman
                Senior Member
                • Aug 2010
                • 112

                #8
                Originally posted by Wayne Luke
                Building off what was said above, do you have the directory attachments/1/5/5/5/0/?
                Yes I do please see attached.

                Click image for larger version

Name:	yesido.JPG
Views:	50
Size:	86.7 KB
ID:	4325663

                Comment

                • kh99
                  Senior Member
                  • Aug 2009
                  • 533

                  #9
                  If you get a chance, try doing this query:
                  Code:
                  [COLOR=#222222][FONT=Consolas][SIZE=12px]SELECT filedataid FROM attachment WHERE attachmentid=126783[/SIZE][/FONT][/COLOR]
                  and if you get a number back, see if you have files with that name in the 1/5/5/5/0 directory.

                  (If you have a table prefix, you'd need to add that to 'attachment' in the query).

                  Comment

                  • tomcoleman
                    Senior Member
                    • Aug 2010
                    • 112

                    #10
                    it shows

                    Click image for larger version

Name:	sql.JPG
Views:	44
Size:	57.9 KB
ID:	4325672

                    Comment

                    • tomcoleman
                      Senior Member
                      • Aug 2010
                      • 112

                      #11
                      Click image for larger version

Name:	return.JPG
Views:	48
Size:	30.5 KB
ID:	4325674

                      intresting

                      Comment

                      • kh99
                        Senior Member
                        • Aug 2009
                        • 533

                        #12
                        Well, I think you want to look for 1/5/5/5/0/116508.thumb and .attach. That should be one of the files that's missing from that post you linked to.

                        Comment

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