Pharmacy dispensory bug

bradymiller wrote on Wednesday, July 08, 2009:

hey,

If i try to add a new drug to the dispensary in cvs version I get the following:
ERROR: insert failed: INSERT INTO drugs ( name, ndc_number, on_order, reorder_point, form, size, unit, route, cyp_factor, related_code, active ) VALUES ( ‘asd adasd’, ‘3123’, ‘123’, ‘123’, ‘1’, ‘11’, ‘1’, ‘2’, ‘0’, ‘’, 1)

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

Abvoe happens when i click add button here, openemr/interface/drugs/drug_inventory.php

-brady

sunsetsystems wrote on Wednesday, July 08, 2009:

Brady, see 3_0_1-to-3_0_2_upgrade.sql.

Rod
www.sunsetsystems.com

sunsetsystems wrote on Wednesday, July 08, 2009:

Whoops, sorry, I forgot to update database.sql.  It’s fixed now.

Rod
www.sunsetsystems.com