How to resolve “ORDER BY clause is not in SELECT list” caused MySQL 5.7 with SELECT DISTINCT and ORDER BY

If you have control of the server and you are running legacy code you can’t easily change, you can adjust the SQL mode of the server and remove “only_full_group_by” either for the duration of boot, by running the query SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,’ONLY_FULL_GROUP_BY’,”));’ or by adding sql_mode=” to your my.cnf file. Obviously its better to change your code if […]

Continue Reading

change Apache Port Number on a cPanel Server

Apache is a widely-used web server that is distributed under “open source” license. By default, Apache uses port 80 and secure port 443. You can change the port through WHM or from the cli. Follow the below Steps to change Apache port number through WHM. 1) Login to WHM through https://yourserverIP:2087 2) Go to ‘Tweak Settings’. […]

Continue Reading

Mysql Consume High Server resource Then Optimization of MySQL settings

Why does MySQL consume high memory? Application software like Python, PHP, JAVA threads utilize more memory when configured improperly or un-optimized queries, complex coding, etc. Due to improper configuration of MySQL, it leads to inefficient memory or wastage of memory. If the memory is lower than, required by the processes on the server. Resolutions to […]

Continue Reading

How to Install Cpanel Older version in centos 7

if you want to install a cpanel older version v72.0.12, or other version as you wish in fresh centos 7. then follow the instruction below In /etc/cpupdate.conf add the following, start the installation. Code: CPANEL=72.0.12 RPMUP=daily SARULESUP=daily STAGING_DIR=/usr/local/cpanel UPDATES=daily But we suggest use latest version of cpanel in your server some scripts or php function […]

Continue Reading

What is MultiPHP Manager in latest Cpanel by Ryan Burke

Multiphp Manager is one of the major improvements introduced by Cpanel team with Easy Apache 4. In order to use MultiPHP Manager you will need to upgrade the Easy Apache version to 4. The MultiPHP manager allows users and administrators to select the server default and per-domain default PHP versions. So though you have running […]

Continue Reading

Check and Repair a Corrupted MySQL Database Table Using SSH?

Please refer the following steps: a)     Login to your MySQL server using Secure Shell (SSH). b)     Enter the following command at root prompt: mysqlcheck -r [database name] Where, mysqlcheck is the command to check the database, -r is the command to repair the corrupted tables. Replace the [database name] with your actual database name. Please note that MyISAM is a default storage engine […]

Continue Reading

accidentally deleted /var/log/apache2 and now can’t restart apache

This happen when you deleted tmp files and /var//log* files then this types of error as apache not rebuild , service httpd restart error or modsecurity failed to open the audit log file /etc/apache2/logs/modsec_audit.log or Login with ssh, then try: Code: sudo mkdir /var/log/apache2/ sudo touch /var/log/apache2/ {access,error,other_vhosts_access,suexec}.log sudo chown -R root:adm /var/log/apache2/ sudo chmod […]

Continue Reading