March 2019 – Web Hosting Solution

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

March 29, 2019March 29, 2019Leave a Comment

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 […]

Installing Engintron for the first time

March 18, 2019March 18, 2019Leave a Comment

Installation is a process that lasts only a few minutes. You’ll need root SSH access to your cPanel server. Also check the current requirements (listed lower). If everything is ok, log in as root and type the following commands, one at a time: Or in one quick command to paste in the terminal: The process will […]

change Apache Port Number on a cPanel Server

March 18, 2019March 18, 2019Leave a Comment

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’. […]

Mysql Consume High Server resource Then Optimization of MySQL settings

March 17, 2019March 17, 2019Leave a Comment

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 […]

How to Install Cpanel Older version in centos 7

March 16, 2019March 16, 2019Leave a Comment

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 […]

Importing a Database via SSH

March 4, 2019March 4, 2019Leave a Comment

Make sure you have your database created and a user attached to it. Please remember to copy or write down the information as you will need it in step 5. Upload your SQL file to the server by either using the File Manager or a FTP Client. It does not matter where you upload it, just remember its location as you will […]

What is MultiPHP Manager in latest Cpanel by Ryan Burke

March 4, 2019March 4, 2019Leave a Comment

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 […]

Check and Repair a Corrupted MySQL Database Table Using SSH?

March 4, 2019March 4, 2019Leave a Comment

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 […]