Remove files from an upload area

Fri, 25 Jul 2025 04:12:53 -0700

Thank you, that seems to have worked.

Remove files from an upload area

Fri, 11 Jul 2025 13:30:32 -0700

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!

Remove files from an upload area

Fri, 04 Jul 2025 03:45:34 -0700

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?

Remove files from an upload area

Fri, 04 Jul 2025 02:23:38 -0700

That's brilliant, thank you

Remove files from an upload area

Mon, 30 Jun 2025 13:45:23 -0700

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!

Remove files from an upload area

Wed, 25 Jun 2025 03:09:04 -0700

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.