KYMCCREA-L Archives

Archiver > KYMCCREA > 2007-04 > 1176859829


From: "Timothy N. West" <>
Subject: [KYMCCREA] Scott Co, TN Website Updated
Date: Tue, 17 Apr 2007 21:30:29 -0400


I updated the website this evening. I'm sorry but it took me longer
than I expected to correct the date corruption problem. It was a very
weird problem that is supposed to be technically impossible. Oh well,
its fixed now. Now I can focus on the headstone pictures.

The good news is I also added 438 more obituaries. The bad news is you
won't be able to use the "new records within last xx days" query to see
them quickly. That feature only works for the last 30 days and 436 of
the obituaries were added prior to the corruption problem, more than 30
days ago. Sorry.

...tim west...
Scott Co, TN Coordinator for the TNGenWeb Project
http://www.tngenweb.org/scott

* *Corrections, updates, and additions*
o Fixed the date corruption problem in the database and
normalized all the date formats
+ [For those of you who are interested: the dates
fields somehow acquired two different formats within
the MySQL structure definition. This caused dates to
be served up in two different forms. The PHP code I
wrote was not expecting two forms so it really didn't
know what to do with the second form though the code
tried valiantly to transform the ISO date format into
a dd Mmm YYYY format. I have no idea how the date
structure definition became corrupted because MySQL is
not supposed to allow that to happen--it should be an
impossible condition.]
o All date fields in the database are now explicit. In the
past a partial date might be shown as "May 1984" but you
can't tell if I forgot to include the day or whether the day
was simply not specified or available. Dates will now be
displayed only in the following formats as appropriate
(example dates):
1. "23 Jan 2007"
2. "(no day) Jan 2007"
3. "23 (no month) 2007"
4. "2007"
5. "23 Jan (no year)"
6. "(no day) Jan (no year)"
7. "23 (no month) (no year)"
8. "unknown"
o I've also added a temporary fix that affects all visitors
but was put in place to accommodate those of you who use
Microsoft's IE browser. Now, whenever you select the
cemetery query page or the death records query page, your
browser will now open a new window or tab (depending on your
browser version) to display the query page and results. You
will notice the menu typically seen on the left of the
screen will not display in this new window or tab. I had to
do this because Microsoft IE improperly handles session
information passed between frames. Just close this new
window to return to usual homepage that displays the menu.
This technique will stay in play until I redesign the
navigation structure for the website (i.e., remove the use
of frames). This will fix the problem some of you were
having in not being able to search for cemeteries by name,
not being able to log-in to add comments, and not being able
to add comments even though you were able to login.
* Scott Co, Death Records
<http://www.tngenweb.org/scott/death_records.htm>; (database total
is now 13,792)
o Added 438 obituaries (total is now 3,758)
o Added 5 obituary pictures (total is now 75)


This thread: