Unable to correct problems, you have held broken packages

I face this problem while installing the openshot in linux 12.04

and for me installing it with aptitude works

sudo aptitude install openshot

generally if you face this problem you can install the package like this 

sudo aptitude install <packagename> 

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 .

Installing SqLite on Windows 7 Error ( Could not load file or assembly 'System.Data.SQLite,)

I got this error while installing SQLite on windows 7

Could not load file or assembly 'System.Data.SQLite, Version=1.0.80.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. An attempt was made to load a program with an incorrect format.

Solution :

Project -> <project_name>_properties -> Build -> Platform target (Change it from Any PC to x86)

This solve the issue