August 2006

Help half.com

Having recently sold a book on Half.com I encountered a problem with their system. Something has gone awry and they are sending the notice once an hour. When one ventures to their help desk, however, it's anything but helpful. Eventually if the customer is persistent they find out that the customer goes through the help wizard to get to contact support. Mind you the help wizard has no canned questions that are remotely related to the question at hand. So for a problem with the order system one is reduced to submitting the question about I received an order, but cannot find the shipping address for the buyer.

How to create really annoying databases

Microsoft Access is at once great and the scourge of my existence. It has great power to create databases quickly and for small organizations it can be very handy. However, it also makes it easy to create databases even if it's something you really have no business doing.

I'm working on a couple of inherited projects now and there are two very annoying things. One of the annoying things is to create quasi-relational tables with no normalization. Put as many columns in as possible and repeat them in as many databases as possible. If that doesn't do enough for you copy the database a hundred times and create separate versions of it.

The other, almost more annoying practice, is to create one of these monster tables. Then instead of having your PHP script run queries on the table you create a query in Microsoft Access and run the PHP queries against the MS Access query. For annoying bonus points, rename three of the 40 fields so you have "Username" instead of "User". Repeat.

Oy.

Upgrading MySQL on Mac OS X Server

It is pretty straight forward to migrate an OS X Server's native MySQL 4.1 to a MySQL binary installation of MySQL 5.0. After backing up the databases and /usr/bin install the new binary. Once that is done link /usr/bin/mysql files to /usr/local/mysql/bin.

Two changes are necessary to get everything working. First /etc/my.cnf needs to look at /var/mysql instead of /usr/local/mysql/var for databases. Second since Apple sticks the socket file in /tmp/mysql.sock (come on Apple what are you thinking?) a symbolic link is necessary to have it work properly. The link should point to /var/mysql/mysql.sock (unless you've modified the default config).

The last step is an updatecheck and permissions check.

Variable number of fields in Drupal

The problem I'm currently working on is creating nodes in Drupal with a variable number of fields. For example I'd like to have an "officers" list for organizations they might have 1 or 5 or 50. I'd rather not hard code a certain number of fields as a maximum.

Chase angles for end-run around credit card companies

Browsing the Apple Store there is a new payment method available. Buy Now Pay Later appears to be Chase's end run around the credit card companies. The terms are little different from your standard high-interest credit cards. Conveniently for Chase they forget to mention how long the grace period is before the high rates kick in. Over and over the frequently asked questions it makes the claim that fraud protection is "like credit cards" with no liability for fraudulent transactions.

One is left to wonder how many banks will setup similar end-runs around the big credit card companies in an attempt to keep more of the processing fees for themselves.

Susan Butcher

I just read the sad news that 51-year-old Susan Butcher passed away on Saturday. She died at the University of Washington medical center where she was undergoing treatment for leukemia.

Not long after her fourth Iditarod win I had the good fortune to meet Butcher. She spoke at a scholarship banquet before I headed off to Colorado State University, the same school Butcher attended. Her speech was a wonderful send-off for a group of young scholars setting out on our college careers. One of the most inspirational things she had to share with us is how she set out at 19 to become a dog sled racer as a career. It was a tall order since there was no such thing when she set out on that trail.

Sad news, indeed.

Is Tower Records closing up shop?

If any doubt remains that the sales of CD's and traditional record stores will soon be a memory, the news that several record companies have stopped shipping to Tower Records should make it clear.

While the reason for the suspension of shipments is clear, the deeper meaning is less certain. The companies have stopped supplying albums because of lack of payment. Whether the venerable Tower Records is out of cash or is attempting to force better terms remains unclear. What is more certain is that the last vestiges of the former record distribution chain will be completely gone within a few years.

Encore

The good ones are never here long enough. This morning Encore passed quietly into the pasture everlasting. Though her name on her papers was Charry-Dat she became known to us as Encore. The name had meaning on several levels from the degree of involvement we had in music growing up to the similarity of her markings to those of one of my father's past horses.

It was a cool December day when I first met the horse that would become my first horse. We were celebrating Christmas in San Diego and had seen a couple of horses listed on the board at the feed store. We ended up with a trio of thoroughbreds from a stable outside Del Mar. Two-year-old Encore came with her chestnut half brother Tarn, who passed a couple of years ago, and the dark bay three-year-old Tenaya.

With the VW Bus packed and a new engine freshly installed we set out for home on New Year's Eve. About sixty miles later, while pulling a grade, the new engine quit and we were forced to be towed back to the grandparent's house. The next day after a trip to the rental car agency we packed what we could into the Chevy Astro Van and set out for home again. The horses arrived a few days later and were boarded at a neighbors while the corral panels we'd purchased were delivered.

When they first arrived my heart was set on the young stud-colt. I knew I wanted him to be my horse. It quickly became apparent that he was too much horse and too green for my first horse. The horses spent the next few weeks at the neighbors and we would go each afternoon we were home to work them in the round pen. Within a few weeks the corrals were setup and the horses moved to our place.

Audible deactivation tool

Downloading the latest audiobook purchase from Audible I got the dreaded message that I have too many machines authorized for use with my Audible account. Off to the Audible website to look for the deactivation tool. Using the help and search functions leads to no joy but a recommendation to email customer support. That must have been what I did last time I thought, and sent the email. I get back a note saying it was done and then it goes on to say:

You can always deactivate your account within AudibleManager in the future by simply click here http://www.audible.com/adbl/store/deActivateEntry.jsp and follow the instruction to deactivate your device if you come across this message.

Now I would have loved to have that link come up when I did a search for that very information. And it would have been nice without the little suggestion that I should be able to do this myself in the future. I should have been able to do it myself this time but for the broken website.

Pages