What should I do if the TAG tag in DedeCMS cannot be saved and automatically deleted?

What should I do if the TAG tag of DedeCMS cannot be saved and automatically deleted?

A few months ago, I upgraded to 5.5. Unfortunately, TAG malfunctioned. The specific problem was: when publishing an article in the background, TAG could not be saved and was automatically deleted. I studied it carefully today and found that new TAGs are not saved, but previously filled TAGs can be saved. For example, if I fill in the tags "Computer, Computer Tutorials, Word", only two TAGs "Computer, Word" may be displayed after publishing.

Recommended study: 梦Weavercms

Originally it was judged that the problem was with the program, but when using this database with other normally used programs, the problem remains; then it must be There is a problem with the database. There is a "SQL command runner" in the DedeCMS background. You can see all the data tables of DedeCMS. Here I found two TAG tables, "dede_tagindex" and "dede _taglist". Select one of the tables and click Check the table structure and compare it with other programs to find the problem.

dede_tagindex This table is missing a "`typeid` smallint(5) unsigned NOT NULL default '0'," field, "`tag` char(20) NOT NULL default ''," should be 12, Mine turned into 20.

dede _taglist This table has an additional "KEY `aid` (`aid`)" field.

The problem has been found. The next step is how to add, delete and modify it. The specific method is as follows:

Enter phpmyadmin and click the database drop-down menu on the left to select your website database. , scroll to the bottom, find the "dede_tagindex" table (the Dede in front is the name when you installed it, it may be different), click it to open, then the table structure will be displayed on the right, add a typeid field after the tag, as shown in the figure Display:

The place in the red line box in the picture is to add a new field

Fill in the content of the new field as follows:

（＝ There is no need to fill in the following blanks)

字段＝typeid
型＝SMALLINT
度/值*1＝5
整理＝
属性＝UNSIGNED
Null＝not null
默认2＝0
额外＝

After completing the filling, click Save.

In the tag field "`tag` char(20) NOT NULL default ''," change the length value to 12.

Click change after the tag field and change the length/value to 12

dede _taglist The extra "KEY `aid` (` aid`)" field, just go in and delete it directly.

Add a new TAG tag to see if it is OK!

The above is the detailed content of What should I do if the TAG tag in DedeCMS cannot be saved and automatically deleted?. For more information, please follow other related articles on the PHP Chinese website!