XF 2.2 Is there a way to change insertered thumbnails after import?

beerForo

Well-known member
So after an import, the images that are "inserted" in the post are the thumbnails instead of the actual images. Is there a way to change this, perhaps using the post content replace add-on?
 

briansol

Well-known member
you can run a sql query to update replace your post table with something like

[attach
to
[attach type="full"

run some tests first in a sample db table. there is no undo and i typed that up from memory. check the bbcode in your message col


'UPDATE xf_post SET message = REPLACE(message, 'oldstring', 'newstring');
 

beerForo

Well-known member
I tried the query on thousands of posts and it affected 19.

I think because of the alt code? Grabbed this from a post:

[ATTACH alt="image 2.jpg"]96801[/ATTACH]
 
Top