Uploading file to collection with alternative primary key fails

[rijkvanzanten]

Bug Report

When you have a collection that uses a primary key that's called something else then id, uploading a file fails. This is due to the fact that the API tries to use the name of the primary key field of the collection in directus_files, which fails:

{
    "error": {
        "code": 9,
        "message": "Failed generating the SQL query.",
        "query": "SELECT `directus_files`.`id` AS `id`, `directus_files`.`storage` AS `storage`, `directus_files`.`filename` AS `filename`, `directus_files`.`title` AS `title`, `directus_files`.`type` AS `type`, `directus_files`.`uploaded_by` AS `uploaded_by`, `directus_files`.`uploaded_on` AS `uploaded_on`, `directus_files`.`charset` AS `charset`, `directus_files`.`filesize` AS `filesize`, `directus_files`.`width` AS `width`, `directus_files`.`height` AS `height`, `directus_files`.`duration` AS `duration`, `directus_files`.`embed` AS `embed`, `directus_files`.`folder` AS `folder`, `directus_files`.`description` AS `description`, `directus_files`.`location` AS `location`, `directus_files`.`tags` AS `tags`, `directus_files`.`metadata` AS `metadata` FROM `directus_files` WHERE `q_nummer` = '' LIMIT 1"
    }
}

The WHERE q_nummer = '' is wrong. I think this is supposed to be WHERE id = '1'.

[rijkvanzanten]

Super quick fix, well done @wellingguzman 👏🏻