SNOMED error

system · November 18, 2013, 5:51pm

cpolyv01 wrote on Monday, November 18, 2013:

Hello,

I have installed snomed codes and when try to search I get the error:
ERROR: Missing table in code set search:sct_descriptions

system · November 18, 2013, 8:17pm

yehster wrote on Monday, November 18, 2013:

What OS? On non-windows, the table names are case sensitive. Can you check that when you imported, the table name is all lowercase?

system · November 19, 2013, 12:55pm

cpolyv01 wrote on Tuesday, November 19, 2013:

Hello,

We are working on Centos. I have checked the tables and all are lowercase. The installation was done from the external data loads.

system · November 19, 2013, 1:08pm

yehster wrote on Tuesday, November 19, 2013:

github.com

openemr/openemr/blob/master/custom/code_types.inc.php#L480


    }
}


if ($form_code_type == 'PROD') { // Search for products/drugs
    if ($count) {
        $query = "SELECT count(dt.drug_id) as count ";
    } else {
        $query = "SELECT dt.drug_id, dt.selector, d.name ";
    }


     $query .= "FROM drug_templates AS dt, drugs AS d WHERE " .
             "( d.name LIKE ? OR " .
             "dt.selector LIKE ? ) " .
             "AND d.drug_id = dt.drug_id " .
             "ORDER BY d.name, dt.selector, dt.drug_id $limit_query";
    $res = sqlStatement($query, array("%".$search_term."%", "%".$search_term."%"));
} else { // Start a codes search
    // We are looking up the external table id here.  An "unset" value gets treated as 0(zero) without this test.  This way we can differentiate between "unset" and explicitly zero.
    $table_id=isset($code_types[$form_code_type]['external']) ? intval(($code_types[$form_code_type]['external'])) : -9999 ;
    if ($table_id>=0) { // We found a definition for the given code search, so start building the query
    // Place the common columns variable here since all check codes table

This is the code where that error message is being generated. It is attempting to verify that the table exists.

If you confirmed that the table sct_descriptions exists and it is named properly, then I’m stumped as to where the problem is.

system · November 19, 2013, 1:49pm

fsgl wrote on Tuesday, November 19, 2013:

Does un-install and re-install correct the problem?

What version of OpenEMR are you running?

system · November 19, 2013, 2:03pm

cpolyv01 wrote on Tuesday, November 19, 2013:

I updated into 4.1.2. I cannot find the table anywhere in the database and I actually do not know where to create one.

system · November 19, 2013, 3:05pm

fsgl wrote on Tuesday, November 19, 2013:

Experimented on 4.1.2 Demo, which does not have SNOMED installed.

Got the same error message as you when I went to Administration/Codes, clicked SNOMED & Search.

Are you on Patch 3? If not, do so.

Try to install SNOMED from the External Data Loads Utility again, because it probably did not install the first time.

system · November 19, 2013, 7:22pm

cpolyv01 wrote on Tuesday, November 19, 2013:

Ok. I have re-installed it due to some other problems. I am on Patch 3. I will try it again and post back. Hope it will work this time.

system · November 19, 2013, 8:55pm

fsgl wrote on Tuesday, November 19, 2013:

If not, there is an alternate way to import, but it is way more strenuous than using the built-in tool but still easier than manual imput.

This thread may be pertinent.