Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
0 votes
484 views
in Q2A Core by

Field names does not show up.

 

 

Extra fields on user profile:

 

I migrated the database from 1.4.3.

Q2A version: 1.5

1 Answer

+1 vote
by
selected by
 
Best answer

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?

by
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.
by
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="";
by
Also, adding new fields is okay.
...