I will just re-install the system with the sample data. This is not a
live system, just one I am doing my learning on.
Thanks for your help nonetheless.
On 2/15/2012 6:20 PM, Ben Wolfe wrote:
Does the person that gave you the data have the exact same openmrs
version that you have? If not, then you will have multiple problems
such as these.
No, you shouldn't just remove the constraints. :-)
Better to reinstall with demo data. Or install to a different db and
export+ import to the one you're using now.
Fyi: your current db now has an issue of missing that table and any
other table before it might be for the wrong openmrs version. :-( Do
you have a backup?
Ben
On Feb 15, 2012 11:15 PM, "Charles C. Chou" <[email protected]
<mailto:[email protected]>> wrote:
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
------------------------------------------------------------------------
Click here to unsubscribe
<mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l>
from OpenMRS Implementers' mailing list
------------------------------------------------------------------------
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]
