1. phpLiteAdmin Avatar phpLiteAdmin
  2. phpLiteAdmin
  3. public
  4. Issues

Unable to add "not null" fields

Issue #344 invalid
Former user created an issue

When adding fields to a table that exists, if NOT NULL is checked, there is an error.

Comments (5)

  1. phpLiteAdmin repo owner

    If your table already contains rows and you add a column with a NOT NULL constraint, you also need to provide a DEFAULT value (that is not NULL). Otherwise, existng rows violate the NOT NULL constraint and thus you get an Error. This is not a bug, it is a mistake of the user.

  2. phpLiteAdmin repo owner

    Please next time you post a bug Report: copy the exact error messge! And read it. Don't just say "there is an error".

  6. Log in to comment
Assignee
–
Type
bug
Priority
minor
Status
invalid
Component
ALTER TABLE
Milestone
1.9.8
Version
1.9.7
Votes
0
Watchers
None
Jira: the preferred issue tracker for Bitbucket. Join the team!