Disabling File Custom Field.. Quick way to find / remove old files
By Andy on Thursday, 20 October 2016
Posted in Technical Issues
Likes 0
Views 127
Votes 0
I've been using a 'FILE' custom field in my EasySocial events to allow people to upload things... I'm now proposing to stop using that and instead use the 'share files' and 'file application' system which from testing ES2 I've realised is much better for what I need.

My question is, because my ES site has run for many many months now, lots of files have been uploaded by people through that 'FILE' custom field for Events... and so is there an easy way for me to find these in my Joomla site file and folder structure.. and would it be safe to delete those files? Thanks!
Hey Andy,

Regarding this you have to delete it through the database and manually delete those file from your FTP server.



// 368 is custom field id, you can check my attached screenshot below how to find this custom field id from the browser console area



// delete the custom field from the event category

DELETE FROM `#__social_fields` where `id` = 368;



// delete the custom field from the event

DELETE FROM `#__social_fields_data` where `field_id` = 368;



// delete the file

DELETE FROM `#__social_files` where `uid` = 368;


File storage structure -> JoomlaFolder/media/com_easysocial/files/fields/FIELD_ID/...

Note: Remember do the full backup before you perform this.
Arlex Wong
·
Thursday, 20 October 2016 15:34
·
0 Likes
·
0 Votes
·
0 Comments
·
AWESOME. That's great guidance Arlex. Thanks so much.
Andy
·
Thursday, 20 October 2016 19:40
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

You are most welcome. Glad to hear that your issue has been resolved now.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.
Arlex Wong
·
Friday, 21 October 2016 00:30
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post