I am getting this error when I click on the camos form from a pt encounter:
ERROR: query failed: SELECT t1.category, t1.subcategory, t1.item, t1.content FROM form_CAMOS as t1 JOIN forms as t2 on (t1.id = t2.form_id) where t2.encounter=(select max(encounter) from forms where form_name like ‘CAMOS%’ and encounter < 5397 and pid=2) and t1.pid=2 (Table ‘openemr.form_CAMOS’ doesn’t exist)
But when I look at the database, the form_camos does exist. Is case the issue??
Never mind, case is important, I had to rename the tables. I used the following in the sql box in the database section of admin.
RENAME TABLE form_camos TO form_CAMOS
RENAME TABLE form_camos_category TO form_CAMOS_category
RENAME TABLE form_camos_item TO form_CAMOS_item
RENAME TABLE form_camos_subcategory TO form_CAMOS_subcategory
for some reason my tables were created with camos instead of CAMOS although the create table sql directive appears to be correct.