1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Fixed Import - Attachments Problematic

Discussion in 'Resolved Bug Reports' started by Mert, Oct 6, 2010.

  1. Mert

    Mert Well-Known Member

    After importing the attachments thumbnails display correct but the file size for all attachments are listed as 0 and when you click on attachments i always get not found error both when SEO options are enabled or disabled

    attachments-after-import.PNG
     
  2. boban

    boban Well-Known Member

  3. z3r010

    z3r010 Member

    Has anybody figured this out yet as I'm having the same problem with imported and uploaded attachments.
     
  4. boban

    boban Well-Known Member

    For some reason the field "file_size" in the database table "xf_attachment_data" has records value 0.
    Just copy the field "filesize" from vbulletin table "attachment" to xenforo table "xf_attachment_data" field "file_size". It worked for me.

    Vbulletin and xenforo are in the same database:

    Code:
    UPDATE xf_attachment_data
    SET xf_attachment_data.file_size =
    (
    SELECT attachment.filesize FROM attachment
    WHERE xf_attachment_data.upload_date = attachment.dateline LIMIT 1
    )
    
     
  5. Mike

    Mike XenForo Developer Staff Member

    Appears to be fixed now. If you're interested, it appears to just need the stat cache cleared. It looks like it must be reusing some of the temporary files.
     

Share This Page