Empty notes

From TNG_Wiki
Jump to navigation Jump to search

Get rid of those pesky empty notes

Copy and paste the text between the lines into the MySQL section of your MySQL admin, IMPORTANT: Make a backup before you try anything and use this at your own risk!


DELETE FROM tng_notelinks
WHERE (
gedcom, xnoteID
) NOT
IN (


SELECT gedcom, ID
FROM tng_xnotes
);