Cant integrate with latest blue iris

[i-am-shodan]

I'm trying to get this software working with blue iris version 5.9.9.98 and codeproject.ai.

I've got blue iris and code project AI working well with object and plate detection. When I get an alert I can see the car detection and confidence and the plate.

By in ALPR database I see nothing. In the logs I see:

Error processing request: SyntaxError: Bad control character in string literal in JSON at position 719

Error processing request: error: null value in column "id" of relation "plate_reads" violates not-null constraint

I'm using the http alert action straight from the project.

Any ideas on how to debug?

[BigTonyTones]

I believe I am having the same issue on a fresh new install.
Find a solution?

[ERROR] Error processing request: error: null value in column "id" of relation "plate_reads" violates not-null constraint

[shall4]

I am using BI v6 and and seeing same error in the log: Error processing request: error: null value in column "id" of relation "plate_reads" violates not-null constraint

I dumped the &JSON macro that is being received by ALPR-Database. Candidates for this error are "message" and "moduleid".

{
"ai_dump": [
{
"api": "objects",
"found": {
"success": true,
"error": null,
"message": "",
"predictions": [
{
"category": 2,
"label": "7",
"confidence": 0.920829653739929,
"x_min": 510,
"x_max": 1917,
"y_min": 2,
"y_max": 681,
"plate": "10755AA"
}
],
"count": 1,
"moduleId": "",
"executionProvider": "ONNXRunTime",
"analysisRoundTripMs": 97
}
},
{
"api": "alpr",
"found": {
"success": true,
"error": null,
"message": "",
"predictions": [
{
"category": 2,
"label": "license-plate",
"plate": "10755AA",
"confidence": 0.732635319232941,
"x_min": 1543,
"x_max": 1757,
"y_min": 388,
"y_max": 449
}
],
"count": 1,
"moduleId": "",
"executionProvider": "ONNXRunTime",
"analysisRoundTripMs": 49
}
}

[BigTonyTones]

I have fixed the issue here is the fix
I ran this in the console section of portainer. I was in container alpr_database-db-1

#to get into PostgresSQL

psql -U postgres

#Then I applied this fix. Just copy and paste it

-- Create a sequence for the id column
CREATE SEQUENCE IF NOT EXISTS plate_reads_id_seq;

-- Attach the sequence to plate_reads.id
ALTER TABLE plate_reads
ALTER COLUMN id SET DEFAULT nextval('plate_reads_id_seq');

-- Ensure proper ownership
ALTER SEQUENCE plate_reads_id_seq
OWNED BY plate_reads.id;

-- Sync the sequence with existing rows
SELECT setval(
'plate_reads_id_seq',
COALESCE((SELECT MAX(id) FROM plate_reads), 1),
true
);

[shall4]

Thanks, BigTonyTones. This worked for me as well.