Re: SQLSTATE[HY000]: General error: 1296 Got error 839 'Illegal null attribute' from NDBCLUSTER [updated]

[Sucre Sucre]

Thanks for your reply, Jon.

Just simple insert statement like "insert into supcs_recordings(project_id) value(1027);"

before that what I did is:

I first created the table with the field setting:
`checked` tinyint NOT NULL

and then I altered it with:
ALTER TABLE supcs_recordings CHANGE checked checked tinyint NOT NULL DEFAULT '0';

NDB version: 8.0.21



What I did to solve the problem and it worked: deleted the table and recreated with the DEFAULT VALUE setting set in the create table statement.

Sincerely,
Sucre