• Uninstalled and removed the visitors module => reduced the database size by 20GB.
• Reduced the access log to only hold 3 days  => reduced the database size by 800MB.
• Unistalled the Apache Solr modules which were not used any longer and removed the according tables.
• Deleted the views data export module which was defectiv.
• Deleted the outdated and no longer supported module imageapi
• Installed the module module_missing_message_fixer to get rid of error messages regarding not properly removed modules (most likely relikts from Drupal 6).
• Removed the migration tables from the database, which are no longer required but haven't been cleaned after the migration from Drupal 6 to Drupal 7.
• Security Updates:
  • Drupal 7.59 => 7.67
  • Context 7.x-3.7 => 7.x-3.10
  • Easy Breadcrumb 7.x-2.15 => 7.x-2.17
  • Lightbox2 7.x-1.0-beta1 => 7.x-1.0-beta2
  • Link 7.x-1.4 => 7.x-1.7
  • Mime Mail 7.x-1.0 => 7.x-1.1
  • Module filter 7.x-2.1 => 7.x-2.2
  • Universally Unique ID 7.x-1.2 => 7.x-1.3
  • Views 7.x-3.20 => 7.x-3.23
  • XML sitemap 7.x-2.3 => 7.x-2.6
• The Glossify module is no longer supported for Drupal 7, there is however a version for Drupal 8. We keep the module for the time being.

• Deleted unused module address_field.
• Deleted unused module boost.
• Deleted unused module calendar.
• Deleted outdated module context_disable_context.
• Deleted unused module content_audit.
• Deleted unused modules countryicons and countryicons_shiny.
• Deleted outdated modules cronsam and context_disable_context.
• Deleted unused module context_reaction_theme.
• Deleted unused module custom_formatters.
• Deactivated and deleted development module devel. This module shouldn't be installed on a productive system.
• Deleted unused module dialog.
• Deleted non Drupal script files dis, dl, en, sc in the directory sites/all/modules.
• Deleted sql-dump-files field_event_type.mysql and revision_field_event_type.mysql in the directory sites/all/modules.
• Deleted unused module dlh.
• Deleted unused module formatted_number.
• Deleted unused module footnotes.
• Deleted unused module geonames.
• Deleted unused module graphviz_filter.
• Deleted outdated module helper.
• Deleted unused module jquery_update.
• Deleted unused module juicebox.
• Deleted unused module kml.
• Deleted unused module leaflet_mapbox.
• Deleted outdated module mailman_manager.
• Deleted unused module mapbox.
• Deleted unused module menu_attributes.
• Deleted unused modules migrate and migrate_d2d.
• Deleted unused module modalframe.
• Deleted unused module mollom.
• Deleted unused module multiblock.
• Deleted unused module node_clone.
• Deleted outdated module openlayers_plus.
• Deleted unused module phpmailer.
• Deleted unused module security_review.
• Deleted unused module simplehtmldom.
• Deleted unused module spambot.
• Deleted unused module swfaddress.
• Deleted outdated module user_mailman_register.
• Deleted unused module views_rss_georss.
• Deleted unused module wikitools.

Outdated modules are modules from Drupal 6 not supported in Drupal 7.

Image module is now in core. Deleted the contrib module image in sites/all/modules.

Non critical updates of modules:

• ACL 7.x-1.1 => 7.x-1.2
• Administration menu 7.x-3.0-rc5 => 7.x-3.0-rc6
• Administration language 7.x-1.0-beta4 => 7.x-1.0
• Advanced help 7.x-1.4 => 7.x-1.5
• Backup and Migrate 7.x-3.5 => 7.x-3.6
• Block Class 7.x-2.3 => 7.x-2.4
• Chaos tools 7.x-1.14 => 7.x-1.15
•  Chain Menu Access API 7.x-2.0 => 7.x-2.1

Updated Modules:

• Facet API 7.x-1.5 => 7.x-1.6
• Diff 7.x-3.3 => 7.x-3.4
• Featured Content 7.x-1.5 => 7.x-1.6
• Field Permission 7.x-1.0 => 7.x-1.1
• Font Awesome 7.x-3.5 => 7.x-3.12
• Format Number API 7.x-1.x-dev => 7.x-1.0-rc1
• Forum Access 7.x-1.3 => 7.x-1.4
• Geofield 7.x-2.3 => 7.x-2.4
• Google Analytics 7.x-2.4 => 7.x-2.6
• Hierarchical Select 7.x-3.0-beta8 => 7.x-3.0-beta9
• Internationalization 7.x-1.24 => 7.x-1.26
• Imagecache Token 7.x-1.0-rc2 => 7.x-1.0
• Libraries 7.x-2.3 => 7.x-2.5
• Link 7.x-1.6 => 7.x-1.7
• Mail System 7.x-2.34 => 7.x-2.35
• Menu Block 7.x-2.7 => 7.x-2.8
• Menu Per Role 7.x-1.0-beta1 => 7.x-1.0
• Organic groups 7.x-2.9 => 7.x-2.10
• Real name 7.x-1.3 => 7.x-1.4
• Schema.org Metatag 7.x-1.2 => 7.x-1.3
• Service links 7.x-2.3 => 7.x-2.4
• Ultimate Cron 7.x-2.7 => 7.x-2.8
• Viewfield 7.x-2.1 => 7.x-2.2
• Views Accordion 7.x-1.1 => 7.x-1.6
• Views Datasource 7.x-1.0-alpha2 => 7.x-1.0-alpha3
• Webform 7.x-4.17 => 7.x-4.20
• Wysiwyg 7.x-2.5 => 7.x-2.6

The module d3.js stays in its actual version, as this version is newer than the recommended version of the module.

Found the culprit which blocked the search-index beeing build. The node 8633 created 2014-07-04 15:08:42 +0200 by admin contained php-code which lead to an php-error. Since that date the search-index hasn't been properly setup.

I've deleted that node.

I've setup a cron job on the Linux server  to run every 5 minutes to rebuild the index. That will take a few hours to be done.

After the rebuild is done I'll change the cron job to run every 30 minutes. that will be sufficient for this page.

After about 75% of indexing an error showed up, that the entered date was to big for a tablefield in table search_dataset. Field data of type text could only hold 64k of data which in this case wasn't sufficient.
Changed field data in table search_dataset from text to mediumtext which can hold about 16MB of data. After that change indexing continued.

Made a change in the responsive.js in the Zircon theme.
There is a selector chain that  to widly works for images changing there heigth. Ensured by using a :not pseudo class, that the images from the news-block on the front page don't get affected as well as the organisations block.

Old selector:   #slideshow-wrapper .view .views-field img, #slideshow-wrapper .view .views_slideshow_cycle_main, #slideshow-wrapper .views-slideshow-cycle-main-frame-row, #slideshow-wrapper .views-slideshow-cycle-main-frame'
New selector : #slideshow-wrapper .view:not(.view-view-active-news):not(view-list-all-rso) .views-field img, #slideshow-wrapper .view .views_slideshow_cycle_main, #slideshow-wrapper .views-slideshow-cycle-main-frame-row, #slideshow-wrapper .views-slideshow-cycle-main-frame'

Deleted all tables where the name started with content_field, content_type or d6_og. These tables are leftovers from Drupal 6 and no longer used.

Drupal core 7.67  =>  Drupal core 7.69 (Security Update)
=====================================================================
Honeypot 7.x-1.25  =>  Honeypot 7.x-1.26
Metatag 7.x-1.25  =>  Metatag 7.x-1.26
Webform 7.x-4.20  =>  Webform 7.x-4.21 (Security Update)

Activated the module Administration menu Toolbar style for better visibility of admin menu.

Drupal core 7.69  =>  Drupal core 7.73 (Security Update)
=============================================================
Advanced Help 7.x-1.5  =>  Advanced Help 7.x-1.6
Backup and Migrate 7.x-3.6  =>  Backup and Migrate 7.x-3.9
Chaos Tool Suite (ctools) 7.x-1.15  =>  Chaos Tool Suite (ctools) 7.x-1.17
Colorbox 7.x-2.13  =>  Colorbox 7.x-2.15
Content Access 7.x-1.2-beta2  =>  Content Access 7.x-1.2-beta3
d3.js 7.x-1.0-alpha3+2-dev (2017-Sep-04)  =>  d3.js 7.x-1.0-alpha3+3-dev (2019-Feb-19)
Feeds 7.x-2.0-beta4  =>  Feeds 7.x-2.0-beta5
Font Awesome Icons 7.x-3.12  =>  Font Awesome Icons 7.x-3.13
Geocoder 7.x-1.4  =>  Geocoder 7.x-1.6
geoPHP 7.x-1.7  =>  geoPHP 7.x-1.8
Internationalization 7.x-1.26  =>  Internationalization 7.x-1.27 (Security Update)
Leaflet GeoJSON 7.x-1.0  =>  Leaflet GeoJSON 7.x-2.0 (Security Update)
Metatag 7.x-1.26  =>  Metatag 7.x-1.27
Panels 7.x-3.9  =>  Panels 7.x-3.10
Schema.org Metatag 7.x-1.3  =>  Schema.org Metatag 7.x-1.4
Views (for Drupal 7) 7.x-3.23  =>  Views (for Drupal 7) 7.x-3.24
Views Slideshow 7.x-3.9  =>  Views Slideshow 7.x-3.10
Webform 7.x-4.21  =>  Webform 7.x-4.23

