Details
-
Bug
-
Status: Closed
-
Should
-
Resolution: Fixed
-
None
-
None
Description
When configuring a new OpenMRS server (initial setup), an SQL exception is thrown:
Error executing SQL UPDATE person_attribute_type as A JOIN person_attribute_type as B ON A.name = B.name SET A.sort_weight = (select count from (select * from person_attribute_type) pat where pat.name < A.name) WHERE A.sort_weight is null: You can't specify target table 'A' for update in FROM clause: Caused By: You can't specify target table 'A' for update in FROM clause Error while trying to update to the latest database version
Full stacktrace and screenshot are in attachment.
I use the latest MySQL server version (5.7.10)
To reproduce this, download the openmrs war file from https://sourceforge.net/projects/openmrs/files/releases/OpenMRS_Platform_2.0.0/ and follow the .war package install instructions in the readme.txt as below:
1. Install Apache Tomcat.
2. Install MySQL 5.7 or higher.
3. Put openmrs.war into <tomcathome>/webapps.
Notice that the war file exceeds 50MB which is the default maximum war file size accepted by
tomcat and therefore you may have to look into https://talk.openmrs.org/t/openmrs-war-file-
exceeding-50mbs-configured-for-tomcat/861 to solve the error you may get while uploading it
into tomcat
4. Visit http://localhost:8080/openmrs and run the installation wizard. You can choose the "Simple" installation type.
You could also see https://wiki.openmrs.org/display/docs/Installing+OpenMRS