Skip to content

Instantly share code, notes, and snippets.

@jonpugh

jonpugh/delete-hosting-task-logs.sql

Created January 6, 2020 15:40
Show Gist options
  • Save jonpugh/a0464af7aca1e69afa41372500669d8f to your computer and use it in GitHub Desktop.
Save jonpugh/a0464af7aca1e69afa41372500669d8f to your computer and use it in GitHub Desktop.
Download ZIP
Aegir Hosting Task Logs Cleanup
Raw
delete-hosting-task-logs.sql
# Delete all hosting_task_logs from all sites that are deleted.
DELETE htl.* FROM hosting_task_log htl LEFT JOIN hosting_task ht ON htl.vid = ht.vid LEFT JOIN hosting_site hs ON ht.rid = hs.nid WHERE hs.status = -2;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment