{"action":"created","issue":{"url":"https://api.github.com/repos/interchange/interchange6-schema/issues/149","labels_url":"https://api.github.com/repos/interchange/interchange6-schema/issues/149/labels{/name}","comments_url":"https://api.github.com/repos/interchange/interchange6-schema/issues/149/comments","events_url":"https://api.github.com/repos/interchange/interchange6-schema/issues/149/events","html_url":"https://github.com/interchange/interchange6-schema/issues/149","id":52720466,"number":149,"title":"FreeBSD mysql 5.6.22 smoker fail (was: Invalid default value for 'public in reviews)","user":{"login":"racke","id":143678,"avatar_url":"https://avatars.githubusercontent.com/u/143678?v=3","gravatar_id":"","url":"https://api.github.com/users/racke","html_url":"https://github.com/racke","followers_url":"https://api.github.com/users/racke/followers","following_url":"https://api.github.com/users/racke/following{/other_user}","gists_url":"https://api.github.com/users/racke/gists{/gist_id}","starred_url":"https://api.github.com/users/racke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/racke/subscriptions","organizations_url":"https://api.github.com/users/racke/orgs","repos_url":"https://api.github.com/users/racke/repos","events_url":"https://api.github.com/users/racke/events{/privacy}","received_events_url":"https://api.github.com/users/racke/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/interchange/interchange6-schema/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/interchange/interchange6-schema/labels/tests","name":"tests","color":"fbca04"}],"state":"closed","locked":false,"assignee":{"login":"SysPete","id":6115812,"avatar_url":"https://avatars.githubusercontent.com/u/6115812?v=3","gravatar_id":"","url":"https://api.github.com/users/SysPete","html_url":"https://github.com/SysPete","followers_url":"https://api.github.com/users/SysPete/followers","following_url":"https://api.github.com/users/SysPete/following{/other_user}","gists_url":"https://api.github.com/users/SysPete/gists{/gist_id}","starred_url":"https://api.github.com/users/SysPete/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SysPete/subscriptions","organizations_url":"https://api.github.com/users/SysPete/orgs","repos_url":"https://api.github.com/users/SysPete/repos","events_url":"https://api.github.com/users/SysPete/events{/privacy}","received_events_url":"https://api.github.com/users/SysPete/received_events","type":"User","site_admin":false},"milestone":null,"comments":8,"created_at":"2014-12-23T07:40:09Z","updated_at":"2015-04-07T08:18:03Z","closed_at":"2015-03-19T15:00:25Z","body":"http://www.cpantesters.org/cpan/report/921ffe4e-8a09-11e4-a19c-5e32e0bfc7aa\r\n\r\n```\r\nUse of uninitialized value $mysql_ver in numeric lt (<) at /usr/perl5.20.0/lib/site_perl/5.20.0/DBIx/Class/Storage/DBI/mysql.pm line 117.\r\nDBIx::Class::Storage::DBI::catch {...} (): DBIx::Class::Storage::DBI::try {...} (): DBI Exception: DBD::mysql::db do failed: Invalid default value for 'public' [for Statement \"CREATE TABLE `reviews` (\r\n  `reviews_id` integer NOT NULL auto_increment,\r\n  `sku` varchar(64) NOT NULL,\r\n  `title` varchar(255) NOT NULL DEFAULT '',\r\n  `content` text NOT NULL,\r\n  `users_id` integer NOT NULL,\r\n  `rating` numeric(4, 2) NOT NULL DEFAULT 0,\r\n  `recommend` enum('0','1') NULL,\r\n  `public` enum('0','1') NOT NULL DEFAULT false,\r\n  `approved` enum('0','1') NOT NULL DEFAULT false,\r\n  `created` datetime NOT NULL,\r\n  INDEX `reviews_idx_sku` (`sku`),\r\n  INDEX `reviews_idx_users_id` (`users_id`),\r\n  PRIMARY KEY (`reviews_id`),\r\n  CONSTRAINT `reviews_fk_sku` FOREIGN KEY (`sku`) REFERENCES `products` (`sku`) ON DELETE CASCADE ON UPDATE CASCADE,\r\n  CONSTRAINT `reviews_fk_users_id` FOREIGN KEY (`users_id`) REFERENCES `users` (`users_id`) ON DELETE CASCADE ON UPDATE CASCADE\r\n) ENGINE=InnoDB\"] at /usr/home/eserte/.cpan/build/Interchange6-Schema-0.060_92-u59YO3/blib/lib/Interchange6/Schema.pm line 84\r\n```"},"comment":{"url":"https://api.github.com/repos/interchange/interchange6-schema/issues/comments/90454481","html_url":"https://github.com/interchange/interchange6-schema/issues/149#issuecomment-90454481","issue_url":"https://api.github.com/repos/interchange/interchange6-schema/issues/149","id":90454481,"user":{"login":"SysPete","id":6115812,"avatar_url":"https://avatars.githubusercontent.com/u/6115812?v=3","gravatar_id":"","url":"https://api.github.com/users/SysPete","html_url":"https://github.com/SysPete","followers_url":"https://api.github.com/users/SysPete/followers","following_url":"https://api.github.com/users/SysPete/following{/other_user}","gists_url":"https://api.github.com/users/SysPete/gists{/gist_id}","starred_url":"https://api.github.com/users/SysPete/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SysPete/subscriptions","organizations_url":"https://api.github.com/users/SysPete/orgs","repos_url":"https://api.github.com/users/SysPete/repos","events_url":"https://api.github.com/users/SysPete/events{/privacy}","received_events_url":"https://api.github.com/users/SysPete/received_events","type":"User","site_admin":false},"created_at":"2015-04-07T08:18:03Z","updated_at":"2015-04-07T08:18:03Z","body":"@ribasushi here's what happens with DBIx::Class@0.082899_08 using MySQL server v5.6.22:\r\n```\r\nDBIx::Class::Storage::DBI::_do_query(): DBI Exception: DBD::mysql::db do failed: Variable 'sql_mode' can't be set to the value of 'TRADITIONALNO_ENGINE_SUBSTITUTION' [for Statement \"SET SQL_MODE = CONCAT('ANSI,TRADITIONAL', @@sql_mode)\"] at /home/apm/git/interchange6-schema/lib/Interchange6/Schema.pm line 84\r\n    # Child (testing with main) exited without calling finalize()\r\n```\r\nWith MySQL server v5.5.41 and DBIx::Class@0.082899_08 all tests pass as they did before. Using the same DBIC with either MySQL version post  d6464b2 all tests pass."}}