I hope you take something away...

If you do please leave something for me :)

MySQL screwed up after brew upgrade

I ran 

brew upgrade

It updated my mysql installation to  8.0.12. Previously I was working with 5.7.22. Now each time I start mysql using the following commands

mysql.server start


brew services mysql restsrt 

MySQL does not start properly

 Most probably the error you will face is 

.. ERROR! The server quit without updating PID file


When I run 

Add a NOT IN condition and a nested query to your views WHERE condition


I needed to add a NOT IN condition with a nested query for the WHERE condition. The usual method wont work


$view->query->where[1]['conditions'][] = array(
            ['field'] => 'groups_group_membership.type'
            ['value'] => array
                    [0] => 'SELECT_QUERY_HERE'

            ['operator'] => IN


The way that works