meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
plugin:housekeeping [2024/03/16 06:32] – [Bounces] duncancplugin:housekeeping [2024/06/22 20:19] – [Bounces] duncanc
Line 2: Line 2:
  
 ---- plugin ---- ---- plugin ----
 +
 description: A plugin to delete old records from the phplist database. description: A plugin to delete old records from the phplist database.
 author     : Duncan Cameron author     : Duncan Cameron
Line 25: Line 26:
 Rows will also be deleted from all tables related to the ''message'' table, these are Rows will also be deleted from all tables related to the ''message'' table, these are
  
-  * ''linktrack\_ml'' +  * ''linktrack_ml'' 
-  * ''linktrack\_uml\_click''+  * ''linktrack_uml_click''
   * ''listmessage''   * ''listmessage''
-  * ''message\_attachment'' +  * ''message_attachment'' 
-  * ''message\_data''+  * ''message_data''
   * ''usermessage''   * ''usermessage''
-  * ''user\_message\_bounce'' +  * ''user_message_bounce'' 
-  * ''user\_message\_forward'' +  * ''user_message_forward'' 
-  * ''user\_message\_view''+  * ''user_message_view''
  
 ==== Event log ==== ==== Event log ====
Line 41: Line 42:
 ==== Bounces ==== ==== Bounces ====
  
-Rows will be deleted from the ''bounce'' table whose date field is earlier than the current date less the configuration threshold value. Related rows will be deleted from the ''user\_message\_bounce'' table.+Rows will be deleted from the ''bounce'' table whose date field is earlier than the current date less the configuration threshold value. Related rows will be deleted from the ''user_message_bounce'' table.
  
 Rows will also be deleted from the ''bounce'' table that relate to subscribers who are marked as blacklisted. Rows will also be deleted from the ''bounce'' table that relate to subscribers who are marked as blacklisted.
  
-Rows will also be deleted from the ''user\_message\_bounce'' table whose related record in the ''bounce'' table no longer exists..+Rows will also be deleted from the ''user_message_bounce'' table whose related record in the ''bounce'' table no longer exists..
  
-Rows will be deleted from the ''bounceregex\_bounce'' table that refer to bounces which no longer exist.+Rows will be deleted from the ''bounceregex_bounce'' table that refer to bounces which no longer exist.
  
 ==== Linktrack forward ==== ==== Linktrack forward ====