directus/v6-archive

Unable to select 'User' in User Interface type after an table import

Open

#36 opened on Oct 25, 2018

View on GitHub
 (0 comments) (0 reactions) (0 assignees)JavaScript (4 forks)auto 404
4. MinorInterfacebughelp wantedv6

Repository metrics

Stars
 (2 stars)
PR merge metrics
 (PR metrics pending)

Description

From directus created by spawnrider : directus/directus#2084

Version Info

  • Directus version and branch: Using Directus Docker 6.4 version
  • PHP version: 7.1.2
  • MySQL version: 5.5
  • Web server: Apache
  • OS name and version: Windows 10

Expected Behavior

I imported an table from another environment. I want to manage it on Directus. This table contains a column of type INT(11). This column was of "User" User interface type on the source environment. It would be also of "User" type on this environment.

Actual Behavior

On this environment, the type is NUMERIC and cannot be switch back to "User".

Steps to Reproduce

  1. Create a table with "User" field of type "User" on an environment
  2. Copy this table using SQL / PhpMyAdmin to another environment
  3. Manage this table on this new environment.
  4. The "User" field is now of type "NUMERIC" and not "User".

Schema Dump, Logs, or Screenshots

directus_user_issue

Contributor guide

Research direction
Investigate how Directus maps field types during table import, specifically why a User type becomes NUMERIC, and check if the User type requires special metadata or joins.
Tech stack
phpjavascript
Domain
backenddatabase
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
SQLDatabase management
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60