Jira (PUP-2146) Puppet dashboard uses invalid SQL on MySQL 5.7

[Morgan Tocker (JIRA)]

Title: Message Title

Morgan Tocker commented on an issue   Re: Puppet dashboard uses invalid SQL on MySQL 5.7 Issue can be fixed by changing table definition to remove DEFAULT NULL: {pre} CREATE TABLE `assignments` (`id` int(11) auto_increment PRIMARY KEY, `node_id` int(11), `service_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB;{pre} I looked at the github project - and it appears the assignments table is no longer used. Add Comment   Puppet / PUP-2146 Puppet dashboard uses invalid SQL on MySQL 5.7 Mysql::Error: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead: CREATE TABLE `assignments` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `node_id` int(11), `service_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB This message was sent by Atlassian JIRA (v6.1.4#6159-sha1:44eaede) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.