I hope you take something away...

If you do please leave something for me :)

MySQL screwed up after brew upgrade

PROBLEM
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

OR

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

SOLUTION 

When I run 

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

PROBLEM: 

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
        );

SOLUTION :

The way that works