Error with 2.8.2 to 2.8.3 upgrade sql script

OpenEMR Development
1

bradymiller wrote on Sunday, September 16, 2007:

hey,

  Noted below error when running the 2_8_2-to-2_8_3_upgrade.sql script:
ERROR 1146 (42S02) at line 39: Table ‘openemr.form_football_injury_audit’ doesn’t exist

After deleting the below section in the 2_8_2-to-2_8_3_upgrade.sql file, no more errors:
ALTER TABLE form_football_injury_audit
  ADD `fimatchtype` int(11) NOT NULL DEFAULT 0;

Is this table ‘form_football_injury_audit’ supposed to be in the default install of OpenEMR?

-brady

2

sunsetsystems wrote on Sunday, September 16, 2007:

No, it’s not in the default install.  You have to manually remove anything in the upgrade scripts that’s for forms you don’t have, as MySQL doesn’t seem to have an “alter table if exists …” option.

Rod
www.sunsetsystems.com