IIS/MySQL New Instal SQL Error: SQLSTATE[HY000]: General error: 1364 Field 'edit' doesn't have a default value

[karldonteljames]

Just going to give this a try.

New install xibo : Error SQL during install

I think I can see why it might do that. Please can you edit db/migrations/20191205180116_add_playlist_dashboard_page_user_migration.php and at the bottom of the file, line 59 change the three INSERT statements as follows // Set Playlist Dashboard Page Permission $this->execute('INSERT INTO `permission` (`entityId`, `groupId`, `objectId`, `view`, `edit`, `delete`) SELECT '.$pageEntityId.', '.$groupId.', '.$playlistDashboardPageId.', 1, 0, 0'); // Set Library Page Permission $…

The Fix is proposed to be:

// Set Playlist Dashboard Page Permission
    $this->execute('INSERT INTO `permission` (`entityId`, `groupId`, `objectId`, `view`, `edit`, `delete`) SELECT  '.$pageEntityId.', '.$groupId.', '.$playlistDashboardPageId.', 1, 0, 0');

    // Set Library Page Permission
    $this->execute('INSERT INTO `permission` (`entityId`, `groupId`, `objectId`, `view`, `edit`, `delete`) SELECT  '.$pageEntityId.', '.$groupId.', '.$libraryPageId.', 1, 0, 0');

    // Set Users Page Permission
    $this->execute('INSERT INTO `permission` (`entityId`, `groupId`, `objectId`, `view`, `edit`, `delete`) SELECT  '.$pageEntityId.', '.$groupId.', '.$userPageId.', 1, 0, 0');