The migrate-1.8-to-1.9.sql script used to upgrade OpenVPMS from 1.8 to 1.9 can fail with the error message:
This is due to mixed-case being used in a statement that may cause the script to fail on platforms where MySQL table names are case-sensitive. This failure has been observed in one Linux installation. Other Linux installations have worked successfully.
Windows installations are unlikely to be affected, as MySQL on Windows treats table names as case-insensitive.
The incorrect statement is:
It should be: