Installing Linphone 3.6.1

Easiest way to install linphone 3.6.1 for linux is to download the debian from this link

http://packages.debian.org/sid/i386/linphone/download

and add ( deb http://ftp.de.debian.org/debian sid main) at the end of file source.list

vim /etc/apt/sources.list

deb http://ftp.de.debian.org/debian sid main

connection information ftp on localhost wordpress

Hi

When i try to upload the theme in wordpress it shows me message for entering data for ftp on my localhost .

Solution
Go to the wordpress directory in your localhost

and run this command

sudo chown -R www-data:www-data *

Easy content type showing ???????

I was working on wordpress i did update in plugin and later easy content type showing labels as '???' rather than showing it arabic .

So i deactivate the plugin and delete it , and reinstall it . It fix the problem

arabic text showing question marks

I face this problem while showing the arabic text from the database . The quickest solution i found is that i run this after connecting to the database

mysql_query("SET NAMES utf8");

Find Missing Sequence in mysql

Although this solution is for small numbers .

Sometime it happens that some sequence number miss and you need to find out the missing sequence to do that  first create a table with name of sequence and with one column name id and insert the numbers in my case i have number from 1-25 .

So now i have one table with name sequence which has column id and value 1-25 .

Now to find missing number of other table use this query  ;

select id from sequence where id not in (select id from other_table) ;

Thats it .