Error on routing screen - ResourceStep missing dateArchive

[jamesrf]

In Resources, I click on a resource and click "Routing", I get this error:

Fatal error: Uncaught exception 'Exception' with message 'There was a problem with the database: Unknown column 'archivingDate' in 'order clause'' in /var/www/html/resources/admin/classes/common/DBService.php:39 Stack trace: #0 /var/www/html/resources/admin/classes/common/DBService.php(73): DBService->checkForError() #1 /var/www/html/resources/admin/classes/domain/Resource.php(1954): DBService->processQuery('SELECT * FROM R...', 'assoc') #2 /var/www/html/resources/ajax_htmldata/getRoutingDetails.php(9): Resource->getResourceSteps() #3 /var/www/html/resources/ajax_htmldata.php(24): include('/var/www/html/r...') #4 {main} thrown in /var/www/html/resources/admin/classes/common/DBService.php on line 39

Looking here, this is the query being run:
https://github.com/Coral-erm/Coral/blob/b200fae47/resources/admin/classes/domain/Resource.php#L1952

However, it doesn't appear that resourceStep has an archivingDate:
https://github.com/Coral-erm/Coral/blob/b200fae47/resources/install/protected/install.sql#L471

I am using master (at 0fb5c34)

[veggiematts]

archivingDate was introduced by #117 , which has been merged.
The database update is here: resources/install/protected/update_restart_and_archiving_a_workflow.sql https://github.com/Coral-erm/Coral/pull/117/files#diff-e1bbe4cec073d15bc5404eef94d94b54

[jeffnm]

@veggiematts For some reason that change to ResourceStep did not make it into the 2.0 update or install sql files. That needs to be fixed before the 2.0.0 release.

[jeffnm]

#193 fixes this for the upgrade but is missing some of the starter data for fresh installs.