#928 Create cleanup report to find empty href attributes in notes

[Jens]

There are a few publication records where the submitter forgot to add the URL to the href attribute of an a tag in the NOTE field and the link therefore simply pointed back to the page itself. Like this:

<a href="">Click me. Now! DO IT!</a>

A new cleanup report to find records with this problem shall be created. For publication records it would look similar to this:

SELECT pubs.pub_id, pubs.pub_title
FROM pubs, notes 
-- assume that multiple spaces have possibly been entered:
WHERE lower(REPLACE(note_note, ' ', '')) LIKE '%<ahref=""%'
AND pubs.note_id = notes.note_id;

The same might apply for notes in titles, series, etc

[Ahasuerus]

Implemented in:

edit/cleanup_report.py 1.66
edit/isfdblib.py 1.169
nightly/nightly_update.py 1.173

Installed in r2016-197 on 2016-11-28. Closing the FR.