jcahn wrote on Saturday, June 08, 2013:
I have the following error message when trying to install any of the
Other Database scripts:
ERROR: query failed: SELECT DATE_FORMAT(revision_date
,’%Y-%m-%d’) as
revision_date
, revision_version
, name
, file_checksum
FROM
standardized_tables_track
WHERE upper(name
) = ? ORDER BY
revision_date
DESC
Error: Unknown column ‘file_checksum’ in ‘field list’
I have one entry in the standardized_table_track table called “ICD9” and
all fields have entries including a long hash # for the ‘file_checksum’
field.
Any suggestions to undo the error of my ways? Could I safely delete this
entry and start over?
Version 4.1.1, patch 12, ubuntu 12.04.2. I have also added the fee
sheet enhancement from Yehster.
Jack Cahn