Editing drug inventory

question

(Obinna Chukwu) #1

I am trying to edit ndc number in htdocs/openemr/interface/drugs/add_edit_drug to nafdac number which want is predominant here in Nigeria. When i add a drug, this is the error message i get
ERROR: insert failed: INSERT INTO drugs ( name, NAFDAC_number, drug_code, on_order, reorder_point, max_level, form, size, unit, route, cyp_factor, related_code, allow_multiple, allow_combining, active ) VALUES ( ‘PROMETHAZINE INJECTION’, ‘B4-7416’, ‘B4-7416’, ‘0’, ‘0’, ‘0’, ‘4’, ‘’, ‘2’, ‘11’, ‘0’, ‘’, 1, 0, 1)

Error: Unknown column ‘NAFDAC_number’ in ‘field list’

C:\xampp\htdocs\openemr\interface\drugs\add_edit_drug.php at 236:sqlInsert

And when i edit a drug i get this error message.
ERROR: query failed: UPDATE drugs SET name = ‘AUGMENTIN INJECTION (POM)’, NAFDAC_number = ‘B1-4563’, drug_code = ‘04-2078’, on_order = ‘30’, reorder_point = ‘0’, max_level = ‘0’, form = ‘6’, size = ‘’, unit = ‘9’, route = ‘11’, cyp_factor = ‘0’, related_code = ‘’, allow_multiple = 1, allow_combining = 0, active = 1 WHERE drug_id = ?

Error: Unknown column ‘NAFDAC_number’ in ‘field list’

How can I get this error message sorted out.

Thanks


(MD Support) #2

NAFDAC_number does not appear to be in standard database.sql.