jimibrez wrote on Thursday, August 02, 2012:
PHP version 5.2.17
MySQL version 5.5.23-55
I went to forms and attempted to install physical_examination
ERROR: query failed: CREATE TABLE IF NOT EXISTS form_physical_exam ( forms_id bigint(20) NOT NULL, line_id char(8) NOT NULL, wnl tinyint(1) NOT NULL DEFAULT 0, abn tinyint(1) NOT NULL DEFAULT 0, diagnosis varchar(255) NOT NULL DEFAULT '', comments varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (forms_id, line_id) ) TYPE=MyISAM
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9
so i manually created the tables and i can see the form in the forms folder but it is not available in the interface.
Plus, in the administration/forms it still has “Install db” which when clicked still gives the same error
14 Fee Sheet disabled PHP extracted DB installed
18 Graphic Pain Map enabled PHP extracted DB installed
15 Misc Billing Options HCFA disabled PHP extracted DB installed
1 New Encounter Form enabled PHP extracted DB installed
17 Physical Exam registered PHP extracted install DB
19 Prior Authorization Form registered PHP extracted install DB
16 Procedure Order enabled PHP extracted DB installed
13 Review Of Systems enabled PHP extracted DB installed
9 Review of Systems Checks enabled PHP extracted DB installed