:: 05-Feb-1999 14:57 (Friday) ::
Well, I spent most of yesterday massaging the data in the master RC5-64
table on statsbox-ii. When I re-installed sybase onto the new drives,
I forgot to change the default sort order. As a result, all the
recent participants I added as I’ve been testing the logfile import
were added improperly. Normal stats operation is to ignore casing on
email addresses, but since I forgot to change the sort order we were
getting duplicate email addresses in the participants table. Like:
nugget@Slacker.com
nugget@slacker.com
Nugget@slacker.com
being three entries instead of just one. Easy fix, yeah, but it took a
while to hand-correct the participants table and re-link to the master
table.
statsbox-i is pretty much a wash at this point. I may bang on it today
some, but I’m really leaning towards just focusing on the new machine
to get it into production as soon as possible.
Today’s goals involve tidying up the rough edges on the daily-process
script and fiddling some with apache/php.