Yvan Rodrigues' problogue

(like a blog, but with less effort)

Disconnected ramblings about software development, iOS, FreeBSD, anti-social networking, kittens, drosophilidae, small business, Android, web services, finches, Windows, electrical engineering, XML, rental cars, rye, or ... FIVE dollars??!... something something beer.

So you broke Drupal's tables...

If you have missing tables, you know there isn't an easy way to tell drupal or a module to recreate those tables. For example, this site was missing the [geshifilter-code]field_data_comment[/geshifilter-code] table, or something like that.

To fix it, create a new Drupal installation and install all of the modules that have tables that need repairing.

Now, dump all of the table definitions from the fresh installation:

[geshifilter-mysql]mysqldump <freshdb> --no-data --skip-add-drop-table > fix-mysql.sql[/geshifilter-mysql]

and apply the script to your broken installation:

[geshifilter-mysql]mysql --database=<brokendb> < fix-mysql.sql --force[/geshifilter-mysql]

Ignore all the error messages. Those that the existing tables that we don't want recreated.


Thunderbird is very slow

My portable installation of Thunderbird was misbehaving. A simple operation like opening or deleting a message could take a minute or two.

The solution was close Thunderbird, delete any files ending in -wal, and restart Thunderbird. It is now back to normal.


Matter.js: A Physics Engine in Javascript

How to install PECL uploadprogress on FreeBSD

You need this PECL extension to be installed if you would like to see an upload progress indicator in Drupal. Installation is easy, but not obvious.

[geshifilter-blockcode]cd /tmp # Substitute the latest version from http://pecl.php.net/package/uploadprogress fetch http://pecl.php.net/get/uploadprogress- tar xf uploadprogress- cd uploadprogress- phpize ./configure make build install echo "extension=uploadprogress.so" >> /usr/local/etc/php/extensions.ini cd /tmp rm -R uploadprogress-[/geshifilter-blockcode]


This is my cat and best friend Igor who died of cancer.

5 Alternatives to Google Analytics


Float Labels with CSS

Click on the image to see an animated demonstration.

Read how at: http://css-tricks.com/float-labels-css/


iOS filenames cannot contain more than one period.

It took me a while to figure out why my app couldn't file the file day-icon.20.png. When it renamed it to day-icon.png it worked fine.

System.InvalidOperationException: The operation cannot be completed because a build is already in progress.

Building using Xamarin.iOS and Visual Studio 2012 stopped working for me when my debugging target is a physical device. Clicking Start resulted in the message:

System.InvalidOperationException: The operation cannot be completed because a build is already in progress.

It worked fine at invoking the simulator.

This appears to be a bug, but there is a workaround: Go to the solution's Configuration Manager and uncheck Deploy.

This issue and workaround are present in Xamarin.iOS 1.8.365.


Simple Copyright Policy: If you want to reproduce anything on this site, get my permission first.