Avidemux script to join multiple flv files

datePosted on 15:42, August 15th, 2014 by yk

Some video sites allow you to download a show but they are broken up into multiple FLV files. The attached Avidemux Tinypy script will allow you to choose folder and join all the FLV files that are found inside and save it in a MKV container (more video player friendly).

If you need to join other file types, modify the following lines:
ext="flv"

If you need to save as another file container type, modify the following lines:
adm.setContainer("MKV")
and
outputFile = inputFolder+"\\"+directoryName+".mkv"

Pardon the messy code, it was done as a quick and dirty script.

Click here to download the script

Query error: Incorrect string value

datePosted on 16:39, April 20th, 2013 by yk

I was inserting records into a MySQL table using php and got an error that says:
Query error: Incorrect string value: '\xE2\x82...' for column 'message' at row 1 - Invalid query: INSERT INTO `my_table` (`message`) VALUES ('The price is xE2x82 500')

The original string in the ‘message’ field is actually
The price is € 500

This error is surprising given that the string is actually in UTF-8 encoding and the field in the MySQL table is declared as utf8_unicode_ci type.

The solution that I found it is to call the php function utf8_encode to encode string before inserting into the MySQL table.

Microsoft Outlook has stopped working

datePosted on 11:52, February 22nd, 2011 by yk

Recently after migrating to Windows 7, I’ve been encoutering the this message a lot from Outlook 2003.

After poking around a bit (like removing and re-adding my mail account, removing and re-adding my personal and archive folders, etc), the only solution that worked for me is to force Outlook to recreate the OST file. For those who are interested the location of the file is at:

Windows 7:
%userprofile%\AppData\Local\Microsoft\Outlook\

Windows XP:
%userprofile%\Local Settings\Application Data\Microsoft\Outlook\

Just rename all the files with the .ost extension to something else and try to start Outlook again.

Installing PSP custom firmware 5.00 M33-6

datePosted on 18:32, February 4th, 2009 by yk

Installing Custom Firmware 5.00 M33-6. This article assumes that you have custom firmware (OE/M33) installed on your PSP and want to upgrade to version 5.00 M33-6. Read the rest of this entry »

Installing PSP custom firmware 5.00 M33-3

datePosted on 22:38, October 25th, 2008 by yk

Installing Custom Firmware 5.00 M33-3. This article assumes that you have custom firmware (OE/M33) installed on your PSP and want to upgrade to version 5.00 M33-3. Read the rest of this entry »