search

psecio / gatekeeper

Gatekeeper: An Authentication & Authorization Library
367 stars 23 forks source link

Upstream phinx issue with MySQL >= 5.6 prevents setup #39

Closed Awnage closed 9 years ago

Awnage commented 9 years ago

As of MySQL 5.6 the default is to enable STRICT_TRANS_TABLE which blows up the phinx log table creation. They are unwilling to add the appropriate patch due to Travis's MySQL version incompatibility. See: https://github.com/robmorgan/phinx/issues/243

To disable STRICT_TRANS_TABLE you need to edit /etc/my.cnf (and /usr/my.cnf on CentOS)

sql_mode=NO_ENGINE_SUBSTITUTION

I have submitted a new patch (https://github.com/robmorgan/phinx/pull/638) that will hopefully be accepted...

enygma commented 9 years ago

Lovely...seems like while Phinx is a good tool, it's getting really far behind on handling user contributed updates (I put in one of my own several months ago and it's yet to be handled).

Awnage commented 9 years ago

Closing as robmorgan/phinx#243 was merged.