Depts

The HTML rendering of the poems now provides tools to enable you to create new readings simply by clicking on segments; it generates a link element which can be copy/pasted back into the TEI file of the poem.

The next stage will be an identity transform that creates all the segments initially, and also builds the first (complete) reading.

At EW's request, commented out two sessionals no longer working in the department from the secondaryNavbar.php page.

Added new content for the last two lecture series to the Beck site. A lot of it is still commented out, pending processing of audio, clearing of copyright issues, etc.

Instructions from DW:

• To add an events calendar list to anything you first need to create an events calendar listing block. This is under New-> UVic Blocks ->Dynamic ->Events Calendar.
• You can then fill that out, create the block, then drop that block into a page or into an accordion.
• The content of the block will appear once the site is published.

Working on the basic structure. Unable (yet) to figure out how to create a page based on an Events calendar feed.

Created a new directory for Manifestoes linked files: /home1t/showofha/www/manifestoes, then edited the local_classes.php file to make that the base path; added a new rv_linked_files field to the revolt table, and tested in dev before porting to live. All seems OK.

Met with PAB and arranged to have new content for the last two lecturers sent, with items highlighted to show they're to be commented out until all content processing is finished. Also fixed a bug on the Travel Award page: this was curled from the humanities site, but the content contained a relative link that needed to be fully expanded before it would work from our Beck page.

Meeting with JA and Comms folks re keeping Hums sites on track through the Cascade process. Also attended a workshop with DW on building out a site, where I continued my preliminary work on the French site, which I started this morning. The basic framework is coming together, and I've learned how to do a few of the things that you could never figure out without asking. We also found and fixed a couple of bugs in the way the site was set up.

The existence table primary key field had not been set to auto-increment, so when a new item was added, it got the id zero; that screwed up behaviour in the AdaptiveDB code. Fixed the bug, and changed the zero value.

Another minor site update.

K is sick, so DR asked me to upload and link a file directly. Did that on both the lang03 and paorweb accounts, to keep everything in sync.

M called me over to deal with a frozen Windows VM, which had in turn frozen VirtualBox and eventually the whole machine. The VM was eating 4GB of memory. Tried restarting just the VM but it crashed again, so restarted the whole machine; that took a forced reboot because it wouldn't shut down. When we brought everything back up, there was no temporary nVivo file in the normal temp folder [user]\local\Application Data\temp, but there was a 4MB binary log file. On starting up nVivo again and trying to load the database, it complained that the original was corrupted, but offered to retrieve a cached copy; the binary log file then disappeared and the db was restored, so it looks as though it ran the log file against the original file and reconstructed all today's changes.

Note to Greg: nVivo's looking a bit unstable. We should look at extra backup options to give us more redundancy that we have.

At JW's request, made the following changes:

One short-string field named "People"

Four one-to-many fields: 
* Manifesto approach
* Manifesto content
* Manifesto authorship
* Other analysis

Also change the title of the current long-text field "Manifesto" to "Manifesto text", that would help differentiate it. As for positioning, ideally, "People" would go after 'Object', 'Other analysis' would go at the very bottom, and the other three would go after 'Manifesto text'. 

This is the SQL:

# Manifesto database changes 2011-05-10

# Adding four one-to-many fields, requiring eight new tables, and one new regular short string field in the main table.
# First drop all tables in case they already exist.

DROP TABLE IF EXISTS `approach_to_revolt`;
DROP TABLE IF EXISTS `content_to_revolt`;
DROP TABLE IF EXISTS `authorship_to_revolt`;
DROP TABLE IF EXISTS `analysis_to_revolt`;
DROP TABLE IF EXISTS `approach`;
DROP TABLE IF EXISTS `content`;
DROP TABLE IF EXISTS `authorship`;
DROP TABLE IF EXISTS `analysis`;