Drupal core 8.9.14  =>  Drupal core 8.9.15
=============================================================================
Chaos Tool Suite (ctools) 8.x-3.5  =>  Chaos Tool Suite (ctools) 8.x-3.6.(Security Update)
Menu Block 8.x-1.6.->Menu Block 8.x-1.7
Views Bulk Operations (VBO) 8.x-3.12  =>  Views Bulk Operations (VBO) 8.x-3.13
Views Conditional 8.x-1.3  =>  Views Conditional 8.x-1.4
Webform 8.x-5.25  =>  Webform 8.x-5.26

Drupal core 8.9.17  =>  Drupal core 8.9.18 (Security Update)

Drupal core 9.3.0  =>  Drupal core 9.3.5 (Security Update)
======================================================================================================
Colorbox 8.x-1.7  =>  Colorbox 8.x-1.8 (Security Update)
FileField Sources 8.x-1.0-alpha4  =>  FileField Sources 8.x-1.0-alpha5
Geocoder 8.x-3.24  =>  Geocoder 8.x-3.25
Geofield 8.x-1.35  =>  Geofield 8.x-1.36
Insert 8.x-2.0-beta2  =>  Insert 8.x-2.0-beta3
jQuery UI Datepicker 8.x-1.1  =>  jQuery UI Datepicker 8.x-1.2 (Security Update)
Leaflet 2.1.19  =>  Leaflet 2.1.20
Pathauto 8.x-1.8  =>  Pathauto 8.x-1.9
Search API 8.x-1.21  =>  Search API 8.x-1.23
Smart Date 3.4.3  =>  Smart Date 3.5.0
Transliterate filenames for uploads 8.x-1.5  =>  Transliterate filenames for uploads 8.x-1.10
======================================================================================================
PHP-module no longer supported and should be removed. Check required if and where it is used.

Smart Date 3.4.2  =>  Smart Date 3.4.3
Text Resize 8.x-1.1  =>  Text Resize 8.x-1.2
W3CSS THEME FOR DRUPAL (8 & 9) 8.x-1.21  =>  W3CSS THEME FOR DRUPAL (8 & 9) 8.x-1.22  Taken back to Version 1.21 due to CSS Issues on home page

Drupal core 8.9.10  =>  Drupal core 8.9.19 (Security Update)

Drupal core 8.9.16  =>  Drupal core 8.9.17 (Security Update)
=========================================================================================
Backup and Migrate 8.x-4.1  =>  Backup and Migrate 8.x-4.2
Better Exposed Filters 8.x-5.0-beta1  =>  Better Exposed Filters 8.x-5.0-beta3
Geofield 8.x-1.31  =>  Geofield 8.x-1.34
Publish Content 8.x-1.3  =>  Publish Content 8.x-1.4
Quick Tabs 8.x-3.0-alpha4  =>  Quick Tabs 8.x-3.0-alpha5
Search API 8.x-1.19  =>  Search API 8.x-1.20
Webform 8.x-5.26  =>  Webform 8.x-5.27

Devel 4.1.2  =>  Devel 4.1.3
Easy Breadcrumb 8.x-1.5  =>  Easy Breadcrumb 2.0.2 (No longer supported)
File metadata manager 8.x-2.1  =>  File metadata manager 8.x-2.2
Image Effects 8.x-3.1  =>  Image Effects 8.x-3.2
jCarousel 5.0.0-dev  =>  jCarousel 6.0.0-alpha1 (No longer supported)
Leaflet 2.1.16  =>  Leaflet 2.1.19
Plugin 8.x-2.8  =>  Plugin 8.x-2.9

Drupal core 9.2.9  =>  Drupal core 9.3.0
==================================================================================
Devel 4.1.1  =>  Devel 4.1.2
Feeds 8.x-3.0-alpha10  =>  Feeds 8.x-3.0-alpha11
Geocoder 8.x-3.20  =>  Geocoder 8.x-3.24
Honeypot 2.0.1  =>  Honeypot 2.0.2
jCarousel 8.x-4.0  =>   jCarousel 8.x-5.x-dev
Leaflet 2.1.14  =>  Leaflet 2.1.16
Mime Mail 8.x-1.0-alpha3=>Mime Mail 8.x-1.0-alpha4
Token 8.x-1.9  =>  Token 8.x-1.10
Webform 6.1.0  =>  Webform 6.1.2 (Security Update)
XML sitemap 8.x-1.1  =>  XML sitemap 8.x-1.2

Drupal core 9.5.9  =>  Drupal core 9.5.10
==========================================================================
Blazy 8.x-2.15  =>  Blazy 8.x-2.16
Charts 5.0.6  =>  Charts 5.0.7
CKEditor 4 - WYSIWYG HTML editor 1.0.1  =>  CKEditor 4 - WYSIWYG HTML editor 1.0.2
File metadata manager 8.x-2.5  =>  File metadata manager 8.x-2.6
Geofield 8.x-1.53  =>  Geofield 8.x-1.54
geoPHP 8.x-1.0  =>  geoPHP 8.x-1.1
Google Analytics 8.x-3.1  =>  Google Analytics 4.0.2
Leaflet 10.0.14  =>  Leaflet 10.0.19
Libraries API 4.0.3  =>  Libraries API 4.0.4
Masquerade 8.x-2.0-rc1  =>  Masquerade 8.x-2.0-rc4
Slick Carousel 8.x-2.8  =>  Slick Carousel 8.x-2.9
Slick Views 8.x-2.6  =>  Slick Views 8.x-2.7
SpamSpan filter 8.x-1.3  =>  SpamSpan filter 3.1.6
Superfish 8.x-1.4  =>  Superfish 8.x-1.6
Token 8.x-1.11  =>  Token 8.x-1.12
Views Bulk Operations (VBO) 4.2.4  =>  Views Bulk Operations (VBO) 4.2.5
Webform 6.1.4  =>  Webform 6.1.5
XML sitemap 8.x-1.4  =>  XML sitemap 8.x-1.5

Drupal core 10.3.2  =>  Drupal core 10.3.6
================================================================
Better Exposed Filters 6.0.6  =>  Better Exposed Filters 7.0.2
=> removed modules jquery_ui_touch_punch, jquery_ui_slider and jquery_ui_datepicker
Blazy 3.0.10  =>  Blazy 3.0.13
CKEditor 5 Plugin Pack 1.2.1  =>  CKEditor 5 Plugin Pack 1.2.2
Diff 8.x-1.7  =>  Diff 8.x-1.8 (Security Update)
Feeds 8.x-3.0-beta5  =>  Feeds 8.x-3.0-rc2
Feeds Tamper 8.x-2.0-beta3  =>  Feeds Tamper 8.x-2.0-beta4
Flood control 2.3.4  =>  Flood control 3.0.0
Geofield 8.x-1.60  =>  Geofield 8.x-1.61
Publish Content 8.x-1.6  =>  Publish Content 8.x-1.7
Real Name 2.0.0-beta2.->Real Name 2.0.0
Smart Date 4.1.5  =>  Smart Date 4.1.6
Tamper 8.x-1.0-alpha4  =>  Tamper 8.x-1.0-alpha5
Views Bulk Operations (VBO) 4.2.7  =>  Views Bulk Operations (VBO) 4.3.1
 

Drupal core 9.3.5  =>  Drupal core 9.3.7 (Security Update)
=====================================================================================================
Crop API 8.x-2.1  =>  Crop API 8.x-2.2
Devel 4.1.3  =>  Devel 4.1.5
Entity API 8.x-1.2  =>  Entity API 8.x-1.3
Feeds 8.x-3.0-alpha11  =>  Feeds 8.x-3.0-beta1
File metadata manager 8.x-2.2  =>  File metadata manager 8.x-2.4
Geofield 8.x-1.36  =>  Geofield 8.x-1.37
Smart Date 3.5.0  =>  Smart Date 3.5.1
Views Bulk Operations (VBO) 8.x-3.13  =>  Views Bulk Operations (VBO) 4.1.0
Webform 6.1.2  =>  Webform 6.1.3
W3CSS Theme (Drupal 8, 9, 10) ⚡️ 8.x-1.21  =>  W3CSS Theme (Drupal 8, 9, 10) ⚡️ 2.0.4

