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

[beerForo]

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]

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]

I can try that thanks! Or I can try the "Post content find / replace" tool? However I don't know how to make regular expressions.

 

[Paul B]

For simple replacements/queries of that nature, it's not worth installing the add-on.

 

[beerForo]

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]

 

[beerForo]

The platform I imported from had full size so I really want to fix this so my members don't complain. Any help appreciated.

 

[Paul B]

You will have to use regex and the post replace add-on if al the strings are not unique.

You can post in the add-on thread for assistance.

 

[briansol]

If you use my match, the alt won't matter.


It may be a case thing. Try caps

 

[beerForo]

If you use my match, the alt won't matter.


It be a case thing. Try caps

I tried caps and it worked thanks!

PS. But the full size images are not clickable to lightbox, is that correct? Because others are.