Issues 2020-05

1. The OPEN RESEARCH Logo is hidden at https://www.openresearch.org/mediawiki/resources/assets/openresearch_logo_2017_rgb_resized.png - it would be easier to have it in the image directory as a normally uploaded file see
2. All images older than 2016 are missing see https://www.openresearch.org/mediawiki/index.php?title=Special:ListFiles&offset=20161024164453. It looks this happened in an attempt to get rid of SPAM images uploaded in 2013 ...
3. Cleanup templates see https://www.openresearch.org/mediawiki/index.php?title=Special:Templates&limit=500&offset=0 - many Templates are not used or broken or both
4. Fix SPARQL endpoint see https://www.openresearch.org/wiki/Sparql_endpoint and MediaWiki:Sidebar
5. Fix https://www.openresearch.org/wiki/Special:WantedProperties
6. "has Proceedings Link" is used on some pages but has not effect since property is not defined and not used in template (any more?) see EKAW_2016
7. duplicates, red links and N/A dummies e.g. https://www.openresearch.org/wiki/Property:Has_location_city
8. Fix missing property Property:Field
9. 👍 Add Property:wikidataid and use it e.g. in Template:Event_series
10. Expression error: Unrecognized punctuation character ",". e.g. in AAAI
11. 👍 Add Property:isA and use it ✓
12. improve refreshing of properties by calling runJobs from crontab entry every minute
13. 👍 Remove or fix CFP SPAM e.g. https://www.openresearch.org/wiki/Special:Contributions/119.152.111.95
14. 👍 Remove or fix Faulty CSV import e.g. https://www.openresearch.org/wiki/Special:Contributions/Nikidemus
15. 👍 Default length of Lists in EventSeries change length from 10 to 50 ✓
16. fix Property:Has_processing_error issues 4046 x occuring in this wiki
17. 👍

    Fehler beim Erstellen des Vorschaubildes: /bin/bash: convert: command not found

    -> convert installed by Felix Saurbier ✓
18. Acronym_Length_Histogram
19. 👍 Database backup is far too big for number of pages 1.4 GB -> probably SPAM revisions still in database - cleanup would save lots of space ... see below
20. 👍 Extension für Syntax-Highlighting scheint zu fehlen

-> pygmentized installed by Torsten Kind✓

1. Proceedings DOI not used
2. Löschrechte Einrichten für einige Kuratoren
3. Fix property Property:End_date and invalidate date entries
4. 👍 mySQL Database content issues: 1.5 GB is far too big l10n_cache: 708 MB, searchindex: 682 MB, text: 404 MB - some 50% of text are still spam and blow up database size and slow down migration as well as running into followup issues that make upgrading impossible if not cleaned up. See ConfIDent 2020-08-03 Workdocumentation of WF
5. 👍 Duplicate Event declarations e.g. ALENEX 2018,CSMR_2009,ISMAR 2007,QoSA 2012,WICSA 2015!,WICSA/ECSA 2009 ✓
6. 👍 Duplicate Acronyms Workdocumentation_2020-08-26
7. 👍 Acronyms with high length Workdocumentation_2020-08-26
8. 👍 Workdocumentation_2020-09-01#Invalid_year_entries ✓