Drupal 8 - Migrate from public to private files

eduardo
21 Sep 2020

# Enable maintanance mode
drush state-set system.maintenance_mode 1

# Backup file field data
drush sql-query "CREATE TABLE media__field_file_bak AS SELECT * FROM media__field_file;"
drush sql-query "CREATE TABLE media_revision__field_file_bak AS SELECT * FROM media_revision__field_file;"

# Truncate file field tables (need to change storage settings)
drush sql-query "TRUNCATE media__field_file;"
drush sql-query "TRUNCATE media_revision__field_file;"

visualizar todos os nós criados por um utilizador no drupal

eduardo
3 Oct 2019

Create a Page view which shows content.
Select the fields you want to see for the node like nid, title, author, etc.
Add Author as a filter and expose this field so that you can provide user id or username via the exposed filter form.
Save the view.
The page view should now work on the URL you provided in step 1. Here once you provide a username or user id (depending on which field you exposed) the content should get filtered.
Add a module like views_data_export, which allows you to export the list in a file.

Unable to install GeSHi Filter, geshifilter.settings already exists in active configuration

eduardo
1 Oct 2019

num contentor com o drupal depois de instalar e reinstalar o módulo com o composer surgiu o seguinte erro:

Unable to install GeSHi Filter, geshifilter.settings already exists in active configuration.

para resolver o problema bastaria remover as configurações do módulo com:
drush config-delete geshifilter.settings

como o drupal está a correr numa stack com o docker (drupal4docker) utilizaremos, dentro da pasta onde está definida a stack:
make drush config-delete geshifilter.settings

nginx mariadb php drupal8

eduardo
11 May 2018

apt update && apt upgrade
apt install nginx
apt install mariadb-server mariadb-client
mysql_secure_installation
apt install php-fpm php-common php-mbstring php-xmlrpc php-soap php-gd php-xml php-intl php-mysql php-cli php-zip php-curl

https://websiteforstudents.com/installing-nginx-mariadb-on-ubuntu-16-04-17-10-18-04-with-php-7-2-support-lemp/

Subscrever drupal 8