XF 1.3 Convert VB Attachment images into full

[Mian Shahid]

Hi,

After converting our VB4 board into XF, we found almost all large old image attachments displaying as thumb instead viewing full.

Attachment code example:

VB image attachment code displaying as

[ATTACH]457.vB[/ATTACH]

, if we edit it to view as full it will be looks like

[ATTACH=full]457[/ATTACH]

.

We have thousands of same like in pending, is there any easy way to convert all of them from "VB" to "full"?

Waiting.........

@Brogan
@Jeremy
@Jake Bunce
@

 

[Paul B]

You can use a simple SQL query to replace the opening tag text.

Are you familiar with using phpMyAdmin?

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

Take a backup first.

 

[Mian Shahid]

You can use a simple SQL query to replace the opening tag text.

Are you familiar with using phpMyAdmin?

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

Take a backup first.

thanks for quick reply

I am novice using phpMyAdmin only once executed a query suggested by you regarding invisible users

 

[Paul B]

As long as you take a backup first, you should be fine.

Then just run:

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

 

[Mian Shahid]

you mentioned two commands in two post which on is for my issue? i think second one, kindly confirm.

 

[Paul B]

This is the actual query you need to run:

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

 

[Mian Shahid]

Thanks a lot

 

[Mian Shahid]

This is the actual query you need to run:

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

This command damage our database, then we recover from backup so any one who like to use this may take extra care.

 

[Paul B]

I don't see how it could, all it does is replace the opening tag.

What damage did it cause?

 

[Falkor]

This is something we would also like to do but reading this maybe not

 

[Mian Shahid]

I don't see how it could, all it does is replace the opening tag.

What damage did it cause?

almost everything in database, forum was not accessible for public only errors displaying, only database restore doesn't worked, then we re installed almost everything from cpanal to software then restored database.

I am not sure about actual cause either it happens due to running above command from MySQL or some thing else, but everything gone wrong after running that command, before that, we make some adjustment regarding our pageload which work fine as per below screen:

so . . . . . . . . . . we recovered after 24 hrs

 

[Paul B]

That query wouldn't cause that.

I and many others have used simple queries such as that one and others to replace post content.

I converted from phpBB and had around 50 custom BB Codes which I had to change or remove, using queries exactly like that.

 

[Mian Shahid]

I already said we are not sure about the actual cause, but we face that after running query, who investigate for actual cause? this is not required, but I only informed here what happens with us, may we make some mistake during running the query but . . . . . Ah! we like to forget everything regarding this incedent

 

[Mian Shahid]

This is something we would also like to do but reading this maybe not

You can do that, but with due care as Brogan said "

Take a backup first.

In addition, I like to say, take complete site backup first

 

[Mian Shahid]

We just found an excellent Add-on which solve this issue from our more then 49000+ attachments in just 20 minuets.

http://xenforo.com/community/resources/insert-attachment-all.3119/

Special Thanks to @AndyB