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

XF 1.4 Images as Thumbnails after import

Discussion in 'Installation, Upgrade, and Import Support' started by New Joe, Sep 26, 2014.

  1. New Joe

    New Joe Active Member

    So I just did a test import, and the images have come through as Thumbnails

    Not all, say hotlinked images, they are full size, ones which are brought from out the forum are fine.
    Just the images which were added as attachments which don't show in full size

    Any way to get them to show full size?
     
  2. DaveM

    DaveM Well-Known Member

  3. New Joe

    New Joe Active Member

    Thanks, I thought there was an easier way to do it though.
    That add on looks a bit hard to work out right now...
     
  4. DaveM

    DaveM Well-Known Member

    You can also do a SQL query I think @Snog know about this
     
    New Joe likes this.
  5. Brogan

    Brogan XenForo Moderator Staff Member

    If they all use the basic attach tags, you can do a query to change attach to attach=full.

    Code:
    UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');
    Take a backup first, just in case.
     
  6. New Joe

    New Joe Active Member

    Just submitted that query to the data base but nothing came back
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    That is an example query.
    You need to format it correctly for the current and new content text.
     
  8. New Joe

    New Joe Active Member

    PHP:
    UPDATE xf_post SET message REPLACE(message,'attach','attach=full');
    So submit that query then click Update Query?
     
  9. Brogan

    Brogan XenForo Moderator Staff Member

    I would make it more explicit and include the [ ], otherwise it's going to match any posts with the word attach.
     
  10. New Joe

    New Joe Active Member

    Code:
    UPDATE xf_post SET message = REPLACE(message,'[attach]','[attach=full]');
    Like this?
     
  11. Brogan

    Brogan XenForo Moderator Staff Member

    You will probably need to use ATTACH rather than attach.
     
  12. New Joe

    New Joe Active Member

    PHP:
    UPDATE xf_post SET message REPLACE(message,'[ATTACH]','[ATTACH=full]');
    I submitted that and it came back with a lot of tables, should I be looking for a table like, xf_thread xf_post then update the query?
     
  13. Brogan

    Brogan XenForo Moderator Staff Member

    You are already specifying the table in the query, all you need to do is select the database.

    Can you screenshot what you are seeing?
     
  14. Robust

    Robust Well-Known Member

    Are you doing this via phpmyadmin? Sounds like it because you're saying it came back with a list of tables. If so, select the database and then the SQL tab, throw it into there.
     

Share This Page