drbowen wrote on Wednesday, April 28, 2010:
Hey Guys! I’m wifi at 35,000 ft on the way to a conference.
openemr_devtip-rev-216-04-27-2010
gentoo current
apache 2.2.15
mysql 5.0.84
php 5.2.13
I am trying to install the svn sftip to demo at the conference and got the following error messages:
OpenEMR Setup
Step 3
Configuring OpenEMR…
Connecting to MySQL Server… OK.
Creating database… OK.
Creating user with permissions for database… OK.
Reconnecting as new user… OK.
Opening database…OK.
Creating Main tables…
ERROR. Query failed: "CREATE TABLE `automatic_notification` ( `notification_id` int(5) NOT NULL auto_increment, `sms_gateway_type` varchar(255) NOT NULL, `next_app_date` date NOT NULL, `next_app_time` varchar(10) NOT NULL, `provider_name` varchar(100) NOT NULL, `message` text NOT NULL, `email_sender` varchar(100) NOT NULL, `email_subject` varchar(100) NOT NULL, `type` enum(‘SMS’,‘Email’) NOT NULL default ‘SMS’, `notification_sent_date` datetime NOT NULL, PRIMARY KEY (`notification_id`)) ENGINE=InnoDB AUTO_INCREMENT=3 "
Can’t create table ‘./openemr/automatic_notification.frm’ (errno: 121) (#1005)
ERROR. Query failed: “INSERT INTO `automatic_notification` (`notification_id`, `sms_gateway_type`, `next_app_date`, `next_app_time`, `provider_name`, `message`, `email_sender`, `email_subject`, `type`, `notification_sent_date`) VALUES (1, ‘CLICKATELL’, ‘0000-00-00’, ‘:’, ‘EMR GROUP 1 … SMS’, ‘Welcome to EMR GROUP 1… SMS’, ‘’, ‘’, ‘SMS’, ‘0000-00-00 00:00:00’),(2, ‘’, ‘2007-10-02’, ‘05:50’, ‘EMR GROUP’, ‘Welcome to EMR GROUP . Email’, ‘EMR Group’, ‘Welcome to EMR GROUP’, ‘Email’, ‘2007-09-30 00:00:00’)”
Table ‘openemr.automatic_notification’ doesn’t exist (#1146)
ERROR. Query failed: "CREATE TABLE `notification_log` ( `iLogId` int(11) NOT NULL auto_increment, `pid` int(7) NOT NULL, `pc_eid` int(11) unsigned NULL, `sms_gateway_type` varchar(50) NOT NULL, `smsgateway_info` varchar(255) NOT NULL, `message` text NOT NULL, `email_sender` varchar(255) NOT NULL, `email_subject` varchar(255) NOT NULL, `type` enum(‘SMS’,‘Email’) NOT NULL, `patient_info` text NOT NULL, `pc_eventDate` date NOT NULL, `pc_endDate` date NOT NULL, `pc_startTime` time NOT NULL, `pc_endTime` time NOT NULL, `dSentDateTime` datetime NOT NULL, PRIMARY KEY (`iLogId`)) ENGINE=InnoDB AUTO_INCREMENT=5 "
Can’t create table ‘./openemr/notification_log.frm’ (errno: 121) (#1005)
ERROR. Query failed: "CREATE TABLE `notification_settings` ( `SettingsId` int(3) NOT NULL auto_increment, `Send_SMS_Before_Hours` int(3) NOT NULL, `Send_Email_Before_Hours` int(3) NOT NULL, `SMS_gateway_username` varchar(100) NOT NULL, `SMS_gateway_password` varchar(100) NOT NULL, `SMS_gateway_apikey` varchar(100) NOT NULL, `type` varchar(50) NOT NULL, PRIMARY KEY (`SettingsId`)) ENGINE=InnoDB AUTO_INCREMENT=2 "
Can’t create table ‘./openemr/notification_settings.frm’ (errno: 121) (#1005)
ERROR. Query failed: “INSERT INTO `notification_settings` (`SettingsId`, `Send_SMS_Before_Hours`, `Send_Email_Before_Hours`, `SMS_gateway_username`, `SMS_gateway_password`, `SMS_gateway_apikey`, `type`) VALUES (1, 150, 150, ‘sms username’, ‘sms password’, ‘sms api key’, ‘SMS/Email Settings’)”
Table ‘openemr.notification_settings’ doesn’t exist (#1146)
ERROR. Query failed: “CREATE TABLE `users_facility` ( `tablename` varchar(64) NOT NULL, `table_id` int(11) NOT NULL, `facility_id` int(11) NOT NULL, PRIMARY KEY (`tablename`,`table_id`,`facility_id`)) ENGINE=InnoDB COMMENT=‘joins users or patient_data to facility table’”
Can’t create table ‘./openemr/users_facility.frm’ (errno: 121) (#1005)
OK
Creating Language Translation (utf8) tables… OK
Adding Initial User… OK
Writing SQL Configuration…
Successfully wrote SQL configuration.
Writing global configuration defaults…
Successfully wrote global configuration defaults.
Next step will install and configure access controls (php-GACL).
I wanted to try the svn devtip but may need to revert to sourceforge-cvs.
any ideas?
Sam Bowen, MD
http://oemr.org