# Now create four tables.
CREATE TABLE IF NOT EXISTS `approach` (
  `ap_id` int(11) NOT NULL auto_increment,
  `ap_name` varchar(128) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`ap_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `content` (
  `co_id` int(11) NOT NULL auto_increment,
  `co_name` varchar(128) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`co_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `authorship` (
  `au_id` int(11) NOT NULL auto_increment,
  `au_name` varchar(128) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`au_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `analysis` (
  `an_id` int(11) NOT NULL auto_increment,
  `an_name` varchar(128) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`an_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;

# Now create four linking tables.

CREATE TABLE IF NOT EXISTS `approach_to_revolt` (
  `apr_apr_id` int(11) NOT NULL auto_increment,
  `apr_ap_id_fk` int(11) NOT NULL,
  `apr_rv_id_fk` int(11) NOT NULL,
  PRIMARY KEY  (`apr_apr_id`),
  KEY `apr_ap_id_fk` (`apr_ap_id_fk`),
  KEY `apr_rv_id_fk` (`apr_rv_id_fk`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `approach_to_revolt`
  ADD CONSTRAINT `approach_to_revolts_ibfk_1` FOREIGN KEY (`apr_rv_id_fk`) REFERENCES `revolt` (`rv_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `approach_to_revolts_ibfk_2` FOREIGN KEY (`apr_ap_id_fk`) REFERENCES `approach` (`ap_id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
CREATE TABLE IF NOT EXISTS `content_to_revolt` (
  `cor_cor_id` int(11) NOT NULL auto_increment,
  `cor_co_id_fk` int(11) NOT NULL,
  `cor_rv_id_fk` int(11) NOT NULL,
  PRIMARY KEY  (`cor_cor_id`),
  KEY `cor_co_id_fk` (`cor_co_id_fk`),
  KEY `cor_rv_id_fk` (`cor_rv_id_fk`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `content_to_revolt`
  ADD CONSTRAINT `content_to_revolts_ibfk_1` FOREIGN KEY (`cor_rv_id_fk`) REFERENCES `revolt` (`rv_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `content_to_revolts_ibfk_2` FOREIGN KEY (`cor_co_id_fk`) REFERENCES `content` (`co_id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
CREATE TABLE IF NOT EXISTS `authorship_to_revolt` (
  `aur_aur_id` int(11) NOT NULL auto_increment,
  `aur_au_id_fk` int(11) NOT NULL,
  `aur_rv_id_fk` int(11) NOT NULL,
  PRIMARY KEY  (`aur_aur_id`),
  KEY `aur_au_id_fk` (`aur_au_id_fk`),
  KEY `aur_rv_id_fk` (`aur_rv_id_fk`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `authorship_to_revolt`
  ADD CONSTRAINT `authorship_to_revolts_ibfk_1` FOREIGN KEY (`aur_rv_id_fk`) REFERENCES `revolt` (`rv_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `authorship_to_revolts_ibfk_2` FOREIGN KEY (`aur_au_id_fk`) REFERENCES `authorship` (`au_id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
CREATE TABLE IF NOT EXISTS `analysis_to_revolt` (
  `anr_anr_id` int(11) NOT NULL auto_increment,
  `anr_an_id_fk` int(11) NOT NULL,
  `anr_rv_id_fk` int(11) NOT NULL,
  PRIMARY KEY  (`anr_anr_id`),
  KEY `anr_an_id_fk` (`anr_an_id_fk`),
  KEY `anr_rv_id_fk` (`anr_rv_id_fk`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `analysis_to_revolt`
  ADD CONSTRAINT `analysis_to_revolts_ibfk_1` FOREIGN KEY (`anr_rv_id_fk`) REFERENCES `revolt` (`rv_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `analysis_to_revolts_ibfk_2` FOREIGN KEY (`anr_an_id_fk`) REFERENCES `analysis` (`an_id`) ON DELETE CASCADE ON UPDATE CASCADE;

# Now add a new field.

ALTER TABLE `revolt` ADD COLUMN `rv_people` VARCHAR(128) AFTER `rv_object`;

Also updated the copy_live_to_dev_db.sql script, fixed a bug in dev_to_live_update.sh, and made all the necessary changes in the local_classes.php file.

Added a new page called Resources to the VPN WordPress site to list all links. Had to make a custom 'resources' template. http://web.uvic.ca/~vicpoet/resources/

Met with ER to discuss the next phase of the project, which needs a new proposal since he has a new IRG. Planned out the work, and then completed a project proposal based heavily on the original one.

At the request of AC, added a very simple sidebar to the VPN WordPress page, on the left side of the layout. Had to adjust all of the template files, and re-jigged the CSS to accomodate the modified layout for content. AC and I determined that the site's navigational structure wasn't clear enough with regard to finding blog posts, so this sidebar was brought in to provide easier access to archives.

I put the initial set of widgets in the sidebar but I expect that AC will want to play around.

http://web.uvic.ca/~vicpoet/

Met with CSP, AL and HR to complete the Project Lite Web document, and then had a whiteboard session to plan the navigation, based on discussions the dept has already had. Came up with what looks like a good navigation plan, and passed back an outline of it, with photos of the whiteboard, for HR to start working into the spreadsheet.