Category: VestaCP

Change WordPress URL through functions.php file

Changing the WordPress URL can be done by editing the functions.php located in the theme folder, in most of the webservers the location will be as below /home/site/public_html/wp-content/themes/mytheme/functions.php Once you open the functions.php files add the below lines (replace the URL with the new one) immediately after <?php   update_option( ‘siteurl’, ‘’ ); update_option( ‘home’, […]

Convert Existing MySQL Database to Innodb

  Converting existing MySQL Database Tables from MyISAM to InnoDB can be done from PHPMyAdmin but if there are too many tables the following script will help you to convert all the tables of a particular database to InnoDB Pre-requisites: 1. This tutorial assumes that you have .my.cnf configured with MySQL credentials for auto-login 2. […]

Install PEAR/PHP Mail function

  PHP Mail function should be installed on your server if you want to send emails from your code, to install 1. Install Pear package (if it is not already installed) by running Debian/Ubuntu: apt-get install php-pear Redhat/CentOS: yum install php-pear 2. Once the pear installation is complete or if you have PEAR already installed, […]

Error: “An error occured” in Joomla admin section

  After installing the latest version of Joomla you may sometimes notice the below error in the “admin” section. Error An error occured Screenshot:   Fix: This happens because of the incorrect/low MySQL “sort_buffer_size”, to fix this edit the “my.cnf” file vi /etc/my.cnf Add the below line to the end of the file sort_buffer_size = […] © 2016