Skip to content

DB Inconsistencies #27

@nearwood

Description

@nearwood

Uploaded files were throwing errors about nullable columns. Prod doesn't seem to have this issue but a contributor did and I did upon starting up the project on my local.

$st = $this->db->prepare("INSERT INTO metadata (url,msq,engine,fileFormat,signature,uploadDate) VALUES (:url, :id, :engine, '4.0', 'unknown', :uploaded)");

The insert statement does not insert all metadata fields, but this works in prod somehow. Some DB update probably changed default behavior. Solution may be to just make the columns nullable. Yeah, that's real easy than trying to track this down.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions