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
plugin:housekeeping [2024/03/16 06:32] – [Bounces] duncancplugin:housekeeping [2024/06/22 20:21] (current) – 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 ====
  
-Rows will be deleted from the ''linktrack\_forward'' table that are no longer used (do not have a reference in either the ''linktrack\_ml'' or ''linktrack\_uml\_click'' tables).+Rows will be deleted from the ''linktrack_forward'' table that are no longer used (do not have a reference in either the ''linktrack_ml'' or ''linktrack_uml_click'' tables).
  
-This can happen after deleting campaigns,and a row in ''linktrack\_forward'' is no longer used by any campaigns.+This can happen after deleting campaigns,and a row in ''linktrack_forward'' is no longer used by any campaigns.
  
 ==== User history ==== ==== User history ====
  
-Deletes rows from the ''user\_history'' table that are older than the threshold, but taken from each subscriber's most recent ''user\_history'' record. This ensures that the user history for a subscriber will never be totally deleted.+Deletes rows from the ''user_history'' table that are older than the threshold, but taken from each subscriber's most recent ''user_history'' record. This ensures that the user history for a subscriber will never be totally deleted.
  
-For example, if the threshold is 6 months and the most recent ''user\_history'' record for a subscriber was 2 months ago, then the records for that subscriber older than 8 months will be deleted.+For example, if the threshold is 6 months and the most recent ''user_history'' record for a subscriber was 2 months ago, then the records for that subscriber older than 8 months will be deleted.
 ====== Installation ====== ====== Installation ======
  
Line 65: Line 66:
 ===== Translations ===== ===== Translations =====
  
-The text displayed by the plugin can be translated into other languages. See the file ''plugins/HousekeepingPlugin/lan/translations\_en.php'' for the English version that can be used as the basis for another language. Each line in the file contains the English text then the equivalent text in the target language.+The text displayed by the plugin can be translated into other languages. See the file ''plugins/HousekeepingPlugin/lan/translations_en.php'' for the English version that can be used as the basis for another language. Each line in the file contains the English text then the equivalent text in the target language.
  
-To create a new language file, copy ''translations\_en.php'' to ''translations\_xx.php'', where xx is the language code, then change the texts for your target language. You can share your new language file by submitting it for inclusion in the plugin. Please create a topic in the user forum or an issue on GitHub.+To create a new language file, copy ''translations_en.php'' to ''translations_xx.php'', where xx is the language code, then change the texts for your target language. You can share your new language file by submitting it for inclusion in the plugin. Please create a topic in the user forum or an issue on GitHub.