Missing content types in permissions

[amartincolby]

Describe the bug
All content types are not visible in the roles & permissions tab under public. I have confirmed that routes are associated with these content types.

Steps to reproduce the behavior

1. Download Strapi Docker
2. Create MySQL project with newest Beta (16.4)
3. Create various content types.
4. Check permissions for "public."

Expected behavior
I should see all content types under permissions.

Screenshots

Code snippets
If applicable, add code samples to help explain your problem.

System

• Node.js version: 10 LTS
• NPM version: 6.9.0
• Yarn version: v1.17.3
• Strapi version: Beta 16.4
• Database: MySQL 8
• Operating system: CentOS in Docker

Additional context
I re-cloned my repo to build a fresh local database volume. In my primary app, only one content type is not appearing. In my re-cloned project with a fresh database, nearly no types are appearing. Of note, in my primary project, along with the missing type, an option for delete is missing for one type.

[amartincolby]

Made progress. I'm able to get everything to display by dropping the users-permissions_user, users-permissions_role, and users-permissions_permission tables. Content-manager also now appears, which I did not previously realize was missing. I also now realize that User Permissions is missing.

[lauriejim]

Hello @amartincolby !
With the information you gave me, I'm not able to reproduce your issue.
Please can you give me a specific steps to reproduce the issue.
(You said, create various type of content, but it's not really precise, the name of the content type and attributes name/type can maybe have an impact)

[amartincolby]

Since Story is the one that failed to post, I'm attaching an image showing its structure.

Here is the model:

{
  "connection": "default",
  "collectionName": "Story",
  "info": {
    "name": "story",
    "description": "A story for general consumption"
  },
  "options": {
    "increments": true,
    "timestamps": [
      "created_at",
      "updated_at"
    ],
    "comment": ""
  },
  "attributes": {
    "headline": {
      "maxLength": 64,
      "default": "",
      "required": true,
      "minLength": 3,
      "type": "string"
    },
    "summary": {
      "maxLength": 255,
      "type": "string"
    },
    "media": {
      "collection": "file",
      "via": "related",
      "plugin": "upload"
    },
    "author": {
      "default": "",
      "minLength": 8,
      "type": "string"
    },
    "feedback": {
      "type": "string"
    },
    "body": {
      "minLength": 5,
      "required": true,
      "type": "richtext"
    },
    "publish": {
      "type": "date"
    },
    "keyword": {
      "type": "string"
    },
    "type": {
      "required": true,
      "enum": [
        "Standard",
        "Featured"
      ],
      "type": "enumeration"
    },
    "locations": {
      "collection": "location",
      "via": "stories"
    },
    "functions": {
      "collection": "function",
      "via": "stories"
    },
    "dls": {
      "collection": "dl",
      "via": "stories"
    },
    "businesses": {
      "collection": "business",
      "via": "stories"
    },
    "categories": {
      "collection": "category",
      "via": "stories"
    }
  }
}

And the routes:

{
  "routes": [
    {
      "method": "GET",
      "path": "/stories",
      "handler": "Story.find",
      "config": {
        "policies": []
      }
    },
    {
      "method": "GET",
      "path": "/stories/count",
      "handler": "Story.count",
      "config": {
        "policies": []
      }
    },
    {
      "method": "GET",
      "path": "/stories/:id",
      "handler": "Story.findOne",
      "config": {
        "policies": []
      }
    },
    {
      "method": "POST",
      "path": "/stories",
      "handler": "Story.create",
      "config": {
        "policies": []
      }
    },
    {
      "method": "PUT",
      "path": "/stories/:id",
      "handler": "Story.update",
      "config": {
        "policies": []
      }
    },
    {
      "method": "DELETE",
      "path": "/stories/:id",
      "handler": "Story.delete",
      "config": {
        "policies": []
      }
    }
  ]
}

I don't actually know if Story had anything to do with the problem, honestly. Again, the behavior with my populated application, and the virgin one that I built specifically for testing, was different. The code files were the same, though.

I've attached a dump of the test DB.

This DB represents this state in the UI

test_db.sql.zip

[ilin-in]

Experiencing the same issue, some of the content-types in application section of Roles & Permissions are disappearing (but still visible in content-types on top left bar) and appearing again only after restarting service.

[lauriejim]

Can you provide steps to reproduce, please.
Until I haven't a step by step, it's hard for me to understand and help :/

[ilin-in]

I was not able to reproduce this issue again, it could be connected to cases when you manually changing some sort of data.

[derrickmehaffy]

the only time (and it's been a while) I could reproduce something like this is using the offline strapi generate:api command, once in a blue moon strapi doesn't check if the permission nodes for that model are there and "forgets" to add them.

[pitiboy]

Addition: I experience the same with my strapi instance that it is not avialable for public role.

I can see correctly for the Authenticated role everything as expected:

The table I have is very simple, but it think it is not related to that:

I had used the default sqlite database in development, and the table suggests the same:

When I inserted manually the missing lines to table users-permissions_permission as a workaround, it had resolved itself.

interestingly, I have another strapi instance, where this had been operating well, as expected, ande it worked for the 4th attempt on the original issue.

Also when I changed the database configuration from dev/sqlite to staging/postgresql, the users-permissions_permission entries were inserted correctly (after the migration)