# SQLite.jl NOT NULL constraint failed

**URL:** <https://discourse.julialang.org/t/sqlite-jl-not-null-constraint-failed/74628>\
**Category:** General Usage\
**Tags:** sqlite, sql\
**Created:** [January 14, 2022, 2:52pm UTC](https://discourse.julialang.org/t/sqlite-jl-not-null-constraint-failed/74628 "2022-01-14T14:52:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jeremy](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/jeremy/32/295_2.png) [@Jeremy](https://discourse.julialang.org/u/Jeremy)\
**Post date:** [January 14, 2022, 2:52pm UTC](https://discourse.julialang.org/t/sqlite-jl-not-null-constraint-failed/74628/1 "2022-01-14T14:52:04Z")

</div>

Since updating Julia from v1.6.2 (SQLite v1.2.0) to v1.7.1 (SQLite v 1.3.0) I get an error while trying to add data to an existing table in my database.

```julia
julia> dataBiomet |> SQLite.load!(db,"Biomet")
ERROR: SQLiteException("NOT NULL constraint failed: Biomet.ALB_1_1_1other")

```

The `SQLite.load!` function did receive some updates in the update from [1.2.0 to 1.3.0](https://github.com/JuliaDatabases/SQLite.jl/releases/tag/v1.3.0) but to me it doesn’t seem like it should cause a problem for my case. The database and all of its contents were created using [SQLite.jl](https://juliadatabases.org/SQLite.jl/stable/).

Here is the information returned by `SQLite.tableinfo(db,"Biomet")`:

```julia
cid = [0, 1, 2, 3, 4, 5, 6, 7, 8, 9 … 34, 35, 36, 37, 38, 39, 40, 41, 42, 43]
name = ["Timestamp", "ALB_1_1_1other", "CS_1_1_1other", "CS_2_1_1other", "CS_3_1_1other", "CS_4_1_1other", "CS_5_1_1other", "LWIN_1_1_1W_per_m2", "LWINraw_1_1_1W_per_m2", "LWOUT_1_1_1W_per_m2" … "TS_1_4_1C", "TS_1_5_1C", "TS_1_6_1C", "TS_2_1_1C", "TS_2_2_1C", "TS_2_3_1C", "TS_2_4_1C", "TS_2_5_1C", "TS_2_6_1C", "CHK"]
type = ["TEXT", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL" … "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "REAL", "INT"]
notnull = [1, 1, 1, 1, 1, 1, 1, 1, 1, 1 … 1, 1, 1, 1, 1, 1, 1, 1, 1, 1], dflt_value = [missing, missing, missing, missing, missing, missing, missing, missing, missing, missing … missing, missing, missing, missing, missing, missing, missing, missing, missing, missing]
pk = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0 … 0, 0, 0, 0, 0, 0, 0, 0, 0, 0])

```