Codeigniter flv,wmv uploading gives error “Invalid file type”

It gives “The filetype you are attempting to upload is not allowed.” error when I was trying to upload flv and wmv files using codeigiter “upload” library.

I was sure about $config array. But this error was there when I was trying video upload.

My $config settings were as follows.

//CodeIgniter Code

$configVideo['upload_path'] = './upload/video';
$configVideo['max_size'] = '10240';
$configVideo['allowed_types'] = 'avi|flv|wmv|mp3';
$configVideo['overwrite'] = FALSE;
$configVideo['remove_spaces'] = TRUE;
$video_name = $_FILES['video']['name'];

Solution:  

Open mimes.php file in config folder 

Add folowing two lines into the $mimes array

'wmv'=>array('video/wmv', 'video/x-ms-wmv', 'flv-application/octet-stream', 'application/octet-stream'),
 'flv' =>array('video/flv', 'video/x-flv', 'flv-application/octet-stream', 'application/octet-stream'),
Hope this will help you out..
Thanks for visiting my blog.. 

Php mysql collation change script for tables and fields

<?php

$host = 'localhost';
$username = 'root';
$password = '';
$dbname = 'dbname';

$db = mysql_connect($host, $username, $password);
  mysql_select_db($dbname);

$mysqldatabase = 'dbname';
$collation = 'CHARACTER SET utf8 COLLATE utf8_general_ci';

echo '<div>';
mysql_query("ALTER DATABASE $mysqldatabase $collation");

$result = mysql_query("SHOW TABLES");

$count = 0;
while($row = mysql_fetch_assoc($result)) {
$table = $row['Tables_in_'.$mysqldatabase];
mysql_query("ALTER TABLE $table DEFAULT $collation");
$result1 = mysql_query("SHOW COLUMNS FROM $table");
$alter = '';
while($row1 = mysql_fetch_assoc( $result1)) {
if (preg_match('~char|text|enum|set~', $row1["Type"])) {
if(strpos($row1["Field"], 'uuid')){
// why does this not work
}else{
$alter .= (strlen($alter)?", \n":" ") . "MODIFY `$row1[Field]` $row1[Type] $collation" . ($row1["Null"] ? "" : " NOT NULL") . ($row1["Default"] && $row1["Default"] != "NULL" ? " DEFAULT '$row1[Default]'" : "");
}
}
}
if(strlen($alter)){
$sql = "ALTER TABLE $table".$alter.";";
echo "<div>$sql\n\n</div>";
mysql_query($sql);
}
$count++;
}
echo '</div>';

?>