• 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

New Joe

Active member
#1
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?
 

Brogan

XenForo moderator
Staff member
#5
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.
 

New Joe

Active member
#6
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.
Just submitted that query to the data base but nothing came back
 

Brogan

XenForo moderator
Staff member
#9
I would make it more explicit and include the [ ], otherwise it's going to match any posts with the word attach.
 

New Joe

Active member
#12
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?
 

Brogan

XenForo moderator
Staff member
#13
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?
 

Robust

Well-known member
#14
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.