Remove files from an upload area
5 posts by 2 authors in: Forums > CMS Builder
Last Post: 7 hours ago (RSS)
By MercerDesign - June 25
Is it possible to remove ALL upload files from a multi list with one click of a button, I have a multi list that gets republished each week but we want to remove all files before they get republished because they get changed each week.
Hi MercerDesign,
Yes, it absolutely is, but be sure to back up and exercise caution when testing any code that has the potential to destroy data.
The line should do it:
// Remove ALL uploads from ALL records that match this criteria
removeUploads("tableName = 'yourTableName'");Hope that helps!
interactivetools.com
By MercerDesign - July 4
When I do a test on a new CMS table it works but when I try to implement this on an existing table I get this error: MySQL Error(1093): Error getting error record count: You can't specify target table 'cmsb__error_log' for update in FROM clause
Can you help please?
By Dave - 7 hours ago
Hi MercerDesign,
It's due to a change in MySQL 8.0 server. In /lib/errorlog_functions.php can you try replacing this:
$query = "DELETE FROM `$table` WHERE `num` < (SELECT `num` FROM `$table` ORDER BY `num` DESC LIMIT 1 OFFSET 999)";With this:
$query = "DELETE FROM `$table` WHERE num < (SELECT num FROM (SELECT num FROM `$table` ORDER BY num DESC LIMIT 999, 1) AS sub)";Let me know if that works for you.
Thanks!
interactivetools.com