OpenEMR setup starts fine, I enter all the information needed into the form, but once I save the database information and continue, I get an error (posted below, in the Logs section). Help needed. Thanks in advance.
OpenEMR Version
I’m using OpenEMR version 7.0.0
Browser:
I’m using: Google Chrome
Operating System
WINDOS 10, Wampserver 3.2.6 64bit
Logs
Connecting to MySQL Server… OK.
Creating database… OK.
Creating user with permissions for database… OK.
Reconnecting as new user… OK.
ERROR. unable to execute SQL: ‘CREATE TABLE clinical_rules_log ( id bigint(20) NOT NULL auto_increment, date datetime DEFAULT NULL, pid bigint(20) NOT NULL DEFAULT ‘0’, uid bigint(20) NOT NULL DEFAULT ‘0’, category VARCHAR(255) NOT NULL DEFAULT ‘’ COMMENT ‘An example category is clinical_reminder_widget’, value TEXT, new_value TEXT, PRIMARY KEY (id), KEY pid (pid), KEY uid (uid), KEY category (category)) ENGINE=InnoDB AUTO_INCREMENT=1’ due to: Index column size too large. The maximum column size is 767 bytes.