Full ALPR Database System for Blue Iris!

[tmushy]

Anyone ever figure out the solution to Error processing request: error: null value in column "id" of relation "plate_reads" violates not-null constraint
I ran two fresh install on two different systems, and still same issue

 

[Vettester]

I ran two fresh install on two different systems, and still same issue

I've installed this on multiple machines for other users and have never seen this error. Are you using the the updated migrations.sql file?

 

[tmushy]

I've installed this on multiple machines for other users and have never seen this error. Are you using the the updated migrations.sql file?

This is a fresh install using the script. Iv googled it and others are having the same issue.

I'm also using version 6 of blueiris if it makes a difference

 

[Vettester]

This is a fresh install using the script. Iv googled it and others are having the same issue.

I'm also using version 6 of blueiris if it makes a difference

The version of BI doesn't matter. Does your file structure look like this?

 

[tmushy]

The version of BI doesn't matter. Does your file structure look like this?

View attachment 235226

Im running in Ubuntu 25 . I have had this working before but it stopped after watch tower did some update to the database. So I started fresh

 

[Vettester]

Sorry, but I'm not familiar with Ubuntu