Dedecms the tag tag that was added when the article was published disappears and cannot be added!

Today is still weaving dream just put on the website, debugging completed, want to update a few articles first. As a result, there was a problem with the article: it was my tag tag that didn't show up. Just edit the tag tag, the article was saved disappeared, and tag tag management inside is empty. Because it is the first encounter, so on the Internet to find the relevant weaving dream tutorial to solve. Found that a lot of friends have encountered this problem, such as "I use the dream CMS to do the site, but modify the article when the tag tag, modified and saved tag tag disappeared, how can not be added!" "Dede I added tag, how can I not find it in tag tag management?"

After some research finally found the crux of the problem where. Actually very simple, is a comma question:tag tag must use the English comma!!! Tag tag must use comma!!! Tag tag must use comma!!! but some of the online tutorials are all about database issues. The following are still weaving dream of these two solutions are listed:

One, comma problem

When publishing an article, multiple tag tags must be separated by commas in English, not commas in Chinese. Otherwise, the tag tag disappears and does not appear.

Second, the problem of the database

In dedecms all the data tables, there are two tag tables, respectively, "Dede_tagindex" and "Dede _taglist", select one of the tables, click to view the table structure, and then compare with other programs, found two problems.

1,dede_tagindex This table is missing a "' typeid ' smallint (5) unsigned NOT null default ' 0 '," field, "' Tag ' char (a) NOT null default ' '," should be 12, My turn is 20.

2,dede _taglist This table has a "KEY" aid (' aid ') field.

The problem is found, the next is how to add, delete and modify the problem, the specific method is as follows:

First, enter the phpMyAdmin inside click on the left Database drop-down menu, select your site database, pull to the bottom, find the "dede_tagindex" This table (the previous Dede is the name of your installation time, may be different), click on it to open, and then the right side will show the table structure, Add a typeid field after tag

The contents of the new field are filled in as follows:

(= empty after = not filled in)

field =typeid type =SMALLINT finishing = null=not null default 2=0 extra =

After completing, click Save.

Then, tag in this field "' Tag ' char (not NULL default ')," change the length value to 12.

Change the length/value to 12 by clicking on the changes following the tag field.

Finally, Dede _taglist the "KEY" aid (' aid ') field in this table, and go directly to delete it.

Then add a new tag tag to see if it's OK!

This article is from "Suqian bo zi" blog, please be sure to keep this source http://suqianbozai.blog.51cto.com/6261219/1846005

Dedecms the tag tag that was added when the article was published disappears and cannot be added!