ERROR: NOT NULL constraint failed

Issue #349 duplicate
Former user created an issue

I am trying to add a new column to my table with the NOT NULL constraint, bu it gives my the following error: NOT NULL constraint failed.

Comments (3)

  1. phpLiteAdmin repo owner

    You specify that a new column must have a value in a table that already has rows. These rows cannot already have values in there. So how can this constraint work out? --> You need to specify a DEFAULT value (which must not be NULL) for this column that will be assigned to the existing columns.

    Please first think about your issue, then search your issue and only if both fail, post a bug report. You would have found at least issue issue #344 where someone had the exact same problem.

  2. Log in to comment