Other database load

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

jcahn2 wrote on Sunday, June 09, 2013:

OK, I have a lot of errors here. Somewhere I have restored an old database and changed a lot of these tables. Nevermind :>| Webmaster, feel free to delete this thread.
Jack