ZionniteOriginal post
Rank 4: Virtual Machine
hello everyone, i'm trying to create tables via the cli but its not working, it keep saying NO TABLEs FOUND, here are my json structure
profile.json
Plain text
"$id": "profiles", "databaseId": "68cda74900313f405a6b", "name": "Profiles", "enabled": true, "rowSecurity": true, "permissions": [ "read(\"any\")", "create(\"users[USER_ID]\")", "update(\"users[USER_ID]\")", "delete(\"users[USER_ID]\")" ], "columns": [ { "key": "userId", "type": "string", "size": 36, "required": true }, { "key": "username", "type": "string", "size": 50, "required": true }, { "key": "fullName", "type": "string", "size": 100, "required": true }, { "key": "bio", "type": "string", "size": 500, "required": false, "default": "" }, { "key": "avatar", "type": "string", "size": 255, "required": false, "default": null }, { "key": "postsCount", "type": "integer", "required": false, "default": 0 }, { "key": "commentsCount", "type": "integer", "required": false, "default": 0 }, { "key": "likesCount", "type": "integer", "required": false, "default": 0 }, { "key": "createdAt", "type": "datetime", "required": true }, { "key": "updatedAt", "type": "datetime", "required": true } ], "indexes": [ { "key": "userId_unique", "type": "unique", "columns": ["userId"], "orders": ["ASC"] }, { "key": "username_search", "type": "fulltext", "columns": ["username"], "orders": ["ASC"] } ]}Summary
Developers are having trouble creating a table using the Appwrite CLI due to an error stating "Param 'attributes' is not optional." The JSON structure seems correct, but the issue persists.
Solution: The error indicates that the 'attributes' parameter is missing when creating the table. Ensure that all required attributes are included when creating the table to resolve this problem.