Error inserting new row

[Former user]

When I tried to insert a new row into my table called "purchases", I received the error message as below: -

ERROR: NOT NULL constraint failed: purchases.id This may be a bug that needs to be reported at https://bitbucket.org/phpliteadmin/public/issues?status=new&status=open

I'm not sure what the "NOT NULL constraint" means. Attached is the screenshot of my current table structure.

[phpLiteAdmin]

Your table has NOT NULL set for the id column, thus when inserting a row, you need to insert something in the id field. If you want SQLite to increase the id automatically so you don't have to input something every time, use 'autoincrement'.

[phpLiteAdmin]

not a bug