<?php $queryBuilder = $this->entityManager->createQueryBuilder()
->select('mbt')
->from('Bundle:MyBaseType', 'mbt');
$queryBuilder->where('mbt INSTANCE OF Bundle:SomeType');
HTTPDUSER=`ps axo user,comm | grep -E '[a]pache|[h]ttpd|[_]www|[w]ww-data|[n]ginx' | grep -v root | head -1 | cut -d\ -f1`
sudo setfacl -R -m u:"$HTTPDUSER":rwX -m u:`whoami`:rwX /path/to/source/images/dir
sudo setfacl -dR -m u:"$HTTPDUSER":rwX -m u:`whoami`:rwX /path/to/source/images/dir
[mysqld]
general_log_file = /var/log/mysql/general_mysql.log
general_log = on
Restart your MySQL server (e.g. by executing "sudo service mysql restart" on Ubuntu Linux systems). Now you can follow all new queries as they are executed by this command:
tail -f /var/log/mysql/general_mysql.log
You can leave this program in command line by pressing CTRL+C.
For disabling, just set "general_log" to "off" or comment the out the previous lines in /etc/mysql/my.cnf by writing the # character at the beginng of the lines, save and restart the MySQL server again.
Recently the approach from above was not possible on my MariaDB server in Linux Mint 18.1. The log file was just not written. Even if I have created it. Then I could enable the general_log by variable. For this login into your MariaDB/MySQL server via command line. Then enable the general_log:
SET GLOBAL general_log = On;
Check all your variables which have something to do with "log" by this command:
show variables like '%log%';
The filename of the general_log is stored in that variable: "general_log_file". The default general log folder on Ubuntu/Debian based Linux systems (like Linux Mint) is:
/var/lib/mysql
The "disk free" program shows the free space on a storage device via command line.
The "disk usage" program shows the used, not free, space on a storage device via command line.
Login to your MySQL server via command line. Then execute the following statement:
SHOW ENGINE INNODB STATUS;
You will get a error message like:
Foreign key constraint fails for table `my-table`.`JobExchange`:
,
CONSTRAINT `FK_42760B1EE7A1254A` FOREIGN KEY (`contact_id`) REFERENCES `contact` (`id`) ON DELETE SET NULL
Trying to add to index IDX_42760B1EE7A1254A tuple:
DATA TUPLE: 2 fields;
0: len 4; hex 80000001; asc ;;
1: len 4; hex 8000000d; asc ;;But the parent table `my-table`.`contact`
or its .ibd file does not currently exist!
This shows you, that MySQL cannot find the corresponding database table. This can be due to lowercase-uppercase mismatch of the table names. Check your MySQL server settings:
show variables like 'lower%';
This will show something like this:
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
+------------------------+-------+
2 rows in set (0,01 sec)
mysql> SELECT
-> TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
-> FROM
-> INFORMATION_SCHEMA.KEY_COLUMN_USAGE
-> WHERE
-> REFERENCED_TABLE_SCHEMA = 'my-table' AND
-> REFERENCED_TABLE_NAME = 'JobExchange';
+-----------------------------------+----------------+---------------------+-----------------------+------------------------+
| TABLE_NAME | COLUMN_NAME | CONSTRAINT_NAME | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME |
+-----------------------------------+----------------+---------------------+-----------------------+------------------------+
| JobExchangePdf | jobexchange_id | FK_7A971E966193B1C5 | jobexchange | id |
| jobexchange_jobemploymentcategory | jobexchange_id | FK_F5E32C9C6193B1C5 | jobexchange | id |
+-----------------------------------+----------------+---------------------+-----------------------+------------------------+
2 rows in set (3,59 sec)
MySQL Workbench shows the lower-case named table names correctly. PhpStorm does not. PhpStorm is guessing the right table name.
Drop the foreign key constraint and create a new one. F.e. with MySQL Workbench. You can drop the foreign key with the following command:
ALTER TABLE `my-table`.`JobExchange`
DROP FOREIGN KEY `FK_42760B1E6C7B4691`;
ALTER TABLE `my-table`.`JobExchange`
DROP INDEX `IDX_42760B1E6C7B4691` ;
The foreign key will be added like by this command:
ALTER TABLE JobExchange ADD CONSTRAINT FK_42760B1E6C7B4691 FOREIGN KEY (jobtype_id) REFERENCES JobExchangeCategory (id) ON DELETE SET NULL;
CREATE INDEX IDX_42760B1E6C7B4691 ON JobExchange (jobtype_id);
curl -sL https://deb.nodesource.com/setup_6.x | sudo -E bash -
curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | sudo apt-key add -
echo "deb https://dl.yarnpkg.com/debian/ stable main" | sudo tee /etc/apt/sources.list.d/yarn.list
sudo apt-get update && sudo apt-get install -y yarn nodejs
sudo npm install --global gulp-cli
Login into your database via command line (mysql -uuser -ppassword) and type the following commands.
use mytable;
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE table1;
SET FOREIGN_KEY_CHECKS = 1;
The following article is valid for unix based systems like Ubuntu Linux. It teaches you, how to setup your PhpStorm IDE to debug your unit tests via the Xdebug PHP extension in Drupal 8.
For the PhpStorm config you need to make sure to have the phpunit.xml file created by copying the ~/PhpstormProjects/drupal-8.x/core/phpunit.xml.dist into the same directory. Afterwards you must set the environment variables for
in your newly created phpunit.xml file.
Make sure you have configured:
The config window must look according to the following screenshot (be careful about the paths on your system):
Set exactly the same value, which you have previously set in your phpunit.xml file inside the PHP_IDE_CONFIG environment variable for your server. You must also map the directory where your tests are. Do your settings according to the screenshot below.
Set the path to the PHP interpreter which is running your command line based scripts. It is usually located at /usr/bin/php. The config must look like in the following screenshots.
For being able to execute your test quickly, open the PHP file with your test and hit the debug icon.
Chances are, that PhpStorm will output a error message like
Remote file path '/home/your-user/PhpstormProjects/drupal-8.4.x-dev/-' is not mapped to any file path in project.
You can ignore this error and just click the "resum program" button. PhpStorm will reveal the PHP interpreter on your breakpoint quickly. If you know, how the reason for this message can be solved - please put me a hint in the comments. However you could create a file with the name "-" and map to this file in the path settings, but this is not a real fix.
Once I was searching for a method to trigger my HTML markup, after I have changed it via an AJAX request. I could not find any non-irritating solution. So I have implemented a "common" cheap solution for this, which was documented at many places in the web (like Stackoverflow threads with many votes on a post). In the old approach, I have loaded JavaScript, which was placed within the fetched HTML markup. This resulted in an ugly structure. Because my HTML and JavaScript was mixed and not entirely separated in files.
Here is an example code with the better solution, which works by separated files:
var initFilterInput = function(el) {
el.find('form input').click(function(event) {
el.load('/reduced-filters', function() {
console.log( "Load was performed." );
initFilterInput(el);
});
});
};
initFilterInput($('.filter-group'));
In this example I initialize an event listener on a HTML element, which is located by the "filter-group" CSS class. This happens after the entire page load. After the click event is triggered, some HTML markup will be replaced in the current HTML DOM tree. Then this function will call itself by
initFilterInput(el);
and the event triggering still works on the new HTML markup.
Firstly install Docker via this article: https://docs.docker.com/engine/installation/linux/ubuntulinux/. Mind to setup the user and group permissions according to the article. So that you are able to start Docker as non-root user.
Make sure that a group with the name "docker" exists and your user is a member of that group. To add a user to an existing group, execute the following command:
sudo usermod -a -G groupName userName
After your user (mine f.e. is "peter") is being successfully added into the "docker" group, logout and login to ensure that you are acting from the docker user group.
Dowload the Kitematic GUI for Docker Debian package via https://github.com/docker/kitematic/releases. This program will empower you, to manage your Docker containers easily via a graphical user interface. Mind that this application is currently beta. Then install it by
sudo dpkg -i dist/Kitematic_0.12.9_amd64.deb
Follow the following steps in Kitematic:
To be able to execute easily queries within Elasticsearch, check status etc., you can install Jettro (https://github.com/jettro/elasticsearch-gui). Just execute the following command inside your Elasticsearch Docker container to install the Elasticsearch plugin:
bin/plugin install jettro/elasticsearch-gui
An official tutorial about this can be found here: https://docs.docker.com/engine/admin/host_integration/. In particular, you can follow the steps below.
Create a file at
/etc/systemd/system/docker-elasticsearch.service
with the following content:
[Unit]
Description=Elasticsearch container
Requires=docker.service
After=docker.service
[Service]
Restart=always
ExecStart=/usr/bin/docker start -a elasticsearch
ExecStop=/usr/bin/docker stop -t 2 elasticsearch
[Install]
WantedBy=default.target
Now reload the daemon:
sudo systemctl daemon-reload
Start the Elasticsearch Docker container as a service:
sudo systemctl start docker-elasticsearch.service
Enable the service at system startup:
sudo systemctl enable docker-elasticsearch.service
Voilà! Happy search index querying. (: