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