Drupal core 9.3.7   =>   Drupal core 9.3.12 Security Update
===============================================================================================
Colorbox 8.x-1.8   =>   Colorbox 8.x-1.8=10
Flood control 2.2.2   =>   Flood control 2.2.3
Geocoder 8.x-3.25   =>   Geocoder 8.x-3.26
Geofield 8.x-1.37   =>   Geofield 8.x-1.39
Leaflet 2.1.20   =>   Leaflet 2.1.23
Menu Block 8.x-1.7   =>   Menu Block 8.x-1.8
Pathauto 8.x-1.9   =>   Pathauto 8.x-1.10
Publish Content 8.x-1.4   =>   Publish Content 8.x-1.5
Views Bulk Operations (VBO) 4.1.0   =>   Views Bulk Operations (VBO) 4.1.2

Drupal core 9.3.12  =>  Drupal core 9.4.8 (Security Update)
============================================================================================
Admin Toolbar 8.x-2.5  =>  Admin Toolbar 3.2.1
Advanced Insert View 8.x-1.0-beta2  =>  Advanced Insert View 2.0.0-alpha2
Automated Logout 8.x-1.3  =>  Automated Logout 8.x-1.4
Backup and Migrate 5.0.1  =>  Backup and Migrate 5.0.2
Better Exposed Filters 8.x-5.0  =>  Better Exposed Filters 8.x-5.2
Chaos Tool Suite (ctools) 8.x-3.7  =>  Chaos Tool Suite (ctools) 8.x-3.11
Charts 5.0.0-alpha3  =>  Charts 5.0.3
Content Access 8.x-1.0-alpha3  =>  Content Access 8.x-1.0-alpha4
Crop API 8.x-2.2  =>  Crop API 8.x-2.3
Devel 4.1.5  =>  Devel 4.2.1
Diff 8.x-1.0  =>  Diff 8.x-1.1
Easy Breadcrumb 2.0.2  =>  Easy Breadcrumb 2.0.3
Entity API 8.x-1.3  =>  Entity API 8.x-1.4
Feeds 8.x-3.0-beta1  =>  Feeds 8.x-3.0-beta2
Field Group 8.x-3.2  =>  Field Group 8.x-3.3
Field Permissions 8.x-1.1  =>  Field Permissions 8.x-1.2
File metadata manager 8.x-2.4  =>  File metadata manager 8.x-2.5
Flood control 2.2.3  =>  Flood control 2.2.4
Geocoder 8.x-3.26  =>  Geocoder 8.x-3.31
Geofield 8.x-1.39  =>  Geofield 8.x-1.45
Honeypot 2.0.2  =>  Honeypot 2.1.2
Image Effects 8.x-3.2  =>  Image Effects 8.x-3.4
IMCE 8.x-2.4  =>  IMCE 8.x-2.5
Job Scheduler 8.x-3.1  =>  Job Scheduler 4.0.0
jQuery UI Datepicker 8.x-1.2  =>  jQuery UI Datepicker 8.x-1.4
jQuery UI TouchPunch 1.0.0  =>  jQuery UI TouchPunch 1.1.0
Leaflet 2.1.23  =>  Leaflet 2.2.10
Mail System 8.x-4.3  =>  Mail System 8.x-4.4
Masquerade 8.x-2.0-beta4  =>  Masquerade 8.x-2.0-rc1
Pathauto 8.x-1.10  =>  Pathauto 8.x-1.11
Redirect 8.x-1.7  =>  Redirect 8.x-1.8
Search API 8.x-1.23  =>  Search API 8.x-1.26
Smart Date 3.5.1  =>  Smart Date 3.6.1
SMTP Authentication Support 8.x-1.0  =>  SMTP Authentication Support 8.x-1.1
SpamSpan filter 8.x-1.2  =>  SpamSpan filter 8.x-1.3
Token 8.x-1.10  =>  Token 8.x-1.11
Transliterate filenames for uploads 2.0.0  =>  Transliterate filenames for uploads 2.0.1
Twig Tweak 8.x-2.9  =>  Twig Tweak 3.2.0
Views Bulk Operations (VBO) 4.1.2  =>  Views Bulk Operations (VBO) 4.2.0
Views Conditional 8.x-1.4,=>Views Conditional 8.x-1.5
XML sitemap 8.x-1.2  =>  XML sitemap 8.x-1.4
W3CSS Theme (Drupal 8, 9, 10) ⚡️ 2.0.4  =>  W3CSS Theme (Drupal 8, 9, 10) ⚡️ 2.0.5

Admin Toolbar 3.2.1  =>  Admin Toolbar 3.3.0
Chaos Tool Suite (ctools) 8.x-3.11  =>  Chaos Tool Suite (ctools) 8.x-3.13
Content locking (anti-concurrent editing) 8.x-2.2  =>  Content locking (anti-concurrent editing) 8.x-2.3
Currency 8.x-3.3  =>  Currency 8.x-3.4
Easy Breadcrumb 2.0.3  =>  Easy Breadcrumb 2.0.4 revoked because of fatal error, fixed to 2.0.3
Field Group 8.x-3.3  =>  Field Group 8.x-3.4
Geofield 8.x-1.45  =>  Geofield 8.x-1.47
Image Widget Crop 8.x-2.3  =>  Image Widget Crop 8.x-2.4
jQuery UI 8.x-1.4  =>  jQuery UI 8.x-1.6
Leaflet 2.2.10  =>  Leaflet 2.2.12
Leaflet More Maps 2.1.2  =>  Leaflet More Maps 2.1.3
Menu Block 8.x-1.8  =>  Menu Block 8.x-1.10
Page Manager 8.x-4.0-beta6  =>  Page Manager 8.x-4.0-rc1
Panels 8.x-4.6  =>  Panels 8.x-4.7
Plugin 8.x-2.9  =>  Plugin 8.x-2.10
Search API 8.x-1.26  =>  Search API 8.x-1.28 (Security Update)
SMTP Authentication Support 8.x-1.1  =>  SMTP Authentication Support 8.x-1.2
Views Bulk Operations (VBO) 4.2.0  =>  Views Bulk Operations (VBO) 4.2.1

Drupal core 9.4.8  =>  Drupal core 9.5.2 (Security Update)
=================================================================================
Backup and Migrate 5.0.2.->Backup and Migrate 5.0.3
Blazy 8.x-2.13  =>  Blazy 8.x-2.14
Charts 5.0.3  =>  Charts 5.0.4
Devel 4.2.1  =>  Removed
Devel Entity Updates 3.0.1  =>  Removed
Easy Breadcrumb 2.0.3  =>  Easy Breadcrumb 2.0.5
Fast Permissions Administration 3.0.2  =>  Fast Permissions Administration 4.0.0
Feeds 8.x-3.0-beta2  =>  Feeds 8.x-3.0-beta3
Feeds Tamper 8.x-2.0-beta2  =>  Feeds Tamper 8.x-2.0-beta3
Geofield 8.x-1.47  =>  Geofield 8.x-1.52
Module Filter 8.x-3.2  =>  Module Filter 4.0.1
Module Missing Message Fixer 2.0.2  =>  Module Missing Message Fixer 2.0.3
Page Manager 8.x-4.0-rc1  =>  Page Manager 8.x-4.0-rc2
Publish Content 8.x-1.5  =>  Publish Content 8.x-1.6
Single DateTimePicker 8.x-1.8-beta1  =>  Single DateTimePicker 8.x-1.8
Slick Carousel 8.x-2.6  =>  Slick Carousel 8.x-2.7
Tamper 8.x-1.0-alpha2  =>  Tamper 8.x-1.0-alpha3
Text Resize 8.x-1.2  =>  Text Resize 8.x-1.3
Views Bulk Operations (VBO) 4.2.1  =>  Views Bulk Operations (VBO) 4.2.3
Webform 6.1.3  =>  Webform 6.1.4
W3CSS Theme ⚡️ 2.0.6  =>  W3CSS Theme ⚡️ 2.0.8

