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.
If the script was run and failed with the above error, any subsequent migration must be done with a freshly restored database, or the migrated prices will be incorrect.
The incorrect statement is:
It should be: