Rutger van Dijk
Posts: 0
Joined: Tue Aug 21, 2012 9:04 am

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

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

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

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

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.

Rutger van Dijk
Posts: 0
Joined: Tue Aug 21, 2012 9:04 am

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

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.

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

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

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)?

Rutger van Dijk
Posts: 0
Joined: Tue Aug 21, 2012 9:04 am

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

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.

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

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

This will be fixed in production on Thursday.

Return to “Issues”