Monthly Archives: July 2016

Your PHP installation appears to be missing the MySQL extension which is required by WordPress.

This new server with Ubuntu 16.04 LTS cames with PHP 7.0.

The backup that I have from my client has some old WordPress blogs…

Your PHP installation appears to be missing the MySQL extension which is required by WordPress.

I need to downgrade PHP 7.0 to PHP 5.6, at least for now.

Before you procede with the tutorial on the following link, and if you are running a new Ubuntu 16 installation you might get upon the following error while following the tutorial.

root@sd-4XXXX:/home/httpd/html# sudo add-apt-repository ppa:ondrej/php
sudo: add-apt-repository: command not found

To install add-apt-repository you will need to run the following command

sudo apt-get install software-properties-common

Now the solution  How can I downgrade from PHP 7 to PHP 5.6 on Ubuntu 16.04? [duplicate].

 

[email protected] Feb 2008 – mixed by Gareth Noyce  

Found this smooth and nice set @ youtube while I was looking for  Water – Marlow and Claudia Nehls  (Daniel Stefanik Remix).

Thugfucker Blatant Promotion (Guy Gerber and Hadas Reshuffle)
Tube and Berger Funky Shit (Gui Boratto remix)
Sholmi Aber Moods (Valentino Kanzyani Remix)
DJ Tocadisco Better Begin (Gui Boratto remix)
Gel Abril Very Wrong (Chaim Remix)
Kolombo Model (Robert Babicz Remix)
Marlow and Claudia Nehls Water (Daniel Stefanik Remix) – 32min +-
Slam We’re Not Here (Christian Fischer Remix)
Pig and Dan Imagine
Pig and Dan Sly Detector

Ubuntu 16.04 LTS tutorials

How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu 16.04
https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-16-04

How to secure an Ubuntu 16.04 LTS server

https://www.thefanclub.co.za/how-to/how-secure-ubuntu-1604-lts-server-part-1-basics

The Perfect Server – Ubuntu 16.04 (Xenial Xerus) with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig 3.1

https://www.howtoforge.com/tutorial/perfect-server-ubuntu-16.04-with-apache-php-myqsl-pureftpd-bind-postfix-doveot-and-ispconfig/

How To Protect WordPress with Fail2Ban on Ubuntu 14.04

https://www.digitalocean.com/community/tutorials/how-to-protect-wordpress-with-fail2ban-on-ubuntu-14-04

UFW Essentials: Common Firewall Rules and Commands

https://www.digitalocean.com/community/tutorials/ufw-essentials-common-firewall-rules-and-commands

Other readings…

Potential ufw and fail2ban conflicts

http://askubuntu.com/questions/54771/potential-ufw-and-fail2ban-conflicts

 

dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

 

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘johnny.category.categoryId’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

 

Let run the following command in mysql…
it worked for me on mysql  Ver 14.14 Distrib 5.7.12, for Linux (x86_64) 

set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';