Bug - Admin/Users->Custom fields in user profile.

Question

Field names does not show up.

 

 

Extra fields on user profile:

- edit field  - edit field  - edit field  - edit field Add new field

 

I migrated the database from 1.4.3.

Answer 1

It seems like the qa_userfields table has empty string values for the content column on these default fields, rather than NULL as it should be. Can you confirm?

Comments

Yes.

This is fragment of my dump:
INSERT INTO `qa_userfields` (`fieldid`, `title`, `content`, `position`, `flags`) VALUES
 ('1','name','','1','0'),
 ('2','location','','2','0'),
 ('3','website','','3','2'),
 ('4','about','','4','1');

- NULL values are written as "\N" in my dumper.

---

OK, so this explains it. I don't know how this happened, but you can fix it by running this query:

UPDATE qa_userfields SET content=NULL where content="";

---

Also, adding new fields is okay.