Drupal core 9.5.2  =>  Drupal core 9.5.3
====================================================================
CKEditor FakeObjects 8.x-1.1  =>  CKEditor FakeObjects 8.x-1.2
remove Devel (Security reason)
remove Devel Entity Updates (Security reason)
Flood control 2.2.4  =>  Flood control 2.3.0(Security Update)
remove PHP 8.x-1.1 (Security reason)
Unused Modules 8.x-1.3  =>  Unused Modules 8.x-1.5
Viewfield 8.x-3.0-beta6  =>  Viewfield 8.x-3.0-beta7
W3CSS Theme ⚡️ 2.0.8  =>  W3CSS Theme ⚡️ 2.0.9

Drupal core 9.5.3  =>  Drupal core 9.5.7 (Security Update)
=======================================================================================
Conditional Fields 4.0.0-alpha1  =>  Conditional Fields 4.0.0-alpha2
Flood control 2.3.0  =>  Flood control 2.3.2
Job Scheduler 4.0.0  =>  Job Scheduler 4.0.1
Libraries API 8.x-3.0-beta2  =>  Libraries API 4.0.1
Mime Mail 8.x-1.0-alpha4  =>  Mime Mail 8.x-1.0-alpha5
Quick Tabs 8.x-3.0-alpha5  =>  Quick Tabs 8.x-3.0-alpha7
Real Name 2.0.0-beta1  =>  Real Name 2.0.0-beta2
Smart Date 3.6.1  =>  Smart Date 4.0.0-beta1
Twig Tweak 3.2.0  =>  Twig Tweak 3.2.1
Views Accordion 2.0.0  =>  Views Accordion 2.0.1
W3CSS Theme ⚡️ 2.0.9  =>  W3CSS Theme ⚡️ 2.0.11

Drupal core 9.5.7  =>  Drupal core 9.5.9 (Security Update)
=====================================================================================
Admin Toolbar 3.3.0  =>  Admin Toolbar 3.4.1
Blazy 8.x-2.14  =>  Blazy 8.x-2.15
Chaos Tool Suite (ctools) 8.x-3.13  =>  Chaos Tool Suite (ctools) 4.0.4
Charts 5.0.4  =>  Charts 5.0.6
Conditional Fields 4.0.0-alpha2  =>  Conditional Fields 4.0.0-alpha3
Feeds 8.x-3.0-beta3  =>  Feeds 8.x-3.0-beta3\4
Geocoder 8.x-3.31  =>  Geocoder 8.x-3.34
Geofield 8.x-1.52  =>  Geofield 8.x-1.53
Insert 8.x-2.0-beta3.->Insert 8.x-2.0-beta4
Leaflet 2.2.12   =>  Leaflet 10.0.14
Libraries API 4.0.1  =>  Libraries API 4.0.3
Search API 8.x-1.28  =>  Search API 8.x-1.29
Slick Carousel 8.x-2.7  =>  Slick Carousel 8.x-2.8
Tamper 8.x-1.0-alpha3  =>  Tamper 8.x-1.0-alpha4
View Unpublished 8.x-1.0  =>  View Unpublished 8.x-1.1
Views Bulk Operations (VBO) 4.2.3  =>  Views Bulk Operations (VBO) 4.2.4

Drupal core 9.5.9  =>  Drupal core 9.5.10
==========================================================================
Blazy 8.x-2.15  =>  Blazy 8.x-2.16
Charts 5.0.6  =>  Charts 5.0.7
CKEditor 4 - WYSIWYG HTML editor 1.0.1  =>  CKEditor 4 - WYSIWYG HTML editor 1.0.2
File metadata manager 8.x-2.5  =>  File metadata manager 8.x-2.6
Geofield 8.x-1.53  =>  Geofield 8.x-1.54
geoPHP 8.x-1.0  =>  geoPHP 8.x-1.1
Google Analytics 8.x-3.1  =>  Google Analytics 4.0.2
Leaflet 10.0.14  =>  Leaflet 10.0.19
Libraries API 4.0.3  =>  Libraries API 4.0.4
Masquerade 8.x-2.0-rc1  =>  Masquerade 8.x-2.0-rc4
Slick Carousel 8.x-2.8  =>  Slick Carousel 8.x-2.9
Slick Views 8.x-2.6  =>  Slick Views 8.x-2.7
SpamSpan filter 8.x-1.3  =>  SpamSpan filter 3.1.6
Superfish 8.x-1.4  =>  Superfish 8.x-1.6
Token 8.x-1.11  =>  Token 8.x-1.12
Views Bulk Operations (VBO) 4.2.4  =>  Views Bulk Operations (VBO) 4.2.5
Webform 6.1.4  =>  Webform 6.1.5
XML sitemap 8.x-1.4  =>  XML sitemap 8.x-1.5

Admin Toolbar 3.4.1 => Admin Toolbar 3.4.2
Advanced Insert View 2.0.0-alpha2 => Advanced Insert View 2.0.0-alpha3
Automated Logout 8.x-1.4 => Automated Logout 2.0.0
Blazy 8.x-2.16 => Blazy 3.0.9
Block Class 8.x-1.3 => Block Class 2.0.11
Chaos Tool Suite (ctools) 8.x-3.14 => Chaos Tool Suite (ctools) 4.1.0
Charts 5.0.7 => Charts 5.0.13
Ckeditor drupalbreaks 2.0.1 => Ckeditor drupalbreaks 2.0.2
Colorbox 8.x-1.10 => Colorbox 2.0.2
Conditional Fields 4.0.0-alpha3 => Conditional Fields 4.0.0-alpha5
Content Access 8.x-1.0-alpha4 => Content Access 2.0.0
Content locking (anti-concurrent editing) 8.x-2.3  =>  Content locking (anti-concurrent editing) 8.x-2.4
Crop API 8.x-2.3 => Crop API 8.x-2.4
Easy Breadcrumb 2.0.5 => Easy Breadcrumb 2.0.7
Feeds 8.x-3.0-beta4 => Feeds 8.x-3.0-beta5
Field Permissions 8.x-1.2 => Field Permissions 8.x-1.3
File metadata manager 8.x-2.6 => File metadata manager 3.1.0
Flood control 2.3.2 => Flood control 2.3.4
Geocoder 8.x-3.34 => Geocoder 8.x-4.24
Geofield 8.x-1.54 => Geofield 8.x-1.59
geoPHP 8.x-1.1 => geoPHP 8.x-1.2
Honeypot 2.1.2 => Honeypot 2.1.3
Image Effects 8.x-3.4 => Image Effects 8.x-3.6 Nur Drupal 10!!
Image Resize Filter 8.x-1.1 => Image Resize Filter 8.x-1.2
Image Widget Crop 8.x-2.4
IMCE 8.x-2.5 => IMCE 3.1.0
Insert 8.x-2.0-beta4 => Insert 3.0.0 Nur Drupal 10!!
Job Scheduler 4.0.1 => Job Scheduler 4.0.2 Nur Drupal 10!!
jQuery UI 8.x-1.6 => jQuery UI 8.x-1.7
jQuery UI Accordion 2.0.0 => jQuery UI Accordion 2.1.0
jQuery UI Tabs 2.0.0 => jQuery UI Tabs 2.1.0
jQuery UI TouchPunch 1.1.0 => jQuery UI TouchPunch 1.1.1
Leaflet 10.0.19 => Leaflet 10.2.19
Leaflet More Maps 2.1.3 => Leaflet More Maps 2.2.1
Menu Block 8.x-1.10 => Menu Block 8.x-1.11
Menu Trail By Path 8.x-1.3 => Menu Trail By Path 2.0.1
Mime Mail 8.x-1.0-alpha5 => Mime Mail 8.x-1.0-alpha6
Module Filter 4.0.1 => Module Filter 5.0.1 Nur Drupal 10!!
Panels 8.x-4.7 => Panels 8.x-4.8
Pathauto 8.x-1.11 => Pathauto 8.x-1.12
Plugin 8.x-2.10 => Plugin 8.x-2.12
Redirect 8.x-1.8 => Redirect 8.x-1.9
Search API 8.x-1.29 => Search API 8.x-1.35 Nur Drupal 10!!
Single DateTimePicker 8.x-1.8 => Single DateTimePicker 2.0.0-beta2
Slick Carousel 8.x-2.9 => Slick Carousel 3.0.2
Slick extras 8.x-1.0-rc7 => Slick extras 2.0.1
Slick Views 8.x-2.7 => Slick Views 3.0.2
Smart Date 3.7.2 => Smart Date 4.1.3
SpamSpan filter 3.1.6 => SpamSpan filter 3.1.7
Superfish 8.x-1.6 => Superfish 8.x-1.7
Token 8.x-1.12 => Token 8.x-1.14
Transliterate filenames for uploads 2.0.1 => Transliterate filenames for uploads 2.0.2
Twig Tweak 3.2.1 => Twig Tweak 3.3.0
View Unpublished 8.x-1.1 => View Unpublished 8.x-1.2
Viewfield 8.x-3.0-beta7 => Viewfield 8.x-3.0-beta9
Views Bulk Operations (VBO) 4.2.5 => Views Bulk Operations (VBO) 4.2.7
Views Conditional 8.x-1.5 => Views Conditional 8.x-1.10
Views Slideshow 8.x-4.8 => Views Slideshow 5.0.0
Webform 6.1.5 => Webform 6.2.3
XML sitemap 8.x-1.5
W3CSS Theme ⚡️ 2.0.11 => W3CSS Theme ⚡️ 2.0.13

