Skip to content
Archive of entries posted on October 2008

Romance of the Three Kingdoms XI game event stills

In Koei’s Romance of the Three Kingdoms XI for Windows PC (non PUK, English edition), there are a total of 30 event stills ( basically, pictures of important events during a campaign, viewable under Settings -> Reference -> View Event Stills ). Upon collecting all 30 and winning any scenario to unite China, you will [...]

redhillonrails_core and broken MySQL empty string defaults

While hacking on a side project in Ruby on Rails, I ran across this weird error when trying to insert new data:
ActiveRecord::StatementInvalid: Mysql::Error: Column ‘attr2′ cannot be null: INSERT INTO `foo` (`attr1`, `attr2`) … VALUES (‘1′, NULL)
where attr2 is a varchar (or t.string, in Rails lingo) and set to not null default ” [...]

APR and 32-bit/64-bit universal binary compilation

When compiling APR, the Apache Portable Runtime 1.3.3 (as a part of Subversion 1.5.3 as I am doing here, or not) on OS X 10.5 Leopard, you may encounter the following error at compile time.
/bin/sh /tmp/subversion-1.5.3/apr/libtool –silent –mode=compile gcc-4.2 -Os -arch i386 -arch x86_64 -DHAVE_CONFIG_H -DDARWIN -DSIGPROCMASK_SETS_THREAD_MASK -no-cpp-precomp -I./include -I/tmp/subversion-1.5.3/apr/include/arch/unix -I./include/arch/unix -I/tmp/subversion-1.5.3/apr/include/arch/unix -I/tmp/subversion-1.5.3/apr/include [...]

using ffmpeg for cutting media files – and the gotchas involved

So here I was, trying to complete some ordinary transcoding / media file cutting tasks with ffmpeg. Turns out there are some weird gotchas when using some versions of ffmpeg (in my case, SVN-r10571) on the commandline.
Problem 1: transcoding to mp3 insists on using 64kbits/s or 128kbits/s bitrate
So a simple task is to [...]