apdkmel wrote on Tuesday, November 29, 2011:
Hello,
I am currently testing the upgrade of our installation from version 4.0 to 4.1.
When running the sql ugrade script, I get the following error:
CREATE TABLE `rule_action_item` ( `category` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to list_options list rule_action_category', `item` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to list_options list rule_action', `clin_rem_link` varchar(255) NOT NULL DEFAULT '' COMMENT 'Custom html link in clinical reminder widget', `reminder_message` text NOT NULL DEFAULT '' COMMENT 'Custom message in patient reminder', `custom_flag` tinyint(1) NOT NULL default 0 COMMENT '1 indexed to rule_patient_data, 0 indexed within main schema', PRIMARY KEY (`category`,`item`)) ENGINE=MyISAM
ERROR: query failed: CREATE TABLE `rule_action_item` ( `category` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to list_options list rule_action_category', `item` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to list_options list rule_action', `clin_rem_link` varchar(255) NOT NULL DEFAULT '' COMMENT 'Custom html link in clinical reminder widget', `reminder_message` text NOT NULL DEFAULT '' COMMENT 'Custom message in patient reminder', `custom_flag` tinyint(1) NOT NULL default 0 COMMENT '1 indexed to rule_patient_data, 0 indexed within main schema', PRIMARY KEY (`category`,`item`)) ENGINE=MyISAM
Error: BLOB/TEXT column 'reminder_message' can't have a default value
OpenEMR then displays various sql errors on login.
It is a Windows XP/XAMP installation on a dev box, with multiple sites (2). The MySQL user has got full privileges.
I’ve run both the regular Windows Upgrade to 4.1 instructions, as well as the one for Multiple Sites (The sqlconf.php file did not have any different variables). Both times it resulted in the same error.
Has anybody come across a similar issue? Thanks!