Hello, I am trying to install openEMR onto a server. I have no real knowledge of this process, but I have been able to get through installation and have the program running an my server. As I am trying to install the forms (e.g. CAMOS) I am getting this error message.
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’CREATE TABLE IF NOT EXISTS `form_CAMOS` ( id bigint(20) NOT NULL auto_increme’ at line 1
prior to this i was having type and engine mismatch that thanks to this forum i was able to figure out. If any advice could you please give me detailed fix. again not much experience so more detail the better, thanks in advance.
I’m using mac mini- lion server. trying to install on openemr 4.1. The previous error i was getting was TYPE=MyISAM not valid, so i edited file from TYPE=MyISAM to ENGINE=MyISAM, and that error went away when trying to install form CAMOS, but was replaced by another error the one I listed above:
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’CREATE TABLE IF NOT EXISTS `form_CAMOS` ( id bigint(20) NOT NULL auto_increme’ at line 1