Personal Table Maintenance
![]() |
Downloads of Personal Table Maintenance are restricted to logged in users. If you do not have a user account on the TNG Wiki use the Request Account link to request a user account | ![]() |
![]() |
If you have trouble downloading with Google Chrome, Vivaldi, Brave or other Chromium based browser, try using a right-click and select Open in new Window, then F5, or use another browser such as Firefox | ![]() |
![]() |
The latest version of this mod uses the guidelines for TNG v12+ cust_text.php files. If you are using TNGv12+, and any cust_text.php file in this mod is marked with a Bad Target error, you need to update your cust_text.php files before you can install this mod. [Show instructions]
If you upgraded to TNGv12+, and did not update your cust_text.php files as instructed in the upgrade readme script, then you must use the TNG Mod Manager to update them. To do so:
[See details in the TNGv12 Change Impacts Article][Hide the instructions] |
|
Personal Table Maintenance | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Summary | Adds any of your personal tables to the TNG's database maintenance cycle. | |||||||||||
Validation | The mod is XHTML compliant.![]() | |||||||||||
Mod Updated | 16 Jan 2023 | |||||||||||
Download link | For
For
Updated for PHP 8.1 personal_table_maintenance_v13.0.0.5.zip For
personal_table_maintenance_v10.1.0.4.zip [Show Previous Versions]
For
personal_table_maintenance_v9.1.2.3.zip
For
personal_table_maintenance_v8.1.3.2.zip [Hide Previous Versions] | |||||||||||
Download stats | Download statisics (v 10,13,14) | |||||||||||
Author(s) | Bart 'Roebie' Degryse Supported by Ken Roy | |||||||||||
Homepage | Personal Table Maintenance (This page) | |||||||||||
Mod Support | TNG Community Forums | |||||||||||
Contact Developer | TNG Community Forums | |||||||||||
Latest Mod | 14.0.0.6a for TNG v14+ 13.0.0.5 for TNG v13+ 10.1.0.4 for TNG v10.1+ 9.1.2.3 for TNG v9.1.2+ 9.0.0.2 for TNG v9.0.0 - v9.1.1 8.1.3.2 for TNG v8 | |||||||||||
Min TNG V | 8.1.3 | |||||||||||
Max TNG V | 14+ | |||||||||||
Files modified | admin_backup.php admin_optimize.php admin_restore.php admin_utilities.php languages/English/cust_text.php | |||||||||||
Related Mods | ||||||||||||
Notes |
Purpose of the mod
This mod will add any of your personal tables to the TNG's database maintenance cycle.
Developer
This mod was developed by Bart 'Roebie' Degryse.
Updated for TNG 10.1 by Ken Roy who now supports the mod.
Updated for TNG 13 using PHP 8.1 by Ken Roy and Brent Hemphill
Requirements
- A working TNG installation.
- A backup of all affected files (see the list in the summary in the upper right corner of the page)
- An installed current version of the Mod Manager.
Revision History
Mod Version | TNG Version | Date | Contents |
---|---|---|---|
14.0.0.6a | 14.0 | 16 Jan 2023 | Updated to fix issue with French text variable reported by Chris made by Michel Kirsch and published by Ken Roy |
14.0.0.6 | 14.0 | 12 Dec 2022 | Updated for TNG v14 by Michel Kirsch and published by Ken Roy |
13.0.0.5 | 13.0 | 21 Mar 2022 | Updated for PHP 8.1 to fix PHP Deprecated: preg_split(): Passing null to parameter #3 ($limit) of type int is deprecated in admin_utilities.php on line 68 code change provided by Brent Hemphill Updated by Ken Roy to use TNG v12 cust_text.php anchor |
10.1.0.4 | 10.1 | 12 Jan 2015 | Updated for TNG 10.1 for MySQLi and Mod Manager syntax rule changes |
9.1.2.3 | 9.1 | 19 Feb 2013 | Darrin fixed some bugs in TNG v9.1.2 per my request, so the mod must adapt too. |
8.1.3.2 | 8.1 | 1 Feb 2013 | New feature: non-existing tables will be marked as such. The three action buttons and the check box will be hidden.
TNG bug fix: After a first-time backup of a table the restore button now becomes visible without having to refresh the page. Darrin has promised to include this fix in the next TNG version. |
9.0.0.2 | 9.0 | 1 Feb 2013 | New feature: non-existing tables will be marked as such. The three action buttons and the check box will be hidden.
TNG bug fix: After a first-time backup of a table the restore button now becomes visible without having to refresh the page. Darrin has promised to include this fix in the next TNG version. |
8.1.3.1 | 8.1 | 28 Jan 2013 | Bug fix (php error *Warning*: array_keys(): The first argument should be an array on line *24*) |
9.0.0.1 | 9.0 | 28 Jan 2013 | Bug fix (php error *Warning*: array_keys(): The first argument should be an array on line *24*) |
8.1.3.0 | 8.1 | 27 Jan 2013 | Initial release |
9.0.0.0 | 9.0 | 27 Jan 2013 | Initial release |
Conflicts and Issues
- Works only for tables in the same database as your TNG tables.
- (<= 9.0.0.1, <= 8.1.3.1) Tables must exist. If they don't you'll get errors when you attempt to back up, optimize, restore or delete them.
Installation
- Uninstall and delete previous version of this mod (if installed)
- Download the appropriate zip file as shown in the mod summary in the upper right corner of the page.
- Extract the file from the downloaded zip file into the mods folder or FTP the extracted file to your mods folder.
- Follow the normal automated installation for Mod Manager, as shown in the example Mod Manager - Installing Config Files to install the mod.
- Press the Editbutton in Mod Manager and add any table to the text box. The rules to follow are listed in the next paragraph.
Rules
- Only 1 table per line
- Each line looks like xxx:yyy
- xxx is the name of the table in the database
- yyy is the tables's descriptive name
Feature List
- Each table you add on the Edit page will appear next to the default TNG tables on the Admin >> Utilities >> Tables page of your TNG website with its descriptive name.
- You will be able to back up, restore, optimize and delete each table just like any of the default TNG tables.
- Your personal tables' structure will be backed up or restored along with the default tables on the Admin >> Utilities >> Table structure page.
- Non-existing tables will be marked as such and the backup, optimize and restore buttons will be hidden.
In the event of a problem
- Try using the Mod Manager Remove capability
- Copy the backup of the affected files back to your TNG directory
- Contact us through the TNG Community Forums.
Uninstalling the mod
If you want to completely Remove (uninstall) this mod and any tables if created, you should
- click the Uninstall button to uninstall the mod
- click the Delete button to delete the config file from the mods folder.
Upgrade
- Uninstall and eventually Delete the current Mod.
- Proceed as for an installation with the new Mod.
Visualization of this mod
The following images show the visual effects of installing the mod.
Sites using this mod
If you download and install this mod, please add your TNG site to the table below:
URL | User | Note | Mod-Version | TNG-Version | User-language | |
---|---|---|---|---|---|---|
no public site | Bart 'Roebie' Degryse | Mod developer | 9.1.2.3 | 9.1.2 | NL,EN,ES,FR | |
Our Roy and Boucher Family | Ken Roy | Thanks for this mod. Works great! | 14.0.0.6a |
|
EN,FR | |
Chamberlain and Eidenbenz Genealogy | Graham Chamberlain | 10.1.0.4 | 12.0.1 | EN,DE,FR,NL,ES | ||
Mitchell Families Online | Roger Mitchell | Very useful (as always from Bart!) | 9.1.2.3 | 9.1.2 | EN | |
British 1820 Settlers to South Africa | Paul Tanner-Tremaine | Certainly saved me a lot of coding, thanks Bart! | 14.0.0.6a | 14.0.2 | EN | |
Hooley Family Links | Rick Hooley | Public/Private | See Here | See Here | EN | |
My family | ![]() |
(no public site) | see here | DE,NL,EN | ||
DJCM.DK | Claus Martinussen | Public site | 10.1.0.4 | 12.0 | EN,DA | |
Wortelboer Genealogy | Bernard Wortelboer | Public site | 10.1.0.4 | 11.0.0 | NL,EN | |
Brady Family Tree in Western Australia | Darryl Brady | Public site | 10.1.0.4 | 10.1.1 | EN,DE | |
Our Family History | Tor Lund | Public site | 10.1.0.4 | 12.2 | NO,EN,DE | |
Brabantse Genealogie | Rob van Rij | Public Site | 10.1.0.4 | 12.2 | EN,NL | |
R G Strong Family Genealogy | Russell G. Strong | Public Site | 14.0.0.6a | 14.0.4 | EN,FR,DE,NL | |
OurLife Family History - McMullen Clan | Sean Thompson | Not a public site. | 10.1.0.4 | 11.1.0 | EN | |
Wilton, Brimson, Munro and Forward Families | Sharon Lewis | 10.1.0.4 | 11.1.0 | EN | ||
The Severijns / Timmer Familytree | Rob Severijns | Public / Private | See here | See here | NL, EN | |
Your Roots are Showing | Harold Craswell | Public/Private | See Here | See Here | EN | |
Chris Korte's New Zealand Genealogy Project | Chris Korte | Public / Private | 14.0.0.6a |
|
DA,EN,FR,DE |