Work on tickets arising out of Michigan meeting.
Catching up after trip to Michigan...
415 emails to get through on my return from TEI Council meeting. Also completed expenses claim for trip.
Bio and keywords added (from HT).
Reviewed the situation with the ETCL site and the fact that none of the links work. Some generate a 404 error, others display a "What's New" page with banner and right column, but no page-specific content. Compared the production site UI and wp-admin settings with my dev site. Did a bunch of playing around with URLs and fiddling with configuration settings in the wp-admin in the dev site. Made no changes at all to the production site.
The problem seems to be an incompatibility between the WP3.1 environment (specifically the way links are handled) and code somewhere in the ETCL theme.
I will next compare the ETCL theme against the twentyten theme in the dev environment as the twentyten theme supports navigation that the ETCL theme doesn't.
I'm still not sure whether I should start with the ETCL theme and modify the php in it as needed to work with the WP3.1 API for links, (which is my preference) or whether I should start a generic theme and modify it to produce the look and feel similar to the current ETCL (except of course that the links would work).
So while reading the Apollodorus text I was looking at the events in section 3.10.2 and saw that the place xml:id=pylos was showing up on the site as "pylospylus"; "pylus" is the "AKA" for "pylos".
After discussing this with Greg we established that it's a coding error. The "placeName" is being pulled for both and seeing as "pylus" is under "placeName" too it's getting attached to "pylos". We looked at other places and saw that "corinth" and "ephyra" is doing the same thing because "ephyra" is under the "placeName" "AKA" too.
Greg is going to look into it and fix the coding.
One task from the meeting the other day was to create a new view of transactions which adds a number of financial fields. I've now done that, using the following SQL:
DROP VIEW IF EXISTS VW_trans_composite_eth_prop_2; CREATE VIEW VW_trans_composite_eth_prop_2 AS ( SELECT seller_titles.ttl_title_id AS seller_title_id, seller_titles.ttl_date AS seller_title_date, seller_titles.ttl_title_code AS seller_title_code, seller_titles.ttl_consideration AS seller_title_consideration, seller_titles.ttl_declaredvalue AS seller_title_declaredvalue, seller_titles.ttl_marketvalue AS seller_title_marketvalue, buyer_titles.ttl_title_id AS buyer_title_id, buyer_titles.ttl_date AS buyer_title_date, buyer_titles.ttl_title_code AS buyer_title_code, DATEDIFF(buyer_titles.ttl_date, seller_titles.ttl_date) as seller_duration_days, buyer_titles.ttl_consideration AS buyer_title_consideration, buyer_titles.ttl_declaredvalue AS buyer_title_declaredvalue, buyer_titles.ttl_marketvalue AS buyer_title_marketvalue, census_tracts.census_tract_code, props.*, sellers.concat_owners AS concat_sellers, sellers.concat_ethnicities AS seller_ethnicities, sellers.total_owners AS total_sellers, sellers.munged_ethnicity AS seller_munged_eth, sellers.total_institutional AS institutional_sellers, buyers.concat_owners AS concat_buyers, buyers.concat_ethnicities AS buyer_ethnicities, buyers.total_owners AS total_buyers, buyers.munged_ethnicity AS buyer_munged_eth, buyers.total_institutional AS institutional_buyers FROM titles AS buyer_titles LEFT JOIN titles_to_prectitles ON buyer_titles.ttl_title_id = titles_to_prectitles.ttp_title_id_fk LEFT JOIN titles AS seller_titles ON seller_titles.ttl_title_id = titles_to_prectitles.ttp_prectitle_id_fk LEFT JOIN VW_titles_composite_eth AS sellers ON seller_titles.ttl_title_id = sellers.ttl_title_id LEFT JOIN VW_titles_composite_eth AS buyers ON buyer_titles.ttl_title_id = buyers.ttl_title_id LEFT JOIN props AS props ON seller_titles.ttl_property_id_fk = props.prp_property_id LEFT JOIN census_tracts ON props.prp_census_tract_id_fk = census_tracts.census_tract_id ORDER BY seller_titles.ttl_title_id )
|<< <||Current||> >>|