First time here? Check out the FAQ!

Revision history  [back]

tag vs. tagname in database

Hi,

I am new to Askbot. I have already has the data file for question. I want to import these things into my askbot forum. I import directly through mysql shell from the text file (.csv) to "question" table. In this table, I noticed that a field name "tagnames". Hence I don't know what is the meaning of field tagnames in question table. But this field is a "NOT NULL" field. Could you please explain why we should have "tagnames" field? I also have to import all the "tag" table and "question_tags" table to do a search using tag.

I have also done the following experiment.

--

I have 3 questions in my database.

Question 1. tagnames="physics", tag="test""image". //import from file -> directly go to database then use admin UI to add tag

Question 2. tagnames="physics", tag="test""image". //import from file

Question 3. tagnames="test" "image", tag="test""image". //submit through UI

As I expect, when I click on "test" tag (question 3), it show up all the 3 questions. However, when start over, click on the tag "physics" of either question 1 or 2, it show nothing (no matched tag). (I expected when click on physics, it show up question 1 and 2).

--

Then, what is happened behind the scene of clicking the tag?

Thank

tag vs. tagname in database

Hi,

I am new to Askbot. I have already has the data file for question. I want to import these things into my askbot forum. I import directly through mysql shell from the text file (.csv) to "question" table. In this table, I noticed that a field name "tagnames". Hence I don't know what is the meaning of field tagnames in question table. But this field is a "NOT NULL" field. Could you please explain why we should have "tagnames" field? I also have to import all the "tag" table and "question_tags" table to do a search using tag.

I have also done the following experiment.

--

-- I have 3 questions in my database.

database. Question 1. tagnames="physics", tag="test""image". //import from file -> directly go to database then use admin UI to add tag

tag Question 2. tagnames="physics", tag="test""image". //import from file

file Question 3. tagnames="test" "image", tag="test""image". //submit through UI

As I expect, when I click on "test" tag (question 3), it show up all the 3 questions. However, when start over, click on the tag "physics" of either question 1 or 2, it show nothing (no matched tag). (I expected when click on physics, it show up question 1 and 2).

--

Then, what is happened behind the scene of clicking the tag?

Thank