genome / gms

The Genome Modeling System installer
https://github.com/genome/gms/wiki
GNU Lesser General Public License v3.0
78 stars 22 forks source link

ERROR: column build.created_at does not exist #164

Closed gatoravi closed 9 years ago

gatoravi commented 9 years ago

Running the meta-data importer results in what looks like a schema error.

gmsuser@clia1 ~/gms (ubuntu-12.04-2015.02.22)> genome model import metadata 18177dd5eca44514a47f367d9804e17a-2014.3.14.dat
DBD::Pg::st execute failed: ERROR:  column build.created_at does not exist
LINE 2: select model.build.build_id, model.build.created_at, model.b...
                                     ^ at /opt/gms/2M4JU61/sw/ur/lib/UR/DBI.pm line 888.
ERROR: Failed to execute SQL
select model.build.build_id, model.build.created_at, model.build.created_by, model.build.data_directory, model.build.date_completed, model.build.date_scheduled, model.build.model_id, model.b
uild.run_by, model.build.software_revision, model.build.status, model.build.SUBCLASS_NAME, model.build.updated_at
from model.build
where model.build.build_id in ('124434505')
and model.build.SUBCLASS_NAME = ?
order by model.build.build_id COLLATE "C"
ERROR:  column build.created_at does not exist
LINE 2: select model.build.build_id, model.build.created_at, model.b...
gatoravi commented 9 years ago

an attempt to address this is here. testing is underway to see if this worked.

gatoravi commented 9 years ago

this seems to have worked. closing.