XF 1.4 Images as Thumbnails after import

[New Joe]

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?

 

[DaveM]

You can use this add on apparently https://xenforo.com/community/resources/post-content-find-replace.1549/

 

[New Joe]

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

 

[DaveM]

You can also do a SQL query I think @Snog know about this

 

[Paul B]

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

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

Take a backup first, just in case.

 

[New Joe]

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

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

 

[Paul B]

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

 

[New Joe]

UPDATE xf_post SET message = REPLACE(message,'attach','attach=full');

So submit that query then click Update Query?

 

[Paul B]

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

 

[New Joe]

UPDATE xf_post SET message = REPLACE(message,'[attach]','[attach=full]');

Like this?

 

[Paul B]

You will probably need to use ATTACH rather than attach.

 

[New Joe]

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?

 

[Paul B]

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]

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.