Vesta CP common bug fix after installation on your VPS or Dedicated Server, Yea there is few common bugs in the Vesta CP , last few time I faced those issue with many of my VPS. So I think this article will help you to fix the issues may comes after Vesta CP installation.

Vesta panel phpMyadmin issue with mysql tables queries , I recently installed Vesta CP on a VPS server after configuring the apache , MySQL. While I check with database tables in phpMyadmin I’m unable to view the data of the MySQL tables. It shows some error like

i got error #1142 - SELECT command denied to user 'user'@'localhost' for table 'pma_table_uiprefs'
on root #1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist

basically some issue with MySQL storage  and extended features. due to this issue I’m unable to host the website , In my code every where SQL queries are getting this error.

So I check it in details and figure out the issue  is related to above error, and the solution is just run the following code as a sudo user.

I’m working on Debian 8. Jessie ,what ever Os is you’re using execute the corresponding code.

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma.sh && chmod +x pma.sh && ./pma.sh

or

sudo wget --no-check-certificate https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma.sh && chmod +x pma.sh && ./pma.sh

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-ubuntu.sh && chmod +x pma-ubuntu.sh && ./pma-ubuntu.sh

or

sudo wget --no-check-certificate https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-ubuntu.sh && chmod +x pma-ubuntu.sh && ./pma-ubuntu.sh

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-debian.sh && chmod +x pma-debian.sh && ./pma-debian.sh

or

wget --no-check-certificate https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-debian.sh && chmod +x pma-debian.sh && ./pma-debian.sh

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-centos.sh && chmod +x pma-centos.sh && ./pma-centos.sh

or

wget --no-check-certificate https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-centos.sh && chmod +x pma-centos.sh && ./pma-centos.sh

This will help me to solve the Vesta CP phpMyadmin table access issue in VPS. I found this article from vesta forum I think this will get some one to fix their Vesta CP issue related with phpMyadmin tables. there are few other issue I faced with Vesta CP like.

I’m working with Debian 8, its Virtual host are keeping in site-available folder and site-enables folder by default. But after installing the Vesta CP this configurations are overrides and it not taking from there. So I figure out Vesta CP virtual host configurations are from different locations. this is also one of major Vesta CP common bug fix after installation for someone needs virtual host customization for Laravel/Symphony kind of applications.

In Vesta CP the virtual host file locations as follows.

/home/{user}/conf/web/apache2.conf

There you can add your additional customization to the virtual host. In my case I’m working with Laravel so its symlink creation I just alter with virtual host file.

Yea its another issue I found with Vesta cp ,when I try to send an email from round cube , the send button not working well. I search a lot for this issue and figure out how to solve the issue. this is also one of major Vesta CP common bug fix after installation.

1. download the round cube full package from here
2. Extract the folder in your local machine and find the folder named tinymce.
3. folder location is at \roundcubemail-1.1.1\program\js\tinymce\
4. SCP this folder to your server with corresponding path.
5. replace xxx.xxx.xxx.xxx with your server IP address.

scp -r tinymce/* xxx.xxx.xxx.xxx:/usr/share/roundcube/program/js/tinymce/.

Vesta CP common bug fix after installation is really important and very helpfull for some one looking for open source free Control panel. I hope you guys will found the article useful for fixing your Vesta CP common issues after installation on your server.

Happy reading 🙂 🙂 🙂