EOSERV Bug Tracker > Bug #451: The database install.sql script is not compatible with MySQL

Bug #451: The database install.sql script is not compatible with MySQL

The database install.sql script is not compatible with MySQL
ID #451
Submitter Hacker_Alex
Product EOSERV
Severity High
Status OPEN, CONFIRMED
Submitted 4th May 2017
Updated 6th May 2017
Hacker_Alex Submitter 6 years, 48 weeks ago

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)

Comments

Hacker_Alex Submitter 6 years, 48 weeks ago

If MySQL isn't supposed to be supported at all anymore, then I'm sorry for posting this.

Updated Severity to TRIVIAL

Sausage Developer 6 years, 47 weeks ago

Updated Severity to HIGH
Updated Status to CONFIRMED

Add Comment

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