On 26.4.2021 the session lifetime was changed to one day. When the system goes life it will be shortend even to 6 hours.

The change has been don in the file sites/default/sevices.yml. Lifetime is set in seconds.

wla

In the Drupal 7 version the caption of the main article images was handelt by two bits:

• The function hook_preprocess_image() in the theme to add the class "caption" to the image tag
• The module image_caption which added a jQuery-Function to do the work

The module doesn't exist for Drupal 8. The preprocess_image hook luckily still is available.

• With adding the function in the .theme-file of our theme, it was feasable to add the class "caption" to an image set by an image-field when the images style is w225xh150.
• The jQuery-Function was put into the themes js directory into the file "drupal8_w3css_subtheme.theme". There the function worked as in the Drupal 7 version.

Mission accomplished

Caution: when in Drupal 10 jQuery is eliminated, the script has to be rewritten.

Workarount for the bug " Non-translatable fields can only be changed when updating the original language"

Found on https://www.drupal.org/project/drupal/issues/2955321

Created a custom module "wla_enable_translations" to overcome this issue. Code

function wla_enable_translations_entity_type_alter(array &$entity_types) {
  foreach ($entity_types as $entity_type) {
    $constraints = $entity_type->getConstraints();
    unset($constraints['EntityUntranslatableFields']);
    $entity_type->setConstraints($constraints);
  }
}

The breadcrumbs showed the page Element twice in the breadcrumbs. Finally I've found that in Drupal 8 the page title as the final element is handled by Drupal. The Theme D8W3CSS however has a proprocess_breadcrumb-function which adds the page-title if it's not empty. Thus the title shows up twice.

Solution: deactivating the proprocess_breadcrumb-function in the theme D8W3CSS

[error]  A non-existent config entity name returned by FieldStorageConfigInterface::getBundles(): entity type: comment, bundle: comment_node_internal_information, field name: comment_body
[error]  A non-existent config entity name returned by FieldStorageConfigInterface::getBundles(): entity type: comment, bundle: comment_node_recommendedpractices_details, field name: comment_body
[error]  A non-existent config entity name returned by FieldStorageConfigInterface::getBundles(): entity type: comment, bundle: comment_node_recommendedpractices_stepbystep, field name: comment_body
[error]  A non-existent config entity name returned by FieldStorageConfigInterface::getBundles(): entity type: comment, bundle: comment_node_recommended_practices, field name: comment_body
[error]  A non-existent config entity name returned by FieldStorageConfigInterface::getBundles(): entity type: comment, bundle: comment_node_glidenumber, field name: comment_body
[error]  A non-existent config entity name returned by FieldStorageConfigInterface::getBundles(): entity type: comment, bundle: comment_node_geo_information_resource, field name: comment_body
[error]  A non-existent config entity name returned by FieldStorageConfigInterface::getBundles(): entity type: comment, bundle: comment_node_projects, field name: comment_body
[error]  A non-existent config entity name returned by FieldStorageConfigInterface::getBundles(): entity type: comment, bundle: comment_node_un_spider_training_activity, field name: comment_body
[error]  A non-existent config entity name returned by FieldStorageConfigInterface::getBundles(): entity type: node, bundle: glidenumber, field name: body
[error]  A non-existent config entity name returned by FieldStorageConfigInterface::getBundles(): entity type: node, bundle: projects, field name: body
[error]  A non-existent config entity name returned by FieldStorageConfigInterface::getBundles(): entity type: node, bundle: glidenumber, field name: upload
[error]  A non-existent config entity name returned by FieldStorageConfigInterface::getBundles(): entity type: node, bundle: projects, field name: upload

