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?
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.