search

elliotchance / mbzdb

🎵 Port of the MusicBrainz database to run on other RDBMSs with replication (previously named MB_MySQL.)
88 stars 33 forks source link

Create schema problem #40

Closed ilevennet closed 12 years ago

ilevennet commented 12 years ago

When creating a schema

Table over_art_presence AS ENUM ('absent', 'present', 'darkened'); Table release_meta DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cover_art_presence NOT NULL DEFAULT 'absent'' at line 1 at backend/mysql.pl line 463, line 1253.

Kline- commented 12 years ago

Installing this today and hit this issue also. MySQL sever 5.1.53-log on Debian 5.0.9. Below is the hand-fix I applied to my db:

ALTER TABLE  `release_meta` ADD  `cover_art_presence` ENUM(  'absent',  'present',  'darkened' ) NOT NULL DEFAULT  'absent'