XF 1.5 Attachment display as full size.

[Irfan]

Dear team ! I am a non technical person. We have a large number of attachments on our forum which has recently been imported. How do I make the code change for full size attachments? I have no idea how to run a SQL query. Can you guide me step to step ?

 

[Paul B]

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

Take a backup of the xf_post table before running any queries.

 

[Irfan]

How do you run the query?

 

[Paul B]

Using phpMyAdmin.

 

[Irfan]

What do I type? (I am a non technical person). I will appreciate step to step instructions.

 

[Paul B]

If you are unsure how to run a query in PMA then I would suggest contacting your host or sysadmin as you can cause damage to your installation.

The first thing you should do is take a backup.

 

[AndyB]

Hi Irfan,

Once you update your xf_post table as described by Brogan, I recommend you use this add-on so that members cannot insert thumbs.

https://xenforo.com/community/resources/remove-thumbnail-insert.2549/

 

[Irfan]

SQL query did not work. What other settings I have to change?

 

[Irfan]

Our members attach files from thier computer hard drive and usually do not insert them.