ERROR: UNIQUE constraint failed: users.id
Issue #350
invalid
wont let me create a new column https://bitbucket.org/phpliteadmin/public/issues?status=new&status=open
Comments (4)
-
repo owner -
repo owner Of course, you also cannot add a new column with a unique constraint to a table that already contains rows, as these rows violate the unique constraint. So you would need to add the new column without the unique constraint, then make the values of the existing rows unique and then add the unique constraint to the new column.
-
repo owner - removed milestone
-
repo owner - changed status to invalid
Not enough feedback from the user. Most likely the user doesn't understand what he's doing...
- Log in to comment
Are you creating a new column or a new row? Unique constraint failed means that in your table the values of some column (here id) must be unique. This means when you insert a new row, you need to give a value that does not exist yet in the table. Please give more details