Engineering Analysis

Mysql ISO-8859-1 (LATIN1) to UTF-8

I thought I would throw in a link to a howto I wrote over at OG Consulting. I would wager there are a few people out there that have legacy data in an old MySQL installation (4.0.x and below), and need to bring their installation up to date. I believe the MySQL folks are going to EOL (end of life) MySQL versions less than 4.1.x, so it is now a necessity to get it up to speed. For those of you with a lot of legacy data, I've written a little tutorial on stuffing your mixed character encoded data into a fresh shiny new MySQL installation.

Take a look here.

admin's picture

James O'Malley is the head tech guy at Altamente. He has been working on the internet since it was a proper noun. He knows hardware. He knows software. He knows networks. Perhaps more than anything, though, he likes people.

Drupal + BBClone

I like BBCLONE's visitor statistics package. It has served us well for more than a few years. Our customers like it too. There is a problem though. Drupal and BBClone do not get along very well. Here are a couple of tips to get BBClone working with virtual hosts (multiple sites hosted via one single drupal installation), and with caching enabled.

Most of the helpful hints proposed on http://drupal.org/ suggest installing the relevant BBClone code in the ~drupal/index.php file, like so:

$bbrequest = strtolower($_SERVER["REQUEST_URI"]);
define("_BBC_PAGE_NAME", $bbrequest);
define("_BBCLONE_DIR", "bbclone/");
define("COUNTER", _BBCLONE_DIR."mark_page.php");
if (is_readable(COUNTER)) include_once(COUNTER);

This is all fine and good, but if you are hosting multiple sites under ~drupal/sites/ then you are going to have a problem. Each virtual site has its own statistics counter and bbclone directory. We want each site to count only its own vistors.

admin's picture

James O'Malley is the head tech guy at Altamente. He has been working on the internet since it was a proper noun. He knows hardware. He knows software. He knows networks. Perhaps more than anything, though, he likes people.

You Already Own All the Software on This Website

It was time to refactor this website, offer new services, organize content, and hone our client focus. I will recount the process here, partly for historical reasons and as documentation for later, but also just because the whole process was so cool. First, the technology used was, as always, 100% GPL'ed or BSD licensed software, from the content management system, to the flash animations, to the images, 3-d modelling, PDF generation, authoring, hosting, and database. If I think of anything else, I'll throw it in the soup. Everything from start to finish was done with 100% software libre.

admin's picture

James O'Malley is the head tech guy at Altamente. He has been working on the internet since it was a proper noun. He knows hardware. He knows software. He knows networks. Perhaps more than anything, though, he likes people.

Syndicate content Subscribe to this news feed