The installation shows error messages regarding no longer existing fields which partially existed back in the Drupal 6 version of spider and are long gone. The Update processes from Drupal 6 to Drupal 7 to Drupal 8 however saved this old information in the database. The removal of those definitions can only be done via programming (see https://codimth.com/blog/web/drupal/how-fix-non-existent-config-entity-name-drupal-8-9, example 3).

By using update hooks in the custom module "practical_use" these errors could be removed one by one.

Invalid config structures can result in exceptions when saving a config entity Issue https://www.drupal.org/project/drupal/issues/2925890 Under certain conditions a view cannot be saved after editing. This patch solve the problem.

Drupal version: 9.3.7

Views relationships with multi-valued entity reference fields invalidate Distinct query option

(https://www.drupal.org/project/drupal/issues/2993688)

This is an issue with a lot of views in the installation which make use of entity relationships. Using the module views_distinct often results in wrong numbering in the pager which results in empty spaces in a multi-page view. This patch is a first solution for it but need further observation.

Implemented 8th of March 2022

wla

Exported types "recommended practices" and "recommended practices details" into the custom module "pract_uses". By mass changing the filenames and mass editing the files these types got converted into the content types "practical use" and "practical use details". When activating this module these content types will become active and stay even if the module gets deactivates and removed later.

In forms with smart-date field types there is an issue that the duration field can't be set and gives the issue "This value should be of the correct primitive type.".

The reason is, that the default duration is not set to an integer but to an empty string. Setting the value to 0 cures the problem.

The fix has to be applied in line 230 of web/modules/contrib/smart_date/src/Plugin/Field/FieldWidget/SmartDateWidgetBase.php in setting $default_duration = 0;

19.5.2021 wla

Language switcher block is not handled via the "block_layout" page but called directly in the file "page.html.twig" in the used subtheme.

To ensure, that only available languages are shown, the function hook_preprocess_links__language_block() is used in the .theme file of the theme. Actually any language but 'en', 'es' and 'fr' gets removed from the link list and the title attribute of the accepted link get changed to the title of the corresponding language.

In the standard Drupal 8.9.15 version, there is no way to limit the year range of date fields. There was however a patch which solved this issue

https://www.drupal.org/project/drupal/issues/2836054 (#50)

Even if that patch is designed for Drupal 9.3 it installed seamlessly for Drupal 8.9.15.
After the installation of that patch there are start- and end-year field in the widget configuration of the date field.

Define 2 new image styles:

• w1214x320
• w300x80

Modify the field featured image in news content type:

• Set max and min dimensions to 1214x320 pixel (i.e. the image must exactly have these dimensions)
• Change help text for featured image to explain, that we need the correct dimensiones
• Change the preview image to style w300x80 to get a better feeling for the result

Change the image style for featured image in the view frontpage slideshow to w1214x320.

The transliteration-Module from Drupal 7 was moved into core in Drupal 8. There is however an outstanding bug related to transliteration of file names. There are discussions how to handle this, but the bug is still not fixed. As a work around someone wrote the module 'transliterate_filenames" to do the work. This module only has to be installed and enabled to handle transliteration of filenames in future.

In the view "list all spider activities" there is the block "Block remote TAS". This display has an "AND" and an "OR" group in the filter section. With the OR-group in place, the was no result even with simpler conditions. Searching through the issue list led to a core issue for views which finally resulted in a patch (https://www.drupal.org/files/issues/2020-10-14/2559961-101.patch). After applying this patch the view worked as expected. This needs to be checked when the upgrade to Drupal 9 should be done.

Taks from meeting:

• Search for PHP-Format (write function to find related nodes)
• Check permission (disabled filter_perms to see all permission)
• check database backups with cron
• enable markdown module

• database backups and rsync
  • set up to backup on other system
• markdown translation to html for spanish site
  • https://www.un-spider.org/es/asesoria/practicas-recomendadas/practica-recomendada-mapeo-inundaciones/paso-a-paso
• Empty values in views, using "views distinct" (e.g. via ID [hidden] )
  • see mail from 8.3.2022 (forwarded 3.11.2022)
  • https://www.drupal.org/project/drupal/issues/2993688
  • Patch is missing in current Drupal version, needs to be installed manually
  • example page for empty values: https://www.un-spider.org/space-application/satellite-technology
  • as soon as patch is installed again, "Distinct Fields" need to be removed, and Query Settings need to be adjusted again
  • Views affected:
    • https://un-spider.org/space-application/satellite-technology
      • https://un-spider.org/admin/structure/views/view/satelites_overview
    • https://un-spider.org/links-and-resources/data-sources
      • https://un-spider.org/admin/structure/views/view/data_sources_overview
    • https://un-spider.org/links-and-resources/gis-rs-software
      • https://un-spider.org/admin/structure/views/view/software_overview
• Date Format
  • Date formats are used in varying different formats... wish to standardize
  • general configuration: https://www.un-spider.org/admin/config/regional/date-time
  • depending on the content type / view, can be changed in view or manage display (content type)
  • task for Martin: start unifying this, report to Werner if problems occur
• Font color (CSS Theme)
  • in some cases, content appears in black, instead of darkgrey
  • e.g. Field "Test Site" https://www.un-spider.org/advisory-support/recommended-practices/recommended-practice-agriculture-drought-monitoring
  • needs to be changed in CSS
  • task for Martin: collect pages where this occurs...

next meeting: 17.11.2022 15:00

• database backups and rsync
  • set up to backup on other system
• markdown translation to html for spanish site
  • https://www.un-spider.org/es/asesoria/practicas-recomendadas/practica-recomendada-mapeo-inundaciones/paso-a-paso
• Date Format
  • Date formats are used in varying different formats... wish to standardize
  • general configuration: https://www.un-spider.org/admin/config/regional/date-time
  • depending on the content type / view, can be changed in view or manage display (content type)
  • task for Martin: start unifying this, report to Werner if problems occur
  • Format as defined by UN guidelines: https://www.un.org/dgacm/en/content/editorial-manual/numbers-dates-time
  • How to define date formats in PHP: https://www.w3schools.com/PHP/func_date_date_format.asp
• Font color (CSS Theme)
  • in some cases, content appears in black, instead of darkgrey
  • e.g. Field "Test Site" https://www.un-spider.org/advisory-support/recommended-practices/recommended-practice-agriculture-drought-monitoring
  • needs to be changed in CSS
  • task for Martin: collect pages where this occurs...
• Concept for Recovery Mechanisms page
  • similar to: https://un-spider.org/space-application/emergency-mechanisms
  • details follow...
• Concept for better categorization of Data Sources
  • https://un-spider.org/links-and-resources/data-sources
  • e.g. distinction between: Raw Data Sources, Services, Applications
  • create new taxonomy, enter values + translations, include as new field to "Data Sources"
    • "Create referenced entities if they don't already exist" unchecked!!
• Free tagging Taxonomy
  • Free tagging when creating news e.g., allow selection of more than 12 values
  • Taxonomy values in general need to be checked...
    • e.g. https://un-spider.org/category/tagging/regional-support-office is empty....

next meeting: Friday 9.12. 13:00

1. Insert a disclaimer in the homepage. We used to have one in the previous versions, but I did not see it two weeks ago when we were discussing this issue. The disclaimer helps us raise awareness regarding the fact that the Portal is only for information purposes, and that any maps do not represent the official view of the UN on boundaries or territories.   If you cannot find it, I will also look for the text.
2. At the bottom of the page we have the links to the Regional Support Offices. In the past the RSOs were presented in a “carrousel” mode so that you would see different RSOs.  Now we only see specific ones.   Would you be able to insert again that “carrousel” view to display the logos of all RSOs?
3. In the right margin of the UN-SPIDER Recommended Practices I would also kindly request that you create an explicit entry on Disclaimer.  This would be below the existing entries.  I just want to make sure that people are aware that results are only for information purposes, and the maps do not have any sort of validation in the field as they are calibrated with ground observations, and also the issue of borders.

• Database backups and rsync
  • task for Werner: set up to backup on other system
    • database is being backed up to other system
    • file directory not yet..
• Date Format
  • Date formats are used in varying different formats... wish to standardize
    • general configuration: https://www.un-spider.org/admin/config/regional/date-time
    • depending on the content type / view, can be changed in view or manage display (content type)
    • task for Martin: start unifying this, report to Werner if problems occur
    • Format as defined by UN guidelines: https://www.un.org/dgacm/en/content/editorial-manual/numbers-dates-time
    • How to define date formats in PHP: https://www.w3schools.com/PHP/func_date_date_format.asp
• Font color (CSS Theme)
  • in some cases, content appears in black, instead of darkgrey
  • e.g. Field "Test Site" https://www.un-spider.org/advisory-support/recommended-practices/recommended-practice-agriculture-drought-monitoring
  • needs to be changed in CSS
  • task for Martin: collect pages where this occurs and send it to Werner...
• Concept for Recovery Mechanisms page
  • similar to: https://un-spider.org/space-application/emergency-mechanisms
  • details follow...
  • task for Martin: define content that is supposed to go to the new page
  • task for Werner: define "more uptodate" concept
    • Change Emergency Mechanism page to this new concept
    • Create Recovery Mechanism page based on new concept
• Concept for better categorization of Data Sources
  • https://un-spider.org/links-and-resources/data-sources
  • e.g. distinction between: Raw Data Sources, Services, Applications
  • Task for Martin: define categorization values
    • create new taxonomy, enter values + translations, include as new field to "Data Sources"
      • "Create referenced entities if they don't already exist" unchecked!!
• Free tagging Taxonomy
  •  
  • Taxonomy values in general need to be checked...
    • e.g. https://un-spider.org/category/tagging/regional-support-office is empty....
    • Task for Werner: check what is wrong with the taxonomy value pages...
      • URL alias directing to non existing terms
• Insert a disclaimer in the homepage (landing page). We used to have one in the previous versions, but I did not see it two weeks ago when we were discussing this issue. The disclaimer helps us raise awareness regarding the fact that the Portal is only for information purposes, and that any maps do not represent the official view of the UN on boundaries or territories.   If you cannot find it, I will also look for the text.
  • never existed, however, can be implemented
  • Task for Martin: provide text and where it needs to go...
• Disclaimer for recommended practices has been implemented...
  • Task for Martin: see if this is needed for practical uses as well...
  • https://un-spider.org/advisory-support/practical-uses/Sendai-Framework-Ad-hoc-indicator-C-2Fo-Intro
• Q1: Interns as new users, how to handle?
  • Task for Martin: create users with role "interns", see if permissions are sufficient
  • specific role for translator...
    • introduction for translator intern needed, meeting with Werner
• Front page: separate pager news and events...
  • currently, both pagers are linked. If I change the page of news, page of events changes as well
  • Task for Werner: solve this issue
• Other Languages...
  • Task for Martin: check with Juan Carlos what other languages are planned, with which priorities and time frame

• Q2: Language artifacts...
  • Task for Martin: try to find these again
    • comment Martin: tried to find them, but didnt see them anymore... can probably be marked as solved, but I keep it here in case I suddenly find it again...

next meeting: Thu, 26.01.2023 15:00

for documentation, finished since last time:

• markdown translation to html for spanish site
  • Task for Werner:
    • https://www.un-spider.org/es/asesoria/practicas-recomendadas/practica-recomendada-mapeo-inundaciones/paso-a-paso
• In the right margin of the UN-SPIDER Recommended Practices I would also kindly request that you create an explicit entry on Disclaimer.  This would be below the existing entries.  I just want to make sure that people are aware that results are only for information purposes, and the maps do not have any sort of validation in the field as they are calibrated with ground observations, and also the issue of borders.
  1. implemented in recommended practices
• At the bottom of the page we have the links to the Regional Support Offices. In the past the RSOs were presented in a “carrousel” mode so that you would see different RSOs.  Now we only see specific ones.   Would you be able to insert again that “carrousel” view to display the logos of all RSOs?
• Free tagging when creating news e.g., allow selection of more than 12 values
  • Task for Werner: allow selection of more...

Issue (long term)

• Werner currently not able to access system, need support of Mateja (solved)
• We need an smtp server for un-spider, which allows redirect
  • currently running via Werners account
  • new account needs to be create for un-spider mail server, allowing mailing via website
  • ask Mateja...

New entries (10.02.2023)

• scheduled database backup did not run on 10.02.2023; ran successfully on 09.02.2023
  • even though cronjob was started, no backup file created
    • Werner checking
• Check Juan Carlos mails.... some request with security?

New entries (26.01.2023)

• Issue w/ creating user accounts
  • see mail from 23.01.2023
• New role needed
  • Intern w/ permissions to create translations
    • ... working with ICanLocalize Translator Rolle, configured by Werner
    • role was defined and set with needed permissions, but still problems with creating translations...
    • ... Werner found something - to be tested and confirmed...
      • "Create new entries" permission was not set, might be needed
      • "Edit any content"...
• Alter permissions for interns
  • so they can create drafts only for now (dont allow publishing)
  • ... but also being able to change that after 2-3 weeks
    • probably too much work for this use case, rather explain to interns, that they should not publish for now, but have content checked with Martin first
• Martin working on a script, looking for broken links to external websites
  • there is an issue with "circular redirects"
  • perhaps we can discuss this at some meeting?

Added in the meantime...

• 03.02.2023:
  • "Referenced RSO" issue with translations...
• 03.02.2023
  • Translator role did not work as planned... Nuria currently using site admin role
• 07.02.2023
  • Issue with translations: some fields cannot be edited and also dont exist in the form to create new content and edit existing content (I will show you what I mean with that in our next support meeting)
  • e.g. Mission Team for advisory missions:
    • https://www.un-spider.org/advisory-support/advisory-missions/nigeria-technical-advisory-mission
  • solution found, need to be checked for all: Conditional field issue, if more dependencies need to be set to "Or"

Open from last meeting (12.01.2023)

• Database backups and rsync
  • task for Werner: set up to backup on other system
    • database is being backed up to other system
    • file directory not yet..
• Date Format
  • Date formats are used in varying different formats... wish to standardize
    • general configuration: https://www.un-spider.org/admin/config/regional/date-time
    • depending on the content type / view, can be changed in view or manage display (content type)
    • task for Martin: start unifying this, report to Werner if problems occur
    • Format as defined by UN guidelines: https://www.un.org/dgacm/en/content/editorial-manual/numbers-dates-time
    • How to define date formats in PHP: https://www.w3schools.com/PHP/func_date_date_format.asp
• Font color (CSS Theme)
  • in some cases, content appears in black, instead of darkgrey
  • e.g. Field "Test Site" https://www.un-spider.org/advisory-support/recommended-practices/recommended-practice-agriculture-drought-monitoring
  • needs to be changed in CSS
  • task for Martin: collect pages where this occurs and send it to Werner...
• Concept for Recovery Mechanisms page
  • similar to: https://un-spider.org/space-application/emergency-mechanisms
  • details follow...
  • task for Martin: define content that is supposed to go to the new page
  • task for Werner: define "more uptodate" concept
    • Change Emergency Mechanism page to this new concept
    • Create Recovery Mechanism page based on new concept
• Concept for better categorization of Data Sources
  • https://un-spider.org/links-and-resources/data-sources
  • e.g. distinction between: Raw Data Sources, Services, Applications
  • Task for Martin: define categorization values
    • create new taxonomy, enter values + translations, include as new field to "Data Sources"
      • "Create referenced entities if they don't already exist" unchecked!!
• Free tagging Taxonomy
  • Taxonomy values in general need to be checked...
    • e.g. https://un-spider.org/category/tagging/regional-support-office is empty....
    • Task for Werner: check what is wrong with the taxonomy value pages...
      • URL alias directing to non existing terms
• Insert a disclaimer in the homepage (landing page). We used to have one in the previous versions, but I did not see it two weeks ago when we were discussing this issue. The disclaimer helps us raise awareness regarding the fact that the Portal is only for information purposes, and that any maps do not represent the official view of the UN on boundaries or territories.   If you cannot find it, I will also look for the text.
  • never existed, however, can be implemented
  • Task for Martin: provide text and where it needs to go...
• Disclaimer for recommended practices has been implemented...
  • Task for Martin: see if this is needed for practical uses as well...
  • https://un-spider.org/advisory-support/practical-uses/Sendai-Framework-Ad-hoc-indicator-C-2Fo-Intro
• Interns as new users, how to handle?
  • Task for Martin: create users with role "interns", see if permissions are sufficient
  • specific role for translator...
    • introduction for translator intern needed, meeting with Werner
• Front page: separate pager news and events...
  • currently, both pagers are linked. If I change the page of news, page of events changes as well
  • Task for Werner: solve this issue
• Other Languages...
  • Task for Martin: check with Juan Carlos what other languages are planned, with which priorities and time frame
  • currently no resources for this
  • if so, some day, Russian, Arabic...

Follow-ups

Next meeting:

• Fri, 10.02.2023 13:00

To be scheduled (depending on Werners availability):

• training for translations Werner w/ Nuria
  • to set up for next week (30.01.)
• working on broken links script Werner assisting Martin

Issue (long term)

• !!! We need a valid mailbox with user id and password for un-spider, which allows redirect
  • currently direct mails by php/spider website are block by firewall
    • currently running via Werners account
    • new account needs to be created for un-spider mail server, allowing mailing via website
    • ask Mateja to set this up / or needs to be set up by vienna / JCV (un address)
      • or we can use current existing unspider [at] un.org mail address...
      • https://un-spider.org/admin/config/system/smtp
  • server needs this to send out mails
• Work on search function...
  • need to work on the concept; Search API module is installed but not configured and used yet; Default Search module can be deinstalled as soon Search API is configured
  • View needs to be set up / index...
  • need to set up a dedicated meeting w/ Werner

New entries (14.09.2023)

• see JCV mails from 13.09.
  • OICT document
  • Publication prep
  • Spanish translations of headings and sub-headings

Open from previous meetings

• Concept for Early Warning publication integration into portal
  • publication by Juan Carlos to be integrated into the portal
  • Juan Carlos provided a layout idea visualization + example page(s)
  • idea is to have something similar to https://un-spider.org/links-and-resources/daotm
    • each chapter as a "tile"
    • chapters may have subchapters
  • will need to have blocks on the side bar for additional information / links
  • will need css adjustments...
• !!! Contact form fix
  • https://un-spider.org/about/contact
  • need a valid mail address
• Translation link behaviour...
  • In a view, when "Link to content" is used, this does not work for an image in a translated page
  • similar to https://www.drupal.org/project/drupal/issues/2802311
  • example: https://www.un-spider.org/es/aplicacion-espacial/mecanismos-de-emergencia
  • view: https://www.un-spider.org/admin/structure/views/view/guides_listing/edit/block_1
  • the link on the spanish page still redirects to english page
    • Solution attempt: create link url with "Rewrite results", using translation language and node id
    • however, using this would add a "en" to the english urls, which does not work
    • ... tried to solve this with Views Conditional (if translation language = en; do no use language code in url), however the "en" was still kept in the link urls...
  • ... currently no solution (Werner to check)
• How to remove navigation for certain recommended practices without breaking everything...
  • https://www.un-spider.org/advisory-support/recommended-practices/recommended-practice-flood-hazard-mapping
  • https://www.un-spider.org/advisory-support/recommended-practices/recommended-practice-radar-based-flood-mapping
  • first try: via "Outline" - "Remove from Book Outline", did not work
  • task for Werner: other option, via CSS disable book navigation for node types (by Werner)
    • recommended practices
    • recommended practices in detail
    • recommended practices step by step
• Juan Carlos mails requests with security
  • requirements by OICT
  • being dealt with by Werner w/ Mateja
    • Martin to check w/ Juan Carlos what is still required
• Date Format
  • Due to the change of date formats, some tables need to be redesigned (some columns need to be wider)
    • task for Werner: readjust tables as defined by Martin (see mail)
• Font color (CSS Theme)
  • in some cases, content appears in black, instead of darkgrey
  • e.g. Field "Test Site" https://www.un-spider.org/advisory-support/recommended-practices/recommended-practice-agriculture-drought-monitoring
  • needs to be changed in CSS
  • task for Martin: collect pages where this occurs and send it to Werner...
    • if others are found, inform Werner again
  • task for Werner: check and adjust for the cases that have been sent already (see mail)
• Concept for better categorization of Data Sources
  • https://un-spider.org/links-and-resources/data-sources
  • e.g. distinction between: Raw Data Sources, Services, Applications
  • Task for Martin: define categorization values
    • create new taxonomy, enter values + translations, include as new field to "Data Sources"
      • "Create referenced entities if they don't already exist" unchecked!!
• Insert a disclaimer in the homepage (landing page). We used to have one in the previous versions, but I did not see it two weeks ago when we were discussing this issue. The disclaimer helps us raise awareness regarding the fact that the Portal is only for information purposes, and that any maps do not represent the official view of the UN on boundaries or territories.   If you cannot find it, I will also look for the text.
  • never existed, however, can be implemented
  • Task for Martin: provide text and where it needs to go...
• Free tagging Taxonomy
  • Taxonomy values in general need to be checked...
    • e.g. https://un-spider.org/category/tagging/regional-support-office is empty....
      • bad example... there is no taxonomy regional support office
    • Task for Martin: check again what is happening here...
    • Task for Werner: check what is wrong with the taxonomy value pages...
      • URL alias directing to non existing terms
      • taxonomy term does not have content - empty page - "no result behaviour" needs to be adjusted
        • did not work first try, Werner will check
• "Referenced RSO" translations..
  • we know the cause of it now and need to monitor it, if translations exist for RSOs, these are also listed in the Referenced RSOs, as soon as the translations are finalised, we can consider to include a filter, to only have the RSOs in the right translation/language, that is currently being used
  • status: translations finished
  • needs to be handled via a view, setting to be changed in the field settings, reference method: view (change from default)
    • view needs to be created first - reference view, in view can be set to language, following interface
  • update of status: this is already fixed actually. Problem was that some RSO pages existed as individual entities, not as translations. Even though they were unpublished, they would still appear in the "Referenced RSO" list. After deletion of those, it is all fine.
  • Fixed!

Backlog (not working on this at the moment, but for future task planning purposes)

• Question: If we wanted to implement a calendar like: https://www.space4water.org/events how would this work?
  • need a module to be installed and a view needs to be created + css to polish...

Tasks with no solutions at the moment (here for documentation purposes)

• New role needed
  • Intern w/ permissions to create translations
    • ... working with ICanLocalize Translator role, configured by Werner
    • role was defined and set with needed permissions, but still problems with creating translations... Translator role did not work as planned... Nuria currently using site admin role
    • not solved... translators will need to be site admins for now

Solved since last meeting

Follow-ups

Next meeting:

26 October 2023

To be scheduled (depending on Werner's and Martin's availability):

• working on broken links script Werner assisting Martin
  • ... also check potential usage of tools for this, instead of creating script
• dedicated meeting w/ Werner about search function
• perhaps specific meeting for JCV publication...

Issue (long term)

• !!! Toward end of the year 2023, need to migrate to Drupal 10
  • needs preparation and is major work
  • Drupal 9 security support will stop Nov 2023
• !!! We need a valid mailbox with user id and password for un-spider, which allows redirect
  • was running via Werners account, currently no mail server connected to KP, to the outside
  • new account needs to be created for un-spider mail server, allowing mailing via website
  • ask Mateja if he can set this up / or needs to be set up by Vienna / JCV (un address) / or any external mail server provider (connected to cost)
    • referring to Juan Carlos, we cannot use current existing unspider [at] un.org mail address...(handled in Vienna, JCV does not even have the password)
    • https://un-spider.org/admin/config/system/smtp
  • server needs this to send out mails
• Work on search function...
  • need to work on the concept; Search API module is installed but not configured and used yet; Default Search module can be deinstalled as soon Search API is configured
  • View needs to be set up / index...
  • need to set up a dedicated meeting w/ Werner

New entries (26.10.2023)

• How to completely delete files from the KP?
  • see mail from Fri 20 Oct...
  • need to be accessed via ftp
  • server needs to be accessed with login via shell or ftp 192.168.10.8
    • no account for Martin yet...
• We might need to unpublish (unpublishing wont do the trick, as the files are stored in a public file system and, as soon as you have the link to the specific file, you can always access it, no matter published or unpublished) all presentations (ppt and pdf) that we uploaded for events...
  • needs to be handled like to before mentioned...

Open from previous meetings

• Concept for Early Warning publication integration into portal
  • publication by Juan Carlos to be integrated into the portal
  • Juan Carlos provided a layout idea visualization + example page(s)
  • idea is to have something similar to https://un-spider.org/links-and-resources/daotm
    • each chapter as a "tile"
    • chapters may have subchapters
  • will need to have blocks on the side bar for additional information / links
  • will need css adjustments...
  • taks for Martin: provide more specs...
• !!! Contact form fix
  • https://un-spider.org/about/contact
  • need a valid mail address
• Translation link behaviour...
  • In a view, when "Link to content" is used, this does not work for an image in a translated page
  • similar to https://www.drupal.org/project/drupal/issues/2802311
  • example: https://www.un-spider.org/es/aplicacion-espacial/mecanismos-de-emergencia
  • view: https://www.un-spider.org/admin/structure/views/view/guides_listing/edit/block_1
  • the link on the spanish page still redirects to english page
    • Solution attempt: create link url with "Rewrite results", using translation language and node id
    • however, using this would add a "en" to the english urls, which does not work
    • ... tried to solve this with Views Conditional (if translation language = en; do no use language code in url), however the "en" was still kept in the link urls...
  • ... currently no solution (Werner to check)
• How to remove navigation for certain recommended practices without breaking everything...
  • https://www.un-spider.org/advisory-support/recommended-practices/recommended-practice-radar-based-flood-mapping
  • first try: via "Outline" - "Remove from Book Outline", did not work
  • task for Werner: other option, via CSS disable book navigation for node types (by Werner)
    • recommended practices
    • recommended practices in detail
    • recommended practices step by step
• Juan Carlos mails requests with security
  • requirements by OICT
  • being dealt with by Werner w/ Mateja
    • Martin to check w/ Juan Carlos what is still required
• Date Format
  • Due to the change of date formats, some tables need to be redesigned (some columns need to be wider)
    • task for Werner: readjust tables as defined by Martin (see mail)
• Font color (CSS Theme)
  • in some cases, content appears in black, instead of darkgrey
  • e.g. Field "Test Site" https://www.un-spider.org/advisory-support/recommended-practices/recommended-practice-agriculture-drought-monitoring
  • needs to be changed in CSS
  • task for Martin: collect pages where this occurs and send it to Werner...
    • if others are found, inform Werner again
  • task for Werner: check and adjust for the cases that have been sent already (see mail)
• Concept for better categorization of Data Sources
  • https://un-spider.org/links-and-resources/data-sources
  • e.g. distinction between: Raw Data Sources, Services, Applications
  • Task for Martin: define categorization values
    • create new taxonomy, enter values + translations, include as new field to "Data Sources"
      • "Create referenced entities if they don't already exist" unchecked!!
• Insert a disclaimer in the homepage (landing page). We used to have one in the previous versions, but I did not see it two weeks ago when we were discussing this issue. The disclaimer helps us raise awareness regarding the fact that the Portal is only for information purposes, and that any maps do not represent the official view of the UN on boundaries or territories.   If you cannot find it, I will also look for the text.
  • never existed, however, can be implemented
  • Task for Martin: provide text and where it needs to go...
• Free tagging Taxonomy
  • Taxonomy values in general need to be checked...
    • e.g. https://un-spider.org/category/tagging/regional-support-office is empty....
      • bad example... there is no taxonomy regional support office
    • Task for Martin: check again what is happening here...
    • Task for Werner: check what is wrong with the taxonomy value pages...
      • URL alias directing to non existing terms
      • taxonomy term does not have content - empty page - "no result behaviour" needs to be adjusted
        • did not work first try, Werner will check

Backlog (not working on this at the moment, but for future task planning purposes)

• Question: If we wanted to implement a calendar like: https://www.space4water.org/events how would this work?
  • need a module to be installed and a view needs to be created + css to polish...

Tasks with no solutions at the moment (here for documentation purposes)

• New role needed
  • Intern w/ permissions to create translations
    • ... working with ICanLocalize Translator role, configured by Werner
    • role was defined and set with needed permissions, but still problems with creating translations... Translator role did not work as planned... Nuria currently using site admin role
    • not solved... translators will need to be site admins for now

Solved since last meeting

• "Referenced RSO" translations..
  • we know the cause of it now and need to monitor it, if translations exist for RSOs, these are also listed in the Referenced RSOs, as soon as the translations are finalised, we can consider to include a filter, to only have the RSOs in the right translation/language, that is currently being used
  • status: translations finished
  • needs to be handled via a view, setting to be changed in the field settings, reference method: view (change from default)
    • view needs to be created first - reference view, in view can be set to language, following interface
  • update of status: this is already fixed actually. Problem was that some RSO pages existed as individual entities, not as translations. Even though they were unpublished, they would still appear in the "Referenced RSO" list. After deletion of those, it is all fine.
  • Fixed!
• Spanish version, field names and headings...
  • should be all solved now, based on what Nuria provided
  • ... except for the rec practice buttons and one error that I have mentioned already (need to document further here)

Follow-ups

Next meeting:

... last week of November? (wait for JCV commenting on Werners contract situation)

To be scheduled (depending on Werner's and Martin's availability):

• working on broken links script Werner assisting Martin
  • ... also check potential usage of tools for this, instead of creating script
• dedicated meeting w/ Werner about search function
• perhaps specific meeting for JCV publication...