Missing field docdate in documents table

lemonsoftwarero wrote on Monday, May 07, 2007:

When I access /openemr/interface/patient_file/history/encounters.php the following error occurred:

ERROR: query failed: SELECT id, type, url, docdate, list_id FROM documents WHERE foreign_id = ‘2’ ORDER BY docdate DESC, id DESC (Unknown column ‘docdate’ in ‘field list’).

Table documents doesn’t contain such a field, so the error.
My question: this field must exist in table, or the sql statement is wrong?

Thanks.

sunsetsystems wrote on Monday, May 07, 2007:

Sounds like you upgraded but did not apply the database updates in sql/2_8_2-to-2_8_3_upgrade.sql.

Rod
www.sunsetsystems.com

lemonsoftwarero wrote on Tuesday, May 08, 2007:

Yes, I’ve found the missing statement in 2_8_2-to-2_8_3_upgrade.sql. But the others statements doesn’t apply (there are already tables with those fields, etc) except for table documents and users.
It seems that I already have 2.8.3 database version but for some reasons, the documents and users tables didn’t upgrade.

sunsetsystems wrote on Tuesday, May 08, 2007:

2.8.3 is not released yet, so will sometimes (and hopefully only briefly) be out of sync like that.  I guess you know what to do at this point.  :slight_smile:

Rod
www.sunsetsystems.com