Welcome to my blog, hope you enjoy reading
RSS

Tuesday 31 December 2013

HAPPY NEW YEAR


Share

Wednesday 11 December 2013

Get row with max(column) in mysql

Get row with max(column) in mysql


problem:
my table is:

user col1 col2 col3
1    1    2    3
1    3    4    5
2    2    3    1
3    1    1    3
3    2    4    6
4    5    1    5
So if I run
Share

Friday 6 December 2013

# 1146 – Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist

# 1146 – Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist 


phpmyadmin reported the following error

“# 1146 – Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist“

Modify the configuration file config.inc.php phpmyadmin

$ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs’;

Changed to: $ cfg ['Servers'] [$ i] ['pma__table_uiprefs'] = ‘pma__table_uiprefs’;

Restart apache, web page log to re-enter, problem solving


Share

Install Skype in Ubuntu 13.04/12.10/12.04/11.10/Linux Mint

Install Skype in Ubuntu 13.04/12.10/12.04/11.10/Linux Mint

Recommended Method (This will install 32bit skype 4.1 without any problem)
To install skype in Ubuntu/Linux Mint open Terminal (Press Ctrl+Alt+T) and copy the following commands in the Terminal:
>> For 32Bit
Terminal Commands:
#wget -O skype-NoobsLab.deb http://download.skype.com/linux/skype-ubuntu-lucid_4.2.0.11-1_i386.deb
#sudo dpkg -i skype-NoobsLab.deb
#sudo apt-get -f install;rm skype-NoobsLab.deb

Share