Remove files from an upload area

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!  

That's brilliant, thank you

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?

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!

Thank you, that seems to have worked.