Page 1 of 1

Can't add/edit/remove column in Users table in database

Posted: Mon Oct 01, 2012 12:52 pm
by Rutger van Dijk

Probably I have added a column named 'username' to the Users table in database eventhough this already existed.

Because of this I can't remove this column or add another one. If I change the value in one username column the other is updated to.

Can you remove the 'username' column for me? Image


Can't add/edit/remove column in Users table in database

Posted: Mon Oct 01, 2012 1:52 pm
by maxkatz

That's probably the reason, we'll add validation to column with such name can't be added to User collection. Probably the simplest way to solve this right now is do delete this database and create a new one.


Can't add/edit/remove column in Users table in database

Posted: Mon Oct 01, 2012 2:08 pm
by Rutger van Dijk

Creating a new db shouldn't be a problem. But in new db I still can't add new column to the Users table.

I have had 3 different scenario's:

  1. Create column button doesn't do anything when I click it.

  2. Create column popup is closed but no new column. Can do same thing multiple times without problem.

  3. Create column popup is closed but no new column. If I try again I get message that column is already existing, but not visible in list.

    I am using Chrome btw.


Can't add/edit/remove column in Users table in database

Posted: Mon Oct 01, 2012 3:36 pm
by maxkatz

Create new column doesn't work in Firefox.. but I was able create new columns in Chrome.

How did you create the new 'username' column (from screen shot)?


Can't add/edit/remove column in Users table in database

Posted: Tue Oct 02, 2012 10:30 am
by Rutger van Dijk

I will try different browser and have a look.

About 'username' column: I have no idea when/if I have done this. I was not using the table in code, and when I wanted to use the table I wanted to add name field. At that moment I saw the duplicate columns.


Can't add/edit/remove column in Users table in database

Posted: Tue Oct 02, 2012 2:57 pm
by maxkatz

This will be fixed in production on Thursday.