Hi,
I got this dump file indirectly through one of the openmrs
contributors in an attempt to set up a sample database as I did not
check the load sample data checkbox when I installed. Here is the table
create statement that caused the error:
DROP TABLE IF EXISTS `concept_reference_map`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `concept_reference_map` (
`concept_map_id` int(11) NOT NULL AUTO_INCREMENT,
`concept_reference_term_id` int(11) NOT NULL,
`concept_map_type_id` int(11) NOT NULL DEFAULT '1',
`creator` int(11) NOT NULL DEFAULT '0',
`date_created` datetime NOT NULL DEFAULT '0002-11-30 00:00:00',
`concept_id` int(11) NOT NULL DEFAULT '0',
`changed_by` int(11) DEFAULT NULL,
`date_changed` datetime DEFAULT NULL,
`uuid` char(38) DEFAULT NULL,
PRIMARY KEY (`concept_map_id`),
KEY `map_for_concept` (`concept_id`),
KEY `map_creator` (`creator`),
KEY `mapped_concept_map_type` (`concept_map_type_id`),
KEY `mapped_user_changed_ref_term` (`changed_by`),
KEY `mapped_concept_reference_term` (`concept_reference_term_id`),
CONSTRAINT `mapped_concept_reference_term` FOREIGN KEY
(`concept_reference_term_id`) REFERENCES `concept_reference_term`
(`concept_reference_term_id`),
CONSTRAINT `mapped_concept_map_type` FOREIGN KEY
(`concept_map_type_id`) REFERENCES `concept_map_type`
(`concept_map_type_id`),
CONSTRAINT `mapped_user_changed_ref_term` FOREIGN KEY (`changed_by`)
REFERENCES `users` (`user_id`),
CONSTRAINT `map_creator` FOREIGN KEY (`creator`) REFERENCES `users`
(`user_id`),
CONSTRAINT `map_for_concept` FOREIGN KEY (`concept_id`) REFERENCES
`concept` (`concept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
After doing some searches I think the contraints may be the culprit. Can
I just remove the contraints?
Regards,
Charles Chou
On 2/15/2012 11:45 AM, Wyclif Luyima wrote:
Hi Charles,
Where did you get the file you are loading? Was it from our downloads
page?
Wyclif
On Wed, Feb 15, 2012 at 1:54 PM, Charles C. Chou <[email protected]
<mailto:[email protected]>> wrote:
Hi,
I tried to load the openmrs database with an existing database
dump but got the following error:
ERROR 1005 (HY000) at line 737: Can't create table
'openmrs.concept_reference_map' (errno: 121)
Can someone tell me what causes this? Thanks!
Regards,
Charles Chou
_________________________________________
To unsubscribe from OpenMRS Implementers' mailing list, send an
e-mail to [email protected]
<mailto:[email protected]> with "SIGNOFF
openmrs-implement-l" in the body (not the subject) of your e-mail.
[mailto:[email protected]
<mailto:[email protected]>?body=SIGNOFF%20openmrs-implement-l]
------------------------------------------------------------------------
Click here to unsubscribe
<mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l> from
OpenMRS Implementers' mailing list
_________________________________________
To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to
[email protected] with "SIGNOFF openmrs-implement-l" in the body
(not the subject) of your e-mail.
[mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
