Bug #451: The database install.sql script is not compatible with MySQL
|Submitted||4th May 2017|
|Updated||6th May 2017|
Please see https://eoserv.net/forum/topic/23992#post203148 for detailed information.
The IF NOT EXISTS syntax is incorrect for MySQL in lines 104-108 as CREATE INDEX is mapped to ALTER TABLE in MySQL and ALTER TABLE does not support IF EXISTS / IF NOT EXISTS (in MySQL)
Please don't post unless you have something relevant to the bug to say.
Do not comment to say "thanks" or "fix this please".
Please log in to add comments. EOSERV Bug Tracker > Bug #451: The database install.sql script is not compatible with MySQL