Shulou(Shulou.com)06/02 Report--

This article mainly introduces the DedeCMS TAG tags can not be saved and automatically deleted solutions, has a certain reference value, friends in need can refer to. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

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

A few months ago, I upgraded 5.5. unfortunately, TAG malfunctioned. The specific problem is: post articles in the background, TAG can not save, automatically delete. If you study it carefully today, you won't save the new TAG, but you can save the TAG you filled in before. For example, I filled out a few TAG of "computer, computer tutorial, Word". After release, I may only display two TAG of "computer, Word".

Recommended study: dream weaving cms

The original judgment was that the program asked yes, but using this database with other programs in normal use, the problem remains the same. Then it must be the problem with the database. There is a "SQL command runner" in the DedeCMS background, where 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, click to view the table structure, and then compare with other programs to find the problem.

The dede_tagindex table is missing a field of "`typeid` smallint (5) unsigned NOT NULL default '0percent,"`tag` char (20) NOT NULL default''," which should be 12, and mine becomes 20.

The table dede _ taglist has an extra "KEY `aid` (`aid`)" field.

The problem is found, and then there is the question of how to add, delete, and modify it. The specific methods are as follows:

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

The red wireframe in the picture is to add a new field.

Fill in the contents of the new field as follows:

(no need to fill in the blank after that)

Field = typeid type = SMALLINT degree / value * 1 percent 5 finishing = attribute = UNSIGNEDNull=not null default 2 extra =

Click Save when you are finished.

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

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

The extra "KEY `aid` (`aid`)" field in the dede _ taglist table can be deleted directly.

Then add a new TAG tag to see if it is OK!

Thank you for reading this article carefully. I hope the editor can share the solution that the TAG tag of DedeCMS cannot be saved and deleted automatically. At the same time, I also hope